By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
464,512 Members | 707 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 464,512 IT Pros & Developers. It's quick & easy.

Recovery systems available

P: n/a
What database recovery systems are
available in Postgres

Please point me to the respective
section in the documentation

Thanks
Sanjay Minni
www.minisoftindia.com
Jul 19 '05 #1
Share this Question
Share on Google+
1 Reply

P: n/a
Sanjay Minni wrote:
What database recovery systems are
available in Postgres I'm not sure, but there are some features you should look at, including
WAL (Write Ahead Logging) which writes data before it acknowledgs
completing the transaction.

We write our data to file twice per day using pg_dump, and compress the
data. In the event of a restore, we would use the psql command to do a
complete restore from this file in a matter of minutes.

Please point me to the respective
section in the documentation

Thanks
Sanjay Minni
www.minisoftindia.com


hth

Ron

Jul 19 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.