Re: Problem with PITR recovery

Tom Lane wrote:
> Bruce Momjian  writes:
> > Tom Lane wrote:
> >> However, this still begs the question of why we are bothering.
> >> I disagree with the goal in this particular case anyhow: I do not
> >> think it's necessary, safe, nor sane for a shutdown to try to archive
> >> the last XLOG segment.  Even if we fixed the xlog mechanism to end the
> >> file there, I really have a problem with the idea that the archiver
> >> should try to start a fresh archiving cycle at shutdown.
> 
> > Doing the archive at server shutdown eliminates one of the "must
> > document" items, so the system behaves more predictably that it does
> > not.  It is not required --- it is a usability issue.
> 
> No, it just replaces a documentation issue with a reliability issue.
> We'd have to consider what to say about the prospect that the archiver
> is unable to archive that last segment, is kill -9'd by init at some
> critical point in the process, etc etc.  I think it's just a bad idea
> to promise people that shutting down the postmaster will have any such
> effect.

OK, makes sense.  Could we give them a command to archive it before they
shut down?  That would make sense.

--  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, Pennsylvania 19073