TACTIC Open Source
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