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(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073