This website uses Google Analytics and Advertising cookies, used to generate statistical data on how visitors uses this website (with IP anonymization) and to deliver personalized ads based on user prior visits to this website or other websites. [read more]
These cookies are disabled by default until your Accept/Reject Consent.
The Consent can be changed at any time by accesing the ePrivacy button located at the bottom of every page. Enjoy your visit!

pgAdmin3 (III) with support for PostgreSQL 10,11,12,13

pgAdmin is a free software used for PostgreSQL database management.

As you may know, starting with pgAdmin 4, which is a WebApp, the former pgAdmin3 loses support for managing PostgreSQL servers version greater than 9.5. The latest pgAdmin3 official release is 1.22 and can still be used for PostgreSQL 10, 11, 12, 13, but with some missing features (ex failures to display the list of stored functions) and some strange errors.
But, thanks to the Open Source world, the pgAdmin3 it's not dead yet. It's quite alive.

Compile and install a patched pgAdmin 3 with support for PostgreSQL 10,11,12,13 - Ubuntu Desktop 20.04 LTS

An open-source version of a patched pgAdmin3 can be found here, a repo that we will use to compile and install pgAdmin3-LTS (v1.23b,BigSQL,forked) on our Ubuntu Desktop machine.

sudo apt install postgresql-server-dev-12 libwxgtk-media3.0-gtk3-dev
git clone
cd pgadmin3-lts
bash bootstrap
./configure --prefix=/usr/local --with-pgsql=/usr/lib/postgresql/12 --with-libgcrypt CFLAGS=-fPIC CXXFLAGS=-fPIC --with-wx-version=3.0
sudo make install

If everything worked as expected, create a Gnome application launcher for quick access: sudo nano /usr/share/applications/pgadmin3.desktop with bellow content, save it (Ctrl+X) and reload Gnome afterall (Alt+F2, r)

[Desktop Entry]


Install a patched pgAdmin 3 with support for PostgreSQL 10,11,12,13 - Windows and other Debian based Linux distros

For those who are not comfortable compiling software (yes, the aforementioned repo can be used to compile pgAdmin3 not only for Linux but also for Windows and macOS), I've found Victor Spirin from who is keeping alive up to date pgAdmin3 installers, for Windows and Debian, here: Thank you, Victor.

That's it, pgAdmin3 at least till the EOL of PostgreSQL 13


Share this post on your favorite networks.
© Copyright 2017 | Just another information technology blog - All Rights Reserved