Re: Switchover - Mailing list pgsql-admin

From kaido vaikla
Subject Re: Switchover
Date
Msg-id CA+427g8Wg64_tBx04i5uOwJo7nN88sW4AqmmCF1Wp19gxytS7g@mail.gmail.com
Whole thread Raw
In response to Re: Switchover  (Rajesh Kumar <rajeshkumar.dba09@gmail.com>)
List pgsql-admin

On Thu, 28 Dec 2023 at 07:39, Rajesh Kumar <rajeshkumar.dba09@gmail.com> wrote:
Do I have to take a downtime of few mns and stop the applications and do a switchover?

What happens internally when we use the command patronictl switchover? Just that the role is changed? Will it affect incoming connections?

On Sat, 23 Dec 2023, 23:38 Rajesh Kumar, <rajeshkumar.dba09@gmail.com> wrote:
Hi all,


Any idea what prerequisite I should follow before I use the command patronictl switchover?

pgsql-admin by date:

Previous
From: hubert depesz lubaczewski
Date:
Subject: Re: Need help with slow query - postgres 12 on linux RHEL 8
Next
From: Scott Ribe
Date:
Subject: Re: Switchover