On Thu, 2008-01-31 at 07:21 -0500, Chander Ganesan wrote: > If you don't mind if you lose some transactions
That sentence has no place in any discussion about "backup" because the risk is not just a few transactions, it is a corrupt and inconsistent database from which both old and new data would be inaccessible. As far as I am concerned, if any Postgres user loses data then we're all responsible. -- Simon Riggs 2ndQuadrant http://www.2ndQuadrant.com ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend