Re : Fast switchover

legrand legrand <legrand_legrand@hotmail.com>

From: legrand legrand <legrand_legrand@hotmail.com>
To: Laurenz Albe <laurenz.albe@cybertec.at>, "pgsql-general@lists.postgresql.org" <pgsql-general@lists.postgresql.org>
Date: 2025-09-09T05:07:26Z
Lists: pgsql-general
Hi Laurenz,
Thank you for your answer

>> For some projects we need a fast manual switchover to address Near Zero downtime maintenance

I forgot to say that application would not be stopped during maintenance…

>There is no need for synchronous replication; you cannot lose data with a switchover,
>if you do it right:

Ok

>> May logical replication ( bi-directional, with one instance RW and the other RO) be a better solution ?

> I'd say no.

Really ?

>> what could we expect (in term of downtime in both worlds) ?

> Usually seconds, so plan for ten minutes.

Brrr, I was thînking about a more reliable process.

Regards
PAscal