[prev] 49 [next]

Installing PostgreSQL

PostgreSQL is available via the COMP9315 web site.

Provided as tarball and zip in ~cs9315/web/16s1/postgresql/

Brief summary of installation:

$ tar xfj ..../postgresql/src.tar.bz2
# creates a directory postgresql-9.4.6
$ configure --prefix=~/your/pgsql/directory
$ make
$ make install
$ source ~/your/environment/file
   # set up environment variables
$ initdb
   # set up postgresql configuration ... done once?
$ pg_ctl start
   # do some work with PostgreSQL databases
$ pg_ctl stop