Installation and configuration of Postgresql 9 server on Centos 6

1. download the postgresql sever bin file.

2. make the binary file executable.

#chmod +x  postgresql-9.1-..bin

#./postgresql-9.1-..bin

3. Now edit pg_hba.conf file and postgresql.conf file to make postgresql database accessable from network.

Go to postgresql folder and search pg_hba.conf under data directory.

#vi pg_hba.conf

Under the line ip4 local connections change as follows

Host      all   all     0/0    md5

Go to postgresql folder and search for posgtresql.conf under data directory.

Under line connection strings make sure the following is true

Listen_address =`*’

Here you can also change the port to which you can connect postgresql DB.