== Installing and setting up a new db ==

You will need sudo on that machine.

- install postgres: [[BR]]
sudo yum install postgresql[[BR]]
sudo yum install postgresql-server

postgres tends to install its files under the username postgres. You should therefore create and use this user for the steps below. Specifically you need access to /var/run/postgresql/

- make a directory for posgres data: [[BR]]
mkdir -p /usr/local/pgsql/data

- Create a database cluster (file structure) [[BR]]
initdb -D /usr/local/pgsql/data

- Initialise the server (I think I only need to do the second of these things) [[BR]]
postmaster -D /usr/local/pgsql/data >logfile 2>&1 &[[BR]]
postgres -D /usr/local/pgsql/data &

- create database: [[BR]]
createdb <db_name>

- To restart the server (after shutting down for example)[[BR]]
su - postgres[[BR]]
pg_ctl start -D /usr/local/pgsql/data       


== Configuring ==

The config files will be inside the database cluster directory you created above (so /usr/local/pgsql/data/ in the example).

There are two main config files, both in the above dir.

pg_hba.conf (the client authentication configuration file)[[BR]]
postgresql.conf (all sorts of things)

You need to explicity allow for external hosts to connect to the database:

pg_hba.conf:[[BR]]
# IPv4 local connections:[[BR]]
host    all             all             192.171.161.1/24         trust

postgresql.conf[[BR]]
listen_addresses = '*'

pg_ctl is a utility for monitoring and controlling a posgreSQL server[[BR]]
Check server status:[[BR]]
pg_ctl status -D /usr/local/pgsql/data[[BR]]       
pg_ctl: server is running (PID: 29763)