Re: what to do after a failover

--aT9PWwzfKXlsBJM1
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline

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

--aT9PWwzfKXlsBJM1
Content-Type: application/pgp-signature; name="signature.asc"

-----BEGIN PGP SIGNATURE-----

iQIzBAABCgAdFiEEG72nH6vTowiyblFKnvQgOdbyQH0FAl4XwSwACgkQnvQgOdby
QH3jyw/+N5EmkjsPNqCkjBoC0flPnlRpRPLmPNrrwbVXS5t9P2iUuFctS9mkFsOL
u/nxKkODq+101n1sdmADvn+ICHdfHll7vsfmA4ZkCeOEUwuLJzvKMSLXHSjhXHzW
HW1SuQr3Z4k04tv9KLSY+5T1vktQR9Q/lrrSLyQb6qywySH0XwCtQrKXBn3zUC9q
aZ+IJgcuuhxxCDaOvem+4IWTinymEcFN5udF2BHYrKVytfyEbhxYVH5gmqfX11ob
9SUXAmckFGzOBN/E37lR57MuXDwqcGLnFHZO52Rhg2m3RjBmuQLpqy4t73EtgxQt
S27bfCtK9dGt4vNnwB/qo5an098gHA2JUqjhfqJcJo/Ls2nZ7gn3lxdERJrDPKII
rtA8Qz8bionyiEhyVNGkLW5r+5NppEqtKejANdsgSVq0CwQZPvQpEof+8OEzqmZD
siPI22bugD1RSCyZHWXJwO46exRF5uHuONFPglzG8Wg4aKZmShbchPcEnTjGLK4p
dl+M1a9je4fBxFYwXTZVYAhAxwyurhnSnvMPLsu3jMj4ejM+J6c3YKWb8yrilSvA
3/CdwDKxQi1FGuRQ8N4JEQt0aZ7ei8paLCsZHmFypZCUWiki/oLR/YawWKynKP7N
AkV23qg3keQzlbph9LU+F4lQ07tHfJq5HLB25jP3uvez7LuPtRE=
=8bNw
-----END PGP SIGNATURE-----

--aT9PWwzfKXlsBJM1--