User Tools

Site Tools


Sidebar

js#vista.png msort nsort

project-open:postgresql

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: 2020/02/24 11:16 (external edit)