pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedautomatic switchover / switchback
6+ messages / 6 participants
[nested] [flat]
* automatic switchover / switchback
@ 2020-06-23 03:12 vinod kale <vinod16895@gmail.com>
0 siblings, 2 replies; 6+ messages in thread
From: vinod kale @ 2020-06-23 03:12 UTC (permalink / raw)
To: pgsql-admin
Hello Team,
Is there automatic switchover / switchback available in postgres. Means we
wll not going to create recovery.conf and etc...
Is there a way that postgres internally manage that and perform switchover
OR switchback.
If yes then can u jst share me the steps or any link.
Thanks in advance.
Thanks & Regards,
Vinod Kale
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: automatic switchover / switchback
@ 2020-06-23 07:20 dbatoCloud Solution <dbatocloud17@gmail.com>
parent: vinod kale <vinod16895@gmail.com>
1 sibling, 1 reply; 6+ messages in thread
From: dbatoCloud Solution @ 2020-06-23 07:20 UTC (permalink / raw)
To: vinod kale <vinod16895@gmail.com>; +Cc: pgsql-admin
Hi Vinod,
We don;t have concept called switchover and switchback in Postgres
automatically, There is only one way that we can failover then recreate the
master db. or you can configure automatic switch using tool
Thanks & Best Wishes,
Ashok
-------------
On Tue, Jun 23, 2020 at 11:11 AM vinod kale <vinod16895@gmail.com> wrote:
> Hello Team,
>
> Is there automatic switchover / switchback available in postgres. Means
> we wll not going to create recovery.conf and etc...
> Is there a way that postgres internally manage that and perform switchover
> OR switchback.
> If yes then can u jst share me the steps or any link.
>
> Thanks in advance.
>
> Thanks & Regards,
> Vinod Kale
>
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: automatic switchover / switchback
@ 2020-06-23 07:21 Sylvie HALAT <sylvie.halat@ac-toulouse.fr>
parent: dbatoCloud Solution <dbatocloud17@gmail.com>
0 siblings, 1 reply; 6+ messages in thread
From: Sylvie HALAT @ 2020-06-23 07:21 UTC (permalink / raw)
To: dbatoCloud Solution <dbatocloud17@gmail.com>; vinod kale <vinod16895@gmail.com>; +Cc: pgsql-admin
Hi Vinod
This tool can help you :
https://repmgr.org/docs/5.1/
Best Regards
Sylvie Halat
Le 23/06/2020 à 09:20, dbatoCloud Solution a écrit :
> Hi Vinod,
> We don;t have concept called switchover and switchback in Postgres
> automatically, There is only one way that we can failover then
> recreate the master db. or you can configure automatic switch using tool
>
> Thanks & Best Wishes,
>
> Ashok
>
> -------------
>
>
> On Tue, Jun 23, 2020 at 11:11 AM vinod kale <vinod16895@gmail.com
> <mailto:vinod16895@gmail.com>> wrote:
>
> Hello Team,
>
> Is there automatic switchover / switchback available in postgres.
> Means we wll not going to create recovery.conf and etc...
> Is there a way that postgres internally manage that and perform
> switchover OR switchback.
> If yes then can u jst share me the steps or any link.
>
> Thanks in advance.
>
> Thanks & Regards,
> Vinod Kale
>
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: automatic switchover / switchback
@ 2020-06-23 08:16 Amine Tengilimoglu <aminetengilimoglu@gmail.com>
parent: Sylvie HALAT <sylvie.halat@ac-toulouse.fr>
0 siblings, 0 replies; 6+ messages in thread
From: Amine Tengilimoglu @ 2020-06-23 08:16 UTC (permalink / raw)
To: Sylvie HALAT <sylvie.halat@ac-toulouse.fr>; +Cc: dbatoCloud Solution <dbatocloud17@gmail.com>; vinod kale <vinod16895@gmail.com>; pgsql-admin
Hi;
There is no built-in solution that makes this work automatic in PostgreSQL.
As you mentioned, there are external tools that don't require any manual
intervention.
BFM is one of them. It is a PostgreSQL failover tool that is very easy to
install and configure. In addition to failover, it can also perform
switchover operations. It also performs this process independently without
affecting clients.
You can take a look at : https://infogram.com/bfm-1hd12yzdkm8w4km?live
and for more information info@bisoft.com.tr
Best Regards
Sylvie HALAT <sylvie.halat@ac-toulouse.fr>, 23 Haz 2020 Sal, 10:22
tarihinde şunu yazdı:
> Hi Vinod
>
> This tool can help you :
>
> https://repmgr.org/docs/5.1/
>
> Best Regards
>
> Sylvie Halat
>
> Le 23/06/2020 à 09:20, dbatoCloud Solution a écrit :
>
> Hi Vinod,
> We don;t have concept called switchover and switchback in Postgres
> automatically, There is only one way that we can failover then recreate the
> master db. or you can configure automatic switch using tool
>
>
>
>
>
> Thanks & Best Wishes,
>
> Ashok
>
>
>
> -------------
>
> On Tue, Jun 23, 2020 at 11:11 AM vinod kale <vinod16895@gmail.com> wrote:
>
>> Hello Team,
>>
>> Is there automatic switchover / switchback available in postgres. Means
>> we wll not going to create recovery.conf and etc...
>> Is there a way that postgres internally manage that and perform
>> switchover OR switchback.
>> If yes then can u jst share me the steps or any link.
>>
>> Thanks in advance.
>>
>> Thanks & Regards,
>> Vinod Kale
>>
>
>
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: automatic switchover / switchback
@ 2020-06-23 10:43 Stephen Frost <sfrost@snowman.net>
parent: vinod kale <vinod16895@gmail.com>
1 sibling, 1 reply; 6+ messages in thread
From: Stephen Frost @ 2020-06-23 10:43 UTC (permalink / raw)
To: vinod kale <vinod16895@gmail.com>; +Cc: pgsql-admin
Greetings,
* vinod kale (vinod16895@gmail.com) wrote:
> Is there automatic switchover / switchback available in postgres. Means we
> wll not going to create recovery.conf and etc...
> Is there a way that postgres internally manage that and perform switchover
> OR switchback.
> If yes then can u jst share me the steps or any link.
I'd suggest you check out Patroni.
Thanks,
Stephen
Attachments:
signature.asc (application/pgp-signature, 818B) download
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: automatic switchover / switchback
@ 2020-06-23 17:05 John Wiencek <jwiencek3@comcast.net>
parent: Stephen Frost <sfrost@snowman.net>
0 siblings, 0 replies; 6+ messages in thread
From: John Wiencek @ 2020-06-23 17:05 UTC (permalink / raw)
To: Stephen Frost <sfrost@snowman.net>; +Cc: vinod kale <vinod16895@gmail.com>; pgsql-admin
EnterpriseDB has a product called Enterprise Failover Manager(EFM) that has the features you mention. Checkout their website.
John
> On Jun 23, 2020, at 5:43 AM, Stephen Frost <sfrost@snowman.net> wrote:
>
> Greetings,
>
> * vinod kale (vinod16895@gmail.com) wrote:
>> Is there automatic switchover / switchback available in postgres. Means we
>> wll not going to create recovery.conf and etc...
>> Is there a way that postgres internally manage that and perform switchover
>> OR switchback.
>> If yes then can u jst share me the steps or any link.
>
> I'd suggest you check out Patroni.
>
> Thanks,
>
> Stephen
^ permalink raw reply [nested|flat] 6+ messages in thread
end of thread, other threads:[~2020-06-23 17:05 UTC | newest]
Thread overview: 6+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2020-06-23 03:12 automatic switchover / switchback vinod kale <vinod16895@gmail.com>
2020-06-23 07:20 ` dbatoCloud Solution <dbatocloud17@gmail.com>
2020-06-23 07:21 ` Sylvie HALAT <sylvie.halat@ac-toulouse.fr>
2020-06-23 08:16 ` Amine Tengilimoglu <aminetengilimoglu@gmail.com>
2020-06-23 10:43 ` Stephen Frost <sfrost@snowman.net>
2020-06-23 17:05 ` John Wiencek <jwiencek3@comcast.net>
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