| From: | legrand legrand <legrand_legrand(at)hotmail(dot)com> |
|---|---|
| To: | Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>, "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org> |
| Subject: | Re : Fast switchover |
| Date: | 2025-09-09 05:07:26 |
| Message-ID: | AS1P190MB1701268947A47298EDC6CB07900FA@AS1P190MB1701.EURP190.PROD.OUTLOOK.COM |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Laurenz Albe | 2025-09-09 05:22:02 | Re: Re : Fast switchover |
| Previous Message | Klaus Darilion | 2025-09-08 20:31:45 | RE: Fast switchover |