Week 01 Lectures (19)

Installing/Using PostgreSQL

Environment setup for running PostgreSQL in COMP9315:

# Must be "source"d from sh, bash, ksh, ...

# can be any directory
PGHOME=/home/jas/srvr/pgsql
# data does not need to be under $PGHOME
export PGDATA=$PGHOME/data
export PGHOST=$PGDATA
export PGPORT=5432
export PATH=$PGHOME/bin:/home/cs9315/bin:$PATH

# /home/cs9315/bin/pgs simplifies managing server

Will probably work (with tweaks) on home laptop if Linux or MacOS