While converting the Master to Standby , FATAL: timeline 2 of the primary does not match recovery target timeline 1

From: Nithya Rajendran <r-nithya(at)hcl(dot)com>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: While converting the Master to Standby , FATAL: timeline 2 of the primary does not match recovery target timeline 1
Date: 2011-06-18 09:22:18
Message-ID: AB2E75A8268D5F43858D5DD843EAA56E05444BC16E@CHN-HCLT-EVS09.HCLT.CORP.HCL.IN
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Noah Misch 2011-06-18 10:25:54 Re: "interval hour to minute" or "interval day to minute"
Previous Message Sanjay Rao 2011-06-18 08:57:30 Standby server does not start with base backup