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