Installing postgres on CentOS - pg_hba.conf modifications

Install postgresql on CentOS - configure to connect with pgAdmin

1) # yum install postgresql postgresql-server
2) # chkconfig postgresql on
3) # service postgresql start
4) # sudo -s 
5) # su - postgres
6) $ psql -d template1 -U postgres
7) ALTER USER postgres WITH PASSWORD '<newpassword>';
8) \q
9) # cd /var/lib/psql/data
10) # vi pg_hba.conf

     Use password authentication (pgAdmin can connect!):

     # IPv4 local connections:
     host    all         all         127.0.0.1/32          md5
     # IPv6 local connections:
     host    all         all         ::1/128               md5
11) # service postgresql restart