Description:
pgAdmin III is a powerful administration and development platform for the PostgreSQL database, free for any use. The application is running under GNU/Linux, FreeBSD and Windows 2000/XP.

Author: Dave Page & Dev. Team
Homepage: http://www.pgadmin.org/

App rating details:
Total votes: 2
Overall rating: 9.00

How'd this get started?:

Dave Page: Back around 1997, the only GUI interface to PostgreSQL was pgAccess which didn't work well on Windows. As I was using PostgreSQL in an environment with Linux in the machine room, and Windows on the desktops, I was stuck using the psql CLI. Numerous other users on the mailing lists complained of the same problem, and after an aborted prototype called pgManager, pgAdmin was born as a Visual Basic 5 application. Some years later, pgAdmin II was released as complete rewrite to resolve many of the early design flaws. Only a couple of years after that, we started again on pgAdmin III with the aim of making it fully cross platform, multi-lingual, and Unicode friendly.

What do you think are its best features?
Dave Page: First and foremost I'm proud of the fact that we can support users on Windows and various Unix-like platforms, in a wide variety of languages, with a variety of data encodings. We have a big userbase in Japan which we gained with pgAdmin III for example, not to mention users in countless other countries.

Only the functionality side, I think some of the more simple things are most important - pgAdmin supports all PostgreSQL object types, and pretty much every feature of each may be used. Personally I find the reverse engineered SQL very handy as well - even with a nice GUI, it's often useful to be able to just glance at a object definition in SQL format.

Our last release also began to integrate further with the server itself where possible. For example, on Windows systems pgAdmin can stop and start the local PostgreSQL service through the service control manager, and with a small set of server functions (on any server platform), we now allow the DBA to monitor logfiles remotely. In the development code, he or she can also edit the configuration files in a purpose built editor.


[ Download pgAdmin3 now! | Get Support for pgAdmin3 at LinuxQuestions.org ]