Installation

To install PostgreSQL on Linux systems, first install the following packages (here for Ubuntu):

sudo apt-get install build-essential libreadline-dev zlib1g-dev flex bison libxml2-dev libxslt-dev libssl-dev

Then proceed, as usual with configure, make, make install. See also the PostgreSQL installation procedure guide.

To start up a database proceed as follows:

adduser postgres
mkdir /data
chown postgres /data
su - postgres
./initdb -D /data
./postgres -D /data >logfile 2>&1 &
./createdb test
./psql test