PGAdmin3

[lmemsm]

We're using PostgreSQL at work. We've been using PGAdmin3 for a while now even though PGAdmin4 is available. PGAdmin4 is mainly browser based and can run slowly compared to the previous incarnation of PGAdmin. PGAdmin3 is a C++ program that uses the wxWidgets API and runs locally on a computer. PGAdmin3 is cross-platform, so it works on Windows, Linux, BSD and other systems where wxWidgets will run. My main issue the PGAdmin4 other than the slowness is the lack of the server status functionality which we use quite a bit with PGAdmin3. I did recently notice a dashboard option in PGAdmin4, but it doesn't give any real information on queries. The server status page basically gives a sortable table with the information from pg_stat_activity. I'd love to find a similar utility to provide this functionality, but so far, have not been able to. Suggestions would be greatly welcome.

Since I haven't been happy with PGAdmin4 and I do prefer PGAdmin3, why not keep running PGAdmin3? Debian has patches for PGAdmin3 to help keep it working with later versions of PostgreSQL. There are several forks of PGAdmin3 that attempted to keep it working once the official developers stopped development and switched to PGAdmin4. Combining some of these patches, I'm able to get a working version of PGAdmin3 built from source on Windows using wxWidgets (and the standard wxWidgets configuration settings I use on my system including --enable-stl). We needed a 64 bit version, so I built it with MinGW64 even though I typically prefer the original MinGW project and use it whenever possible. I should mention that the original PGAdmin3 source code never supported wxWidgets with STL enabled. I've also seen some reports of issues building for 64 bit systems instead of 32. Looking at the code, I can certainly see why those are issues. I went through and patched for both issues, including fixes for some problem areas that did not use best practices when converting from integers and longs to pointers and back. It's not perfect, but I have PGAdmin3 working with PostgreSQL 12 and providing the same functionality I used when I was working with PostgreSQL 9 databases.

I would love to find a fork that intends to actively continue development of PGAdmin3. Would be happy to add my efforts to such a project. If you know of a viable project, please advise. If there are no active forks, I intend to keep what I have running for as long as I need it at work. If others would like to help in that effort, it would be great to hear from them.

I also have PostgreSQL 12 built from source using MinGW64. We wanted to use pg_repack. I have not been able to find the pg_repack plug-in on Windows, so I built it from source as well. It needed some patching to compile successfully on Windows. I've been investigating what other PostgreSQL tools build on Windows using MinGW. So far, I have pgstats ( https://github.com/gleu/pgstats ) compiling. I may put in the effort to get pg_top working natively on Windows as well depending on whether we need the functionality or not. Suggestions of other cross-platform Open Source programs and utilities that would be useful with PostgreSQL would be greatly appreciated.
You contact me at: http://www.distasis.com/connect.htm
Write me if you want to help out.