how to backup a single project database and restore it? - Printable Version +- TACTIC Open Source (http://forum.southpawtech.com) +-- Forum: TACTIC Open Source (http://forum.southpawtech.com/forumdisplay.php?fid=3) +--- Forum: TACTIC Discussion (http://forum.southpawtech.com/forumdisplay.php?fid=4) +--- Thread: how to backup a single project database and restore it? (/showthread.php?tid=24) Pages:
1
2
|
RE: how to backup a single project database and restore it? - remkonoteboom - 11-18-2019 The postgres commands to dump a database are: pg_dump -U <user> <database> > database.sql To restore this, you can use: psql -U <user> <database> < database.sql To dump and restore all of your databases you would use pg_dumpall |