Re: Problem with PITR recovery

Michael Paesold wrote:
> 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.

Yea, probably a separate switch, or an additional switch to pg_clt would
be best, but then we have to add to pg_ctl.

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

Right.  I just hate the 'do this, do that' instructions to PITR.  When
they get too long/complex, I get worried.

I used to use Informix's ontape, which was a bad user interface because
the admin had to be sure it was always running.  Anyway, when you
control-C'ed the process, it would flush out any partially written wal
file and you knew you had everything.

I am thinking a special pg_ctl flag, and disabling -W for that so you
have to wait for the success message.  Of course we then have to
document the use of the pg_ctl flag then.

--  Bruce Momjian                        |  http://candle.pha.pa.us pgman@candle.pha.pa.us               |  (610)
359-1001+  If your life is a hard drive,     |  13 Roberts Road +  Christ can be your backup.        |  Newtown Square,
Pennsylvania19073