====== Various PostGreSQL info ====== ===== show tables the PostGreSQL way ===== * psql template1 projop -l ===== complete DB dump ===== * pg_dump -c -O -F p -f backup.20100917-1745.sql ===== restore the dump ===== * psql -d projop -f backup.20100917-1745.sql ===== starting per hand ===== * su -l postgres -c "/usr/bin/postmaster -p '5432' -D '/var/lib/postgresql/8.1/main' &" >> "/var/lib/pgsql/pgstartup.log" 2>&1 < /dev/null