pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feed[HELP] Query regarding failover
4+ messages / 3 participants
[nested] [flat]
* [HELP] Query regarding failover
@ 2020-06-30 15:24 Praveen Kumar K S <praveenssit@gmail.com>
0 siblings, 1 reply; 4+ messages in thread
From: Praveen Kumar K S @ 2020-06-30 15:24 UTC (permalink / raw)
To: pgsql-admin
Hello Experts,
I'm using pgpool and configured postgres cluster with 1 master and 1slaves
with synchronous replication. Master is archiving WAL logs to a NAS share.
I'm using 9.6
I have read a few documentations and the failover and recovery are handled
in different ways. Few wrote shell scripts and passed it to pgpool and few
used tools like repmgr to handle automatic failover and recovery without
any manual intervention.
My requirement is to set up a process to handle failover and recovery
without manual intervention. I would like to know your suggestions if there
is any standard way of doing this or is it better to write custom scripts.
TIA.
--
*Regards,*
*K S Praveen Kumar*
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: [HELP] Query regarding failover
@ 2020-07-01 07:38 Laurenz Albe <laurenz.albe@cybertec.at>
parent: Praveen Kumar K S <praveenssit@gmail.com>
0 siblings, 1 reply; 4+ messages in thread
From: Laurenz Albe @ 2020-07-01 07:38 UTC (permalink / raw)
To: Praveen Kumar K S <praveenssit@gmail.com>; pgsql-admin
On Tue, 2020-06-30 at 20:54 +0530, Praveen Kumar K S wrote:
> My requirement is to set up a process to handle failover and recovery without manual intervention.
> I would like to know your suggestions if there is any standard way of doing this or is it better to write custom scripts.
I don't think you can do that reliably with "custom scripts".
There is no standard way, but have a look at Patroni.
Yours,
Laurenz Albe
--
Cybertec | https://www.cybertec-postgresql.com
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: [HELP] Query regarding failover
@ 2020-07-02 11:25 Praveen Kumar K S <praveenssit@gmail.com>
parent: Laurenz Albe <laurenz.albe@cybertec.at>
0 siblings, 1 reply; 4+ messages in thread
From: Praveen Kumar K S @ 2020-07-02 11:25 UTC (permalink / raw)
To: Laurenz Albe <laurenz.albe@cybertec.at>; +Cc: pgsql-admin
Hello,
Thanks for your response. I will look into it. According to you, which is
better ? repmgr/patroni for automated switch over and switch back ?
On Wed, Jul 1, 2020 at 1:08 PM Laurenz Albe <laurenz.albe@cybertec.at>
wrote:
> On Tue, 2020-06-30 at 20:54 +0530, Praveen Kumar K S wrote:
> > My requirement is to set up a process to handle failover and recovery
> without manual intervention.
> > I would like to know your suggestions if there is any standard way of
> doing this or is it better to write custom scripts.
>
> I don't think you can do that reliably with "custom scripts".
> There is no standard way, but have a look at Patroni.
>
> Yours,
> Laurenz Albe
> --
> Cybertec | https://www.cybertec-postgresql.com
>
>
--
*Regards,*
*K S Praveen KumarM: +91-9986855625 *
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: [HELP] Query regarding failover
@ 2020-07-02 11:33 Marlene Villanueva <villanuevamarlene906@gmail.com>
parent: Praveen Kumar K S <praveenssit@gmail.com>
0 siblings, 0 replies; 4+ messages in thread
From: Marlene Villanueva @ 2020-07-02 11:33 UTC (permalink / raw)
To: Praveen Kumar K S <praveenssit@gmail.com>; +Cc: Laurenz Albe <laurenz.albe@cybertec.at>; pgsql-admin
Cancel switch
On Thu, 2 Jul 2020, 4:26 AM Praveen Kumar K S, <praveenssit@gmail.com>
wrote:
> Hello,
>
> Thanks for your response. I will look into it. According to you, which is
> better ? repmgr/patroni for automated switch over and switch back ?
>
> On Wed, Jul 1, 2020 at 1:08 PM Laurenz Albe <laurenz.albe@cybertec.at>
> wrote:
>
>> On Tue, 2020-06-30 at 20:54 +0530, Praveen Kumar K S wrote:
>> > My requirement is to set up a process to handle failover and recovery
>> without manual intervention.
>> > I would like to know your suggestions if there is any standard way of
>> doing this or is it better to write custom scripts.
>>
>> I don't think you can do that reliably with "custom scripts".
>> There is no standard way, but have a look at Patroni.
>>
>> Yours,
>> Laurenz Albe
>> --
>> Cybertec | https://www.cybertec-postgresql.com
>>
>>
>
> --
>
>
> *Regards,*
>
>
> *K S Praveen KumarM: +91-9986855625 *
>
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2020-07-02 11:33 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2020-06-30 15:24 [HELP] Query regarding failover Praveen Kumar K S <praveenssit@gmail.com>
2020-07-01 07:38 ` Laurenz Albe <laurenz.albe@cybertec.at>
2020-07-02 11:25 ` Praveen Kumar K S <praveenssit@gmail.com>
2020-07-02 11:33 ` Marlene Villanueva <villanuevamarlene906@gmail.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox