Re: Problem with PITR recovery

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Rob Butler <crodster2k(at)yahoo(dot)com>, Oleg Bartunov <oleg(at)sai(dot)msu(dot)su>, Jeff Davis <jdavis-pgsql(at)empires(dot)org>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Problem with PITR recovery
Date: 2005-04-18 16:52:10
Message-ID: 200504181652.j3IGqAl24676@candle.pha.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Tom Lane wrote:
> Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> writes:
> > OK, I updated the two current TODO items:
> > * Automatically force archiving of partially-filled WAL files when
> > pg_stop_backup() is called or the server is stopped
>
> > Is this OK?
>
> Archive on stop is right out. The common reason for a stop is that the
> system is being shut down, and we don't have time to archive a WAL file
> before init will kill -9 us.

Ah, good point. Can we do it for 'smart' shutdown mode, which is the
default? I see server stop scripts using 'fast' where we would not do
the WAL archive.

--
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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 2005-04-18 16:59:54 Re: Problem with PITR recovery
Previous Message Tom Lane 2005-04-18 16:06:25 Re: Problem with PITR recovery