phpPgAdmin is a Web interface that can be used in order to administrate a
PostgreSQL server locally or over the Internet.
This package requires a Web Server with a PHP Module with PostgreSQL support. The requirements are not that bad as they sound because here's a really nice solution for all your requirement problems,
PHP Apache Module.
This project is a fork of
phpMyAdmin project which was designed for the Web administration of the primary Open Source competitor of the PostgreSQL server,
MySQL. My first impression when I saw the interface of this administrative module was the fact that is a little bit easier to use that it's roots, phpMyAdmin, and it looks better.
I couldn't use it right after installing the package. This has happened because there are certain situations when the login is disallowed. The solution was the producer's FAQ where I could find the solution. For security reasons the login from accounts that have blank passwords or they use names like: pgsql, postgres, root or administrator is deactivated.
You can enable the usage from these accounts and kind of situations by editing the config.inc.php file. You can find it into the 'config' folder that comes with the package. In oder to use that change the setting
$conf['extra_login_security'] from
true to
false.
I like the fact that you can administrate multiple Web servers from a single interface. Another thing that I like is the fact that the interface is very well structured and you can have a very nice administration using this tool. The SQL queries can be executed pretty fast, the debug output is very good and you can edit a query after executing it in order to run it again.
Pluses: is an easy to use and install Web administration tool for a PostgreSQL server.
Drawbacks / flaws: In conclusion: a very good package that can help a PostgreSQL server administrator by providing a Web frontend, instead of using a command line PostgreSQL administration interface.
version reviewed: 4.0.1
pick 
