help with startup slave after pg_rewind - Mailing list pgsql-general

From Dylan Luong
Subject help with startup slave after pg_rewind
Date
Msg-id c32d2d3580834ff188b2956488b9d87b@ITUPW-EXMBOX2B.UniNet.unisa.edu.au
Whole thread Raw
Responses Re: help with startup slave after pg_rewind  (Michael Paquier <michael@paquier.xyz>)
List pgsql-general

 

Hi

After promoting slave to master, I completed a pg_rewind of the slave (old master) to the new master. But when I try to start the slave I am getting the following error.

 

2018-09-20 07:53:51 ACST [20265]: [2-1] db=[unknown],user=replicant app=[unknown],host=10.69.20.22(51271) FATAL:  the database system is starting up

2018-09-20 07:53:51 ACST [20264]: [3-1] db=,user= app=,host= LOG:  restored log file "0000000C.history" from archive

2018-09-20 07:53:51 ACST [20264]: [4-1] db=,user= app=,host= LOG:  restored log file "0000000C0000085B00000000" from archive

2018-09-20 07:53:51 ACST [20264]: [5-1] db=,user= app=,host= LOG:  contrecord is requested by 85B/28

2018-09-20 07:53:51 ACST [20268]: [1-1] db=,user= app=,host= LOG:  started streaming WAL from primary at 85B/0 on timeline 12

2018-09-20 07:53:51 ACST [20264]: [6-1] db=,user= app=,host= LOG:  contrecord is requested by 85B/28

2018-09-20 07:53:51 ACST [20268]: [2-1] db=,user= app=,host= FATAL:  terminating walreceiver process due to administrator command

2018-09-20 07:53:51 ACST [20264]: [7-1] db=,user= app=,host= LOG:  restored log file "0000000C0000085B00000000" from archive

2018-09-20 07:53:51 ACST [20264]: [8-1] db=,user= app=,host= LOG:  contrecord is requested by 85B/28

2018-09-20 07:53:51 ACST [20264]: [9-1] db=,user= app=,host= LOG:  contrecord is requested by 85B/28

2018-09-20 07:53:51 ACST [20264]: [10-1] db=,user= app=,host= LOG:  restored log file "0000000C0000085B00000000" from archive

2018-09-20 07:53:51 ACST [20264]: [11-1] db=,user= app=,host= LOG:  contrecord is requested by 85B/28

2018-09-20 07:53:51 ACST [20264]: [12-1] db=,user= app=,host= LOG:  contrecord is requested by 85B/28

 

 

I tried to run pg_rewind again, but now it says I cannot do it as its already same timeline.

 

Regards

Dylan

 

pgsql-general by date:

Previous
From: Tim Cross
Date:
Subject: Re: Converting to number with given format
Next
From: Ken Tanzer
Date:
Subject: Re: Converting to number with given format