project-open:postgresql
Table of Contents
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
project-open/postgresql.txt · Last modified: by 127.0.0.1