Re: Question regarding failover behavior

2022-08-24 Thread Koen De Groote
Updating to say I tested and ran into the issue where the timeline switched from 0C to 0D. Trying to bring the old primary back up as standby fails. It recovers upto a point and then gets stuck asked for a next file that doesn't exist. Regardless of taking the existing data directory or restoring

Question regarding failover behavior

2022-08-23 Thread Koen De Groote
Hello all, I have a system that was originally set up on 9.3, a few years ago moved to 11.2 A shared mount is used to host the basebackup and wal archives. The failover procedure was basically manual and as follow: 1/ Take out the primary, remove the IP from the primary machine/VM 2/ Create the