While converting the Master to Standby , FATAL: timeline 2 of the primary does not match recovery target timeline 1 - Mailing list pgsql-general

From Nithya Rajendran
Subject While converting the Master to Standby , FATAL: timeline 2 of the primary does not match recovery target timeline 1
Date
Msg-id AB2E75A8268D5F43858D5DD843EAA56E05444BC16E@CHN-HCLT-EVS09.HCLT.CORP.HCL.IN
Whole thread Raw
Responses Re: While converting the Master to Standby , FATAL: timeline 2 of the primary does not match recovery target timeline 1
List pgsql-general

Hi,

We are doing Master/Standby setup, We unplugged the master server, then the standby server became the master (by creating trigger file).

 

While converting the old master to new slave server, We are getting the following error in old master,

 

FATAL:  the database system is starting up

FATAL:  the database system is starting up

FATAL:  timeline 2 of the primary does not match recovery target timeline 1

FATAL:  the database system is starting up

FATAL:  the database system is starting up

 

In new Master Machine the log is as follows,

 

LOG:  selected new timeline ID: 2

LOG:  archive recovery complete

LOG:  database system is ready to accept connections

LOG:  autovacuum launcher started

LOG:  unexpected EOF on client connection

 

Could anyone please help on this issue.

 

Thanks and Regards

Nithya R



::DISCLAIMER::
-----------------------------------------------------------------------------------------------------------------------

The contents of this e-mail and any attachment(s) are confidential and intended for the named recipient(s) only.
It shall not attach any liability on the originator or HCL or its affiliates. Any views or opinions presented in
this email are solely those of the author and may not necessarily reflect the opinions of HCL or its affiliates.
Any form of reproduction, dissemination, copying, disclosure, modification, distribution and / or publication of
this message without the prior written consent of the author of this e-mail is strictly prohibited. If you have
received this email in error please delete it and notify the sender immediately. Before opening any mail and
attachments please check them for viruses and defect.

-----------------------------------------------------------------------------------------------------------------------

pgsql-general by date:

Previous
From: Sanjay Rao
Date:
Subject: Standby server does not start with base backup
Next
From: Noah Misch
Date:
Subject: Re: "interval hour to minute" or "interval day to minute"