Setup Notes for v8 on CentOS 5
Install it via yum.
As root, initialize the database:
# service postgresql initdb
You are most likely going to want to run scripts which connect to the database using usernames other than the owner of the running process. By default, postgres insists on the
ident method of verification, which means that the process running the script has to be owned by the same credentials as the connection to the database. If you don't fix this, you are likely to get errors along the lines of
psql: FATAL: Ident authentication failed for user "username". To fix this, as user postgres, edit data/pg_hba.conf and change the line for 127.0.0.1/32 to this:
host all all 127.0.0.1/32 trust
As root, start the server:
# service postgresql start
You probably want the server to start at boot time too:
# chkconfig postgresql on