Re: what to do after a failover

From: Jehan-Guillaume de Rorthais <jgdr(at)dalibo(dot)com>
To: Rita <rmorgan466(at)gmail(dot)com>
Cc: Michael Paquier <michael(at)paquier(dot)xyz>, pgsql-general(at)postgresql(dot)org
Subject: Re: what to do after a failover
Date: 2020-01-09 14:14:59
Message-ID: 20200109151459.03111216@firost
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Thu, 9 Jan 2020 06:55:18 -0500
Rita <rmorgan466(at)gmail(dot)com> wrote:

> Thanks for the response.
> I am using Postgresql 11.
> I want something simple and I have a strong preference toward using stock
> tools. After the promotion and the original master comes online, I was
> thinking of doing a pg_basebackup to sync. Any thoughts about that?

If you can afford that, this is the cleanest and easiest procedure you could
find.

Note that pg_basebackup need an empty PGDATA, so it will have to transfert the
whole instance from new promoted primary to the original one.

Regards,

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Peter Eisentraut 2020-01-09 15:52:53 Re: Is it safe to transfer logical replication publication/subscription?
Previous Message Rita 2020-01-09 11:55:18 Re: what to do after a failover