| From: | Michael Paquier <michael(at)paquier(dot)xyz> |
|---|---|
| To: | Jehan-Guillaume de Rorthais <jgdr(at)dalibo(dot)com> |
| Cc: | Rita <rmorgan466(at)gmail(dot)com>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: what to do after a failover |
| Date: | 2020-01-10 00:11:24 |
| Message-ID: | 20200110001124.GC1702@paquier.xyz |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Kyotaro Horiguchi | 2020-01-10 01:07:48 | Re: How can I pushdown of functions used in targetlist with FDW ? |
| Previous Message | Tom Lane | 2020-01-09 21:31:44 | Re: 12.1 not useable: clientlib fails after a dozen queries (GSSAPI ?) |