PITR

PITR

Posted Jul 7, 2004 22:46 UTC (Wed) by yem (guest, #1138)
Parent article: PostgreSQL Weekly News

I hope this will allow full+diffs style backups from live databases.

You do a daily dump of the whole database, and regular (say every 5 minutes) dump of the transaction log. If you loose the database at any time, you can recover it to the last txlog dump by loading first the full dump, then every diff up until the crash (or any time in between if you so choose).

*fingers crossed*

---

(Log in to post comments)