js#vista.png msort nsort
User Tools
Sidebar
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: 2020/02/24 11:16 (external edit)
Except where otherwise noted, content on this wiki is licensed under the following license: CC Attribution-Noncommercial-Share Alike 4.0 International
