Comments on: PostgreSQL HA with Patroni: Your Turn to Test Failure Scenarios https://www.percona.com/blog/postgresql-ha-with-patroni-your-turn-to-test-failure-scenarios/ Tue, 28 Nov 2023 06:14:44 +0000 hourly 1 https://wordpress.org/?v=6.5.2 By: Stan https://www.percona.com/blog/postgresql-ha-with-patroni-your-turn-to-test-failure-scenarios/#comment-10974215 Tue, 28 Nov 2023 06:14:44 +0000 https://www.percona.com/blog/?p=76405#comment-10974215 Hello,
I had to install the watchdog package.
Can I use the same procedure for the Watchdog configuration with Ubuntu 22.04 ?
Thanks…

]]> By: Jobin Augustine https://www.percona.com/blog/postgresql-ha-with-patroni-your-turn-to-test-failure-scenarios/#comment-10973823 Thu, 17 Nov 2022 06:46:58 +0000 https://www.percona.com/blog/?p=76405#comment-10973823 Great to hear that you found the blog post useful. Yes, Patroni emerged as the best HA framework for PostgreSQL.

]]> By: Jobin Augustine https://www.percona.com/blog/postgresql-ha-with-patroni-your-turn-to-test-failure-scenarios/#comment-10973822 Thu, 17 Nov 2022 06:45:02 +0000 https://www.percona.com/blog/?p=76405#comment-10973822 The chance of watchdog has to intervene is very slim. because the moment Primary understands that its leader key is expired and it is not able renew, it degrades itself to standby. So I too never saw that happening in real world cases.
Probably, only possibility is to overload the server and make it unresponsive enough so that watchdog will have some job to do. But if the system is hanging, I don’t know whether we should expect a good kernel message.

]]> By: pradeep batham https://www.percona.com/blog/postgresql-ha-with-patroni-your-turn-to-test-failure-scenarios/#comment-10973815 Tue, 15 Nov 2022 08:26:28 +0000 https://www.percona.com/blog/?p=76405#comment-10973815 Thanks for this wonderful blog, I am new to Postgres and i have not face any issue to configure PG HA and testing the failover.

]]> By: markosutic https://www.percona.com/blog/postgresql-ha-with-patroni-your-turn-to-test-failure-scenarios/#comment-10973695 Mon, 01 Aug 2022 19:17:49 +0000 https://www.percona.com/blog/?p=76405#comment-10973695 Hello,

Thank you very much for the article.
I was curios, when watchdog (softdog) triggers restart do you receive info in the OS log that restart is triggered by the watchdog?
Something like “softdog: Initiating system reboot”…

I have executed few tests and there was not any info to distinguish when watchdog triggered restart.

Best regards,
Marko

]]>