Postgresql 9.6.12 switchover failing

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

 



Hi everyone,

I have a strange issue on my testing postgresql cluster.
I have 2 nodes with postgresql 9.6.12 on  RHEL7 .
The slave is being updated through hotstandby streaming replication.

In the past ( 9.6.8 and earlier), I was able to do a clean switchover without any issues. 
I did the following steps:
1. Check if the standby is uptodate
2. If so, shutdown the primary
3. pg_ctl promote the standby
4. Create a recovery.conf on the former primary and start the instance.

This worked just fine, with in the end the roles of the nodes changed.

Now I have version 9.6.12 and am trying to do the same.
The steps 1 to 3 works just fine.
But bringing up the old primary as a slave doesn't work. I get errors ( like >FATAL:  requested timeline 5 is not a child of this server's history) and the instances shuts down automatically.
I know I can fix it with pg_rewind ( have done it), but am confused about this.

Does anyone have the same issue? Or has anyone encountered the same problem?

Thanks in advance.
regards,
Marian




[Index of Archives]     [KVM ARM]     [KVM ia64]     [KVM ppc]     [Virtualization Tools]     [Spice Development]     [Libvirt]     [Libvirt Users]     [Linux USB Devel]     [Linux Audio Users]     [Yosemite Questions]     [Linux Kernel]     [Linux SCSI]     [XFree86]

  Powered by Linux