Re: what to do after a failover - Mailing list pgsql-general

From Michael Paquier
Subject Re: what to do after a failover
Date
Msg-id 20200110001124.GC1702@paquier.xyz
Whole thread Raw
In response to Re: what to do after a failover  (Jehan-Guillaume de Rorthais <jgdr@dalibo.com>)
List pgsql-general
On Thu, Jan 09, 2020 at 03:14:59PM +0100, Jehan-Guillaume de Rorthais wrote:
> 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.

Simple is easier to understand.  Now the larger your instance, the
longer it takes to copy a base backup and the longer your reduce the
availability of your cluster.  So be careful with what you choose.
--
Michael

Attachment

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: 12.1 not useable: clientlib fails after a dozen queries (GSSAPI ?)
Next
From: Kyotaro Horiguchi
Date:
Subject: Re: How can I pushdown of functions used in targetlist with FDW ?