Reconnecting a slave to a newly-promoted master

From: Shawn Mulloney <smolloney(at)gmail(dot)com>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Reconnecting a slave to a newly-promoted master
Date: 2018-07-10 00:58:53
Message-ID: CALYQ6UWzV91_h0U7nLyxXghO98iC92JNJdPVRjeTFrYo_+pj5Q@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I'm unclear on the prerequisites for what must be a very common scenario:

There are three PostgreSQL machines: A, B, and C. B and C are slaves off of
the master, A. A fails, and B is promoted to being the new master. Can C
just be pointed at A and have it "just work"?

Responses

Browse pgsql-general by date

  From Date Subject
Next Message a 2018-07-10 04:40:49 Reporting bug on pgAdmin 4.3
Previous Message Adrian Klaver 2018-07-09 23:53:51 Re: Cloning schemas