help with startup slave after pg_rewind

From: Dylan Luong <Dylan(dot)Luong(at)unisa(dot)edu(dot)au>
To: "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: help with startup slave after pg_rewind
Date: 2018-09-19 22:29:44
Message-ID: c32d2d3580834ff188b2956488b9d87b@ITUPW-EXMBOX2B.UniNet.unisa.edu.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ken Tanzer 2018-09-20 00:03:33 Re: Converting to number with given format
Previous Message Tim Cross 2018-09-19 22:23:30 Re: Converting to number with given format