Dump DB and Restore DB

[taneujin]

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!

 

[Leland123]

Hi taneujin ,

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