pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Rui DeSousa <rui@crazybean.net>
To: Pierre Ochsenbein <pierreochsenbein@gmail.com>
Cc: Shreeyansh Dba <shreeyansh2014@gmail.com>
Cc: pgsql-admin <pgsql-admin@postgresql.org>
Subject: Re:
Date: Mon, 5 Nov 2018 11:59:58 -0500
Message-ID: <EA4685AD-1D43-4CDD-B7F7-DEF15AFA13D1@crazybean.net> (raw)
In-Reply-To: <CABG8FoM55JvZ+-wq8nMajJ3KBHx5cWos758EEAmEhWiYWMiO3g@mail.gmail.com>
References: <CABG8FoPZ+FxveeQNCON1OaUhKBogG4o5A6OqvK1rwtXxTL59JQ@mail.gmail.com>
	<CAGDYbUMm8X9=TBzR5C=1XjFxr9NSsfrGHe94P2976GrOD1OBDg@mail.gmail.com>
	<654000BF-8F3C-4CB2-AB9D-93E9E3C85B23@crazybean.net>
	<CABG8FoM55JvZ+-wq8nMajJ3KBHx5cWos758EEAmEhWiYWMiO3g@mail.gmail.com>



> 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 the existing 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.






view thread (7+ messages)

Message-ID: <EA4685AD-1D43-4CDD-B7F7-DEF15AFA13D1@crazybean.net>
Permalink:  ../EA4685AD-1D43-4CDD-B7F7-DEF15AFA13D1@crazybean.net/
Also on:    postgresql.org/message-id/EA4685AD-1D43-4CDD-B7F7-DEF15AFA13D1@crazybean.net

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-admin@postgresql.org
  Cc: rui@crazybean.net, pierreochsenbein@gmail.com, shreeyansh2014@gmail.com
  Subject: Re:
  In-Reply-To: <EA4685AD-1D43-4CDD-B7F7-DEF15AFA13D1@crazybean.net>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

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