pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: andy@andycc.net
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: pgsql-admin@postgresql.org
Subject: Re: WAL recovery question - 0000001.history
Date: Sat, 29 Apr 2006 14:29:53 +0100
Message-ID: <iyhk5t.v0mji1@webmail.mailnetwork.co.uk> (raw)
In-Reply-To: <1442.1146239314@sss.pgh.pa.us>
References: <20060428152301.007F011F602A@postgresql.org>
	<1442.1146239314@sss.pgh.pa.us>

Hi Tom,Thanks for this.  Do you know why Postgres was asking for
00000001.history?  Surely it would know by the presence of the
backup_label file, and its contents that it needs to go straight for the
xxxxxx.backup file, which should exist?What other files is Postgres
likely to be asked for during a PITR restore?  Obviously log files that
don't exist do need to be waited for - hence the need for this script. 
If you want PG to come back up without the log it's waiting on, you just set
the flag file and it'll come up at the next interval.So far all I can see
that's problematic is this 0000001.history file which I don't know what it is,
and it'll never exist because it was never generated on the live.The other
thing I'm building in as well, is a file-size check, so when shipping logs
directly from another server (e.g. live to standby), when the script finds a
log, it will read the file size, wait 5 seconds, then read it again - if the 2
values differ, the log is still being transferred, so it will wait for another
interval and check again before doing anything - preventing itself from
pinching the log while it's still being transferred, and causing errors when
PG tries to read it.This will also remove as much human intervention as
possible from the whole process.AndyTom Lane <tgl@sss.pgh.pa.us>
wrote:> "Andy Shellam" <andy.shellam@mailnetwork.co.uk>
writes:> > Basically I've taken a dump of my live database directory
(between> > pg_start_backup and pg_stop_backup) calls - shipped this to
my standby, set> > up a recovery.conf file (which calls the rolling-WAL
script). This script> > is designed to wait until the log file arrives,
or a flag file is set to> > return code 1 to postgres.> > >
However as soon as the recovery starts, the script is waiting for a file>
> called 00000001.history, which will never arrive because it was never>
> generated on the live box since the base backup was taken.> > This
is not a workable approach: your recovery script *will* be asked> for files
that do not exist, and waiting for them to be supplied is not> always the
right answer. Supplying an empty file instead is definitely> the wrong
answer.> > You might be able to make it work by conditionalizing the
behavior on> the format of the name being asked for.> > regards, tom
lane> > ---------------------------(end of
broadcast)---------------------------> TIP 4: Have you searched our list
archives?> > http://archives.postgresql.org; >
!DSPAM:14,445239a233692110055341!> > > 
__________________________________________________________
The mail network cannot accept liability for the content
of this e-mail. It is recommended you scan it for viruses
immediately upon receipt.

Is this e-mail spam?  Report it to abuse@mailnetwork.co.uk

view thread (5+ messages)  latest in thread

Message-ID: <iyhk5t.v0mji1@webmail.mailnetwork.co.uk>
Permalink:  ../iyhk5t.v0mji1@webmail.mailnetwork.co.uk/
Also on:    postgresql.org/message-id/iyhk5t.v0mji1@webmail.mailnetwork.co.uk

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-admin@postgresql.org
  Cc: andy@andycc.net, tgl@sss.pgh.pa.us
  Subject: Re: WAL recovery question - 0000001.history
  In-Reply-To: <iyhk5t.v0mji1@webmail.mailnetwork.co.uk>
  References: <20060428152301.007F011F602A@postgresql.org> <1442.1146239314@sss.pgh.pa.us> <iyhk5t.v0mji1@webmail.mailnetwork.co.uk>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox