[pgpool-general: 2476] Re: Help error code e1012 on pgpool II 3.3.0 while clicking Recovery button

[Jeff Frost]

On Jan 23, 2014, at 9:32 AM, Syed Irfan <syedirfan_77 at yahoo.com> wrote:

> Dear Tatsuo Ishii,
> 
>        I am still awaiting for your reply on this issue, I have tried your suggestions but still I am unable to successfully run the Recovery process the third time it's surprises me how does it work the first time but same thing fails in the third attempt.?
> 
> The Postgres log shows as below
> 
> 
>> >> 28038 2014-01-09 21:28:33 BDT FATAL:  timeline 35 of the primary does not match recovery target timeline 36
>> >> 28039 2014-01-09 21:28:38 BDT FATAL:  timeline 35 of the primary does not match recovery target timeline 36
> 
> 
> I urgently request you to help me in this impending issue.
> 


This is usually caused by postgres trying to replay WAL files from the wrong source.  Did you clean out the pg_xlog directory on the replica before taking the base backup?

What does your recovery.conf look like?


-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20140123/7496fd92/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 208 bytes
Desc: Message signed with OpenPGP using GPGMail
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20140123/7496fd92/attachment.sig>