Dump DB and Restore DB
Dump DB and Restore DB
(OP)
Sorry for such a newbie question.
I would like to write a cron job where it will stop the DB (eg:Test) then dump the DB to a file in a specified location. But I do not know how to. Some checking criterias are that the DB has to be stopped before dumping and that the DB be started up again after the dump.
Also, what is the command line to import the dump to the DB again?
Thanks for your help!
I would like to write a cron job where it will stop the DB (eg:Test) then dump the DB to a file in a specified location. But I do not know how to. Some checking criterias are that the DB has to be stopped before dumping and that the DB be started up again after the dump.
Also, what is the command line to import the dump to the DB again?
Thanks for your help!
RE: Dump DB and Restore DB
The following links may help.
http://www3.us.postgresql.org/users-lounge/docs/7.2/postgres/backup.html
http://www3.us.postgresql.org/users-lounge/docs/7.2/postgres/install-upgrading.html
Leland F. Jackson, CPA
Software - Master (TM)
https://www.smvfp.com
Nothing Runs Like the Fox