RPM Setup

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