User Tools
docu:csheet:sysadm:db:psql:dumping
This is an old revision of the document!
Dumping and restoring Postgres databases
This is a little cheatsheet on Postgres SQL dumping and restoring commands
Dumping commands
# dump without username pg_dump DATABASE # dump using a username and database pg_dump -Uusername -d DATABASE
Restoring comands
psql --set ON_ERROR_STOP=on DATABASE < INFILE.sql
docu/csheet/sysadm/db/psql/dumping.1582301539.txt.gz · Last modified: 2020/02/21 16:12 by admin
Except where otherwise noted, content on this wiki is licensed under the following license: GNU Free Documentation License 1.3
