On Mon, 2025-09-08 at 15:03 +, legrand legrand wrote:
> For some projects we need a fast manual switchover to address Near Zero
> downtime maintenance
> (not speaking here about automated failover like those provided by HA tools,
> but just planned, controlled operations)
>
> Database Physic
On Tue, 2025-09-09 at 05:07 +, legrand legrand wrote:
> > > 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.
If you want more reliable numbers, make a test run on your system.
On Mon, Sep 8, 2025 at 11:03 AM legrand legrand
wrote:
> Hello all the readers,
>
> For some projects we need a fast *manual* switchover to address Near Zero
> downtime maintenance
> (not speaking here about automated failover like those provided by HA
> tools, but just planned, controlled operat
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
>switcho
> > what could we expect (in term of downtime in both worlds) ?
>
> Usually seconds, so plan for ten minutes.
*lol*
So true ...
On Mon, Sep 8, 2025 at 12:37 PM Klaus Darilion
wrote:
>
>
> *From:* Ron Johnson
> *Sent:* Monday, September 8, 2025 6:10 PM
> *To:* pgsql-general@lists.postgresql.org
> *Subject:* Re: Fast switchover
>
>
>
> On Mon, Sep 8, 2025 at 11:03 AM legrand legrand <
>
From: Ron Johnson
Sent: Monday, September 8, 2025 6:10 PM
To: pgsql-general@lists.postgresql.org
Subject: Re: Fast switchover
On Mon, Sep 8, 2025 at 11:03 AM legrand legrand
mailto:legrand_legr...@hotmail.com>> wrote:
Hello all the readers,
For some projects we need a fast manual swit
Hello all the readers,
For some projects we need a fast manual switchover to address Near Zero
downtime maintenance
(not speaking here about automated failover like those provided by HA tools,
but just planned, controlled operations)
Database Physical replication switchover itself:
- initial r
