User Tools

Site Tools



phpPGadmin is a web-based administration tool for PostgreSQL.



  • The file /conf/ must be configured in order connect to a PostgreSQL Server
  • This is an example to connect to a remote server:
// Display name for the server on the login screen
$conf['servers'][0]['desc'] = 'PostgreSQL Live';
// 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;
// Database SSL mode
// Possible options: disable, allow, prefer, require
$conf['servers'][0]['sslmode'] = 'allow';
// Change the default database only if you cannot connect to template1.
// For a PostgreSQL 8.1 server, you need to set this to 'postgres'.
$conf['servers'][0]['defaultdb'] = 'postgres';
// Specify the path to the database dump utilities for this server.
// You can set these to '' if no dumper is available.
$conf['servers'][0]['pg_dump_path'] = '/usr/bin/pg_dump';
$conf['servers'][0]['pg_dumpall_path'] = '/usr/bin/pg_dumpall';
// Slony ( support?
$conf['servers'][0]['slony_support'] = false;
// Specify the path to the Slony SQL scripts (where slony1_base.sql is located, etc.)
// No trailing slash.
$conf['servers'][0]['slony_sql'] = '/usr/share/pgsql';
$conf['default_lang'] = 'auto';
$conf['owned_only'] = true;
Make sure pg_hba.conf accepts connections from the server where phppgadmin is running.
/srv/ · Last modified: 2009/08/15 19:23 (external edit)