pgAdmin3 Adjustment for PostgreSQL 11.0

What is my favourite PostgreSQL GUI-admin tool? pgAdmin3. I love its light weight user interface and simple navigation. Thanks to BigSQL Development Team for surviving the tool from freeze.

With PostgreSQL release 11.0, here is my patch file corresponding catalog table changes: pgadmin3-patch-text-file

First, clone pgAdmin3 project: clone git clone

Then, apply the patch: patch -p0 -i [patch-text-file]

Oldies but goldies.

  1. Laur said:

    Is there any 32 bit version?

  2. abdulyadi said:

    Laur, the project cloned from is source codes in cpp. You can try compile and build it on your 32 bit platform. Mine is 64 bits Fedora, an successfully build by issuing commands:
    (assuming i am in pgadmin3-lts directory)
    $bash bootstrap
    $./configure –prefix=[my-pgadmin3-directory-will-be] –with-pgsql=[my-postgresql-installation-directory] –with-libgcrypt CFLAGS=-fPIC CXXFLAGS=-fPIC
    $make install

  3. Laur said:

    Thank’s for your reply!

    I have Windows 10 installed.. So… I can’t follow your instructions.

    Best regards!

  4. abdulyadi said:

    Laur, if you managed cloning the project, you can find instructions on how to compile and link the project on Windows>=2000 in the INSTALL text file. Just go through it and find Windows section.

  5. Miguel said:

    Hi. Do you know any method for osx?

  6. Ron Smith said:

    I agree pgAdmin3 is the most productive dev env for postgresql. I was excited about your patch, but the bitbucket repo is offline. There’s a comment elsewhere that confirms this.

    Is it possible to access your copy of the repo? Or can you point me to someplace where’s available?

    I’m going to take a run at building a Windows version for my PG11.


  7. What is going on with bitbucket? I can’t seem to browse any public repos for a while.

  8. Igor Mekterović said:

    Repo is 404?

  9. Nicolas said:

    Most of the repos listed here are gone. I manaed to clone a that was forked from the bitbucket repo and apply the patch. But, unfortunalty I do not have the required tools to build the windwos version. Can someone help ?

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: