User Tools

Site Tools


database:pgsql:phppgadmin

phpPgAdmin

phpPGadmin is a web-based administration tool for PostgreSQL.

phppgadmin

Configuration

  • The file /conf/config.inc.php must be configured in order connect to a PostgreSQL Server
cp config.inc.php-dist config.inc.php
  • 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'] = '192.168.63.33';
 
// 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 (www.slony.info) 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/wiki.niwos.com/data/pages/database/pgsql/phppgadmin.txt · Last modified: 2009/08/15 19:23 (external edit)