Re: - Mailing list pgsql-admin

From Rui DeSousa
Subject Re:
Date
Msg-id EA4685AD-1D43-4CDD-B7F7-DEF15AFA13D1@crazybean.net
Whole thread Raw
In response to Re:  (Pierre Ochsenbein <pierreochsenbein@gmail.com>)
List pgsql-admin

> On Nov 5, 2018, at 11:25 AM, Pierre Ochsenbein <pierreochsenbein@gmail.com> wrote:
>
> but on your stdby you have configure a script to become the primary automatically?

Yes, as soon at the CARP address (i.e. the VIP) is migrated to the standby the database is promoted automatically.  All
theexisting TCP connections are reset/dropped and the clients reconnect to the new server within seconds.  

You have to researched the best solution for your given OS platform.  There are solutions that are platform agnostic
too. I don’t have a canned one to recommend though. 




pgsql-admin by date:

Previous
From: Rui DeSousa
Date:
Subject: Re: PostgreSQL 10.5 : Strange pg_wal fill-up, solved with theshutdown checkpoint
Next
From: Nikhil Shetty
Date:
Subject: Re: hot standby cascading replication