Re: Point in Time Recovery - Mailing list pgsql-hackers

From Christopher Kings-Lynne
Subject Re: Point in Time Recovery
Date
Msg-id 40FC9363.3060200@familyhealth.com.au
Whole thread Raw
In response to Re: Point in Time Recovery  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
> I don't think so, but it seems like a much less robust way to do things.
> What happens if you have a failure partway through?  For instance
> archive machine dies and loses recent data right after you've rm'd the
> source file.  The recommended COPY procedure at least provides some
> breathing room between when you install the data on the archive and when
> the original file is removed.

Well, I tried it in 'cross your fingers' mode and it works, at least:

archive_command = 'rm %p'

:)

Chris



pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Point in Time Recovery
Next
From: Bruce Momjian
Date:
Subject: Re: patch for allowing multiple -t options to pg_dump