Re: what to do after a failover
Jehan-Guillaume de Rorthais <[email protected]> Thu, 9 Jan 2020 15:14:59 +0100
| Newsgroups | gmane.comp.db.postgresql.general |
|---|---|
| Organization | Dalibo |
| Message-ID | <20200109151459.03111216@firost> |
On Thu, 9 Jan 2020 06:55:18 -0500 Rita <[email protected]> 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,