For When You Can't Have The Real Thing
[ start | index | login ]
start > postgresql > v8 > RPM Setup

RPM Setup

Created by dave. Last edited by dave, 7 years and 271 days ago. Viewed 1,884 times. #2
[diff] [history] [edit] [rdf]
labels
attachments

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
no comments | post comment
This is a collection of techical information, much of it learned the hard way. Consider it a lab book or a /info directory. I doubt much of it will be of use to anyone else.

Useful:


snipsnap.org | Copyright 2000-2002 Matthias L. Jugel and Stephan J. Schmidt