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
/var/customers/webs/cw01/wiki/data/pages/project-open/postgresql.txt · Last modified: 2010/09/17 22:42 by wadmin
 
Except where otherwise noted, content on this wiki is licensed under the following license: CC Attribution-Noncommercial-Share Alike 3.0 Unported
Recent changes RSS feed Donate Powered by PHP Valid XHTML 1.0 Valid CSS Driven by DokuWiki