Postgresql 9.0 Centos Install and Config

Download repo


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'
listen '*'

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

To restore a DB

# psql -U -d -f

Comments are closed.