Re: Problem with PITR recovery - Mailing list pgsql-hackers

From Bruce Momjian
Subject Re: Problem with PITR recovery
Date
Msg-id 200504202219.j3KMJoF23133@candle.pha.pa.us
Whole thread Raw
In response to Re: Problem with PITR recovery  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Problem with PITR recovery
List pgsql-hackers
Tom Lane wrote:
> Bruce Momjian <pgman@candle.pha.pa.us> 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,
Pennsylvania19073
 


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Postgres: pg_hba.conf, md5, pg_shadow, encrypted passwords
Next
From: "David F. Skoll"
Date:
Subject: Re: Postgres: pg_hba.conf, md5, pg_shadow, encrypted passwords