Postgresql 9.0 Centos Install and Config

Posted by on August 11, 2011

Download repo

wget http://yum.pgrpms.org/reporpms/9.0/pgdg-centos-9.0-2.noarch.rpm

Install repo

rpm -i pgdg-centos-9.0-2.noarch.rpm

Install Postgres

yum install postgresql90-server

Initialise DB

service postgresql-9.0 initdb

Start Service

service postgresql-9.0 start

Turn levels on

chkconfig --levels 235 postgresql-9.0 on

Edit conf file

nano /var/lib/pgsql/9.0/data/pg_hba.conf

Change IDENT to TRUST at bottom of file (all fields)

Edit postgresql.conf

Change listen 'localhost'
to
listen '*'

If using phppgadmin, you need to edit config.inc.php and set security to false to use the web interface.

To restore a DB

# psql -U -d -f

VPS

Comments are closed.