Skip site navigation (1) Skip section navigation (2)

Re: pitr replica dies on startup

From: Jeff Frost <jeff(at)frostconsultingllc(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: pitr replica dies on startup
Date: 2007-09-01 01:24:08
Message-ID: Pine.LNX.4.64.0708311822070.11463@discord.home.frostconsultingllc.com (view raw or flat)
Thread:
Lists: pgsql-admin
On Fri, 31 Aug 2007, Tom Lane wrote:

> Jeff Frost <jeff(at)frostconsultingllc(dot)com> writes:
>> It seems like everything is happy, except it seems to ask for the 4F
>> log file more than once.
>
> IIRC that's standard procedure.  Is there a reason your recovery_command
> can't support it?

Really?  If that's the case, then no, this particular recovery command 
archives the WAL files off into an archive directory after they've been 
successfully copied.  So, the second time postgres asks for it, it won't be 
available.

Thanks for the idea Tom, I'll update the script to look in the archive 
directory if the file is unavailable in the backup directory.

Why does it request it twice?


-- 
Jeff Frost, Owner 	<jeff(at)frostconsultingllc(dot)com>
Frost Consulting, LLC 	http://www.frostconsultingllc.com/
Phone: 650-780-7908	FAX: 650-649-1954

In response to

Responses

pgsql-admin by date

Next:From: Tom LaneDate: 2007-09-01 01:45:10
Subject: Re: pitr replica dies on startup
Previous:From: Tom LaneDate: 2007-08-31 23:19:33
Subject: Re: pitr replica dies on startup

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group