phppgadmin(1M) NAME phppgadmin - Web based postgreSQL admin tool overview DESCRIPTION phppgadmin is opensource web-based administration tool for PostgreSQL. The tool's home page is http://sourceforge.net/projects/phppgadmin It can be configured to be used with any php supported webserver such as apache webserver. See apache2(1M). The apache webserver configuration file httpd.conf will need to be modified to enable PHP and to point to phppgadmin install location. An example apache httpd.conf file on solaris may include following lines (only significant components of interest are included here) : ServerRoot "/usr/apache2/2.2" DocumentRoot "/usr/postgres/phppgadmin" Include /etc/apache2/2.2/conf.d/php5.conf Also PHP installation should include the pgsql.so extension module to be able to connect to postgreSQL server. For example, PHP version 5.2.4 on Solaris delivers pgsql.so module in following location : /usr/php5/5.2.4/modules/pgsql.so : Another php config file pgsql.ini file enables this extension by default : /etc/php5/5.2.4/conf.d/pgsql.ini : This file contains single line: "extension=pgsql.so" to enable this extension. The /etc/phppgadmin/config.inc.php config file specifies user configurable parameters for the tool. For example, the default config.inc.php file includes following: // Display name for the server on the login screen $conf['servers'][0]['desc'] = 'PostgreSQL'; // Hostname or IP address for server. Use '' for UNIX domain socket. // use 'localhost' for TCP/IP connection on this computer $conf['servers'][0]['host'] = ''; // Database port on server (5432 is the PostgreSQL default) $conf['servers'][0]['port'] = 5432; The parameters can be changed as desired. For the brief description of all the supported parameters, see the default config file. FILES The following files specify the installation locations for phppgadmin: /usr/postgres/phppgadmin Contains all the files for the tool. /etc/phppgadmin/confi.inc.php The tool's configuration file. /usr/postgres/phppgadmin/conf/config.inc.php-dist The reference read only config file that can be copied over to /etc/phppgadmin/config.inc.php if needed. /usr/postgres/phppgadmin/INSTALL Contains additional information about initial configuration. /usr/postgres/phppgadmin/FAQ Frequently asked questions of the tool. SEE ALSO postmaster(1), apache2(1M), php(1) http://sourceforge.net/projects/phppgadmin http://www.php.net http://www.postgresql.org