Hey, would you consider episode about showing how to prepare postgres 13/14 failover and failback setup in something like keepalived cluster? I tried to do something like this and it kinda works, but I know my knowledge of topic is minimal. Got two machines one master and one backup with replication. On failover event I stop master and add standby.signal to prevent writes, then on backup I remove this file and start database. System works as it should, but probably it can be done 100x better. It would be great to compare my setup to advanced one. Great channel, cheers!
Thank You! Happy Byteiversary!
Hey, would you consider episode about showing how to prepare postgres 13/14 failover and failback setup in something like keepalived cluster?
I tried to do something like this and it kinda works, but I know my knowledge of topic is minimal. Got two machines one master and one backup with replication. On failover event I stop master and add standby.signal to prevent writes, then on backup I remove this file and start database. System works as it should, but probably it can be done 100x better.
It would be great to compare my setup to advanced one.
Great channel, cheers!