http://www.postgresql.org/about/
http://developer.postgresql.org/pgdocs/postgres/auth-pg-hba-conf.html
http://phppgadmin.sourceforge.net/doku.php
http://sql-info.de/postgresql/notes/installing-phppgadmin.html
http://developer.postgresql.org/pgdocs/postgres/auth-pg-hba-conf.html
http://phppgadmin.sourceforge.net/doku.php
http://sql-info.de/postgresql/notes/installing-phppgadmin.html
PostgreSQL Database
Install
# yum install postgresql
Configure
# vi /var/lib/pgsql/data/pg_hba.conf
A record can have one of the seven formats
local database user auth-method [auth-options] host database user address auth-method [auth-options] hostssl database user address auth-method [auth-options] hostnossl database user address auth-method [auth-options] host database user IP-address IP-mask auth-method [auth-options] hostssl database user IP-address IP-mask auth-method [auth-options] hostnossl database user IP-address IP-mask auth-method [auth-options]
eg
local all postgres trust
Run
# service postgresql start
Login
# su - postgres $ psql
Administration with phppgadmin
# wget http://downloads.sourceforge.net/phppgadmin/phpPgAdmin-5.0.2.tar.gz?download
allow superuser login
# vi /var/www/html/phppgadmin/conf/config.inc.php
and set extra_login_security = false
then goto http://localhost/phppgadmin/
Stop
# service postgresql stop
REFERRERS
HomePage
