== 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 - 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)