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

Поиск
Список
Период
Сортировка
От Nithya Rajendran
Тема While converting the Master to Standby , FATAL: timeline 2 of the primary does not match recovery target timeline 1
Дата
Msg-id AB2E75A8268D5F43858D5DD843EAA56E05444BC16E@CHN-HCLT-EVS09.HCLT.CORP.HCL.IN
обсуждение исходный текст
Ответы Re: While converting the Master to Standby , FATAL: timeline 2 of the primary does not match recovery target timeline 1  (Greg Smith <greg@2ndQuadrant.com>)
Список 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 по дате отправления:

Предыдущее
От: Sanjay Rao
Дата:
Сообщение: Standby server does not start with base backup
Следующее
От: Noah Misch
Дата:
Сообщение: Re: "interval hour to minute" or "interval day to minute"