Re: [GENERAL] Restore filesystem backup

2008-09-14 Thread Joshua D. Drake
Patrik Strömstedt wrote: Dear all, Problem solved. 6) Cross your fingers... (In my case, the old data was available) 7) Immediately take a new pg_dump backup 8) Initiate a new data directory 9) Restore from brand new pg_dump backup 10) Immediately make sure you are getting real, consistent,

Re: [GENERAL] Restore filesystem backup

2008-09-14 Thread Patrik Strömstedt
tart the PostgreSQL service 6) Cross your fingers... (In my case, the old data was available) Patrik Strömstedt - Original Message - From: "Robert Treat" <[EMAIL PROTECTED]> To: Cc: "Patrik Strömstedt" <[EMAIL PROTECTED]> Sent: Saturday, September 13, 2008

Re: [GENERAL] Restore filesystem backup

2008-09-13 Thread Robert Treat
On Saturday 13 September 2008 09:07:23 Patrik Strömstedt wrote: > Hi, > > I have a big problem. > > The backup (done nightly with pg_dump) at one of our customers sites is > broken (well, it's overwritten and is of no use anymore). What is left is a > filesystem backup that incudes the postgresql d