Recover db

Started by Williams, Travis L, NPONSover 23 years ago2 messagesgeneral
Jump to latest

After you do a pg_dump on the db and you have that file.. what do you do to recover the db if it is lost?

Travis

#2Adam Witney
awitney@sghms.ac.uk
In reply to: Williams, Travis L, NPONS (#1)
Re: Recover db

You can use pg_restore or psql to restore the database from a dump file. See
here for details:

http://www.postgresql.org/idocs/index.php?backup.html

adam

Show quoted text

After you do a pg_dump on the db and you have that file.. what do you do to
recover the db if it is lost?

Travis

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to majordomo@postgresql.org)