This website uses cookies:
• from Cloudflare to identify trusted web traffic and protect this website. [__cfduid][read more]
• from Google Analytics to generate statistical data on how visitors uses this website (with IP anonymization). [_ga][read more]
• from Google AdSense (third party vendors, including Google) to deliver ads based on user prior visits to this website or other websites. [NID][read more]
Do you accept personalized website ads? AdSense cookies will be enabled/disabled based on your decision. You can change your mind 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