Re: Problem with PITR recovery

Tom Lane wrote:

> Bruce Momjian wrote:
>> OK, makes sense.  Could we give them a command to archive it before they
>> shut down?  That would make sense.
>
> Not if the idea is to be certain you got everything ... I think what we
> have to do is document a manual procedure for archiving the last XLOG
> file.

What Bruce would want is a way to "stop new transactions, archive and 
shutdown", which would do this atomically. Then we could have another 
shutdown switch for pg_ctl.

But yea, a documentation for a manual procedure would be ok, too, just not 
as user friendly.

Best Regards,
Michael Paesold