Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

How to connect to postgresql 10+ database with pgAdmin 3?

I know that pgAdmin3 is now obsolete, but I still perfer it to pgAdmin4.
It was working fine up to PostgreSQL 9.* version, but when I try to connect to PostgreSQL 10 database I get:

enter image description here

Is there any workaround for this, or is this truly the end of pgAdmin III?

like image 736
igorludi Avatar asked Oct 29 '18 13:10

igorludi


People also ask

Is PostgreSQL 10 backwards compatible?

Version 10 has a number of backwards-incompatible changes which may affect system administration, particularly around monitoring and backup automation. As usual, PostgreSQL users should carefully test for the incompatibilities before upgrading in production.


1 Answers

The official pgAdmin3 has issues with PgSQL 10 and is no longer being developed, but there is a fork available at https://www.openscg.com/bigsql/pgadmin3/ which does work, and will continue to receive updates.

like image 178
facingup Avatar answered Dec 18 '22 01:12

facingup