Re : Fast switchover - Mailing list pgsql-general

>> 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