Search Postgresql Archives

help with startup slave after pg_rewind

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



 

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

 


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux