| From: | Bruce Momjian <bruce(at)momjian(dot)us> |
|---|---|
| To: | David Gauthier <davegauthierpg(at)gmail(dot)com> |
| Cc: | Postgres General <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Can PAF be used to provide zero downtime while primary and backup servers are being patched? |
| Date: | 2020-08-06 22:18:59 |
| Message-ID: | 20200806221859.GA23564@momjian.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Thu, Aug 6, 2020 at 10:01:21AM -0400, David Gauthier wrote:
> Our IT dept needs to install a patch on both primary and backup servers for our
> Postgres Automatic Failover configured DB (version 9.6 on linux). From the
> standpoint of the DB users, can a strategy be implemented such that they see
> zero downtime during this process as the 2 servers are taken down in sequence
> for their patch, switching the role of primary and backup as this happens ?
Assuming this is a minor relase upgrade, you can do it by just bouncing
the servers. You can do the switch-over/switch-back too, but you have
to manage session migration. I wrote a blog about it:
https://momjian.us/main/blogs/pgblog/2018.html#October_1_2018
--
Bruce Momjian <bruce(at)momjian(dot)us> https://momjian.us
EnterpriseDB https://enterprisedb.com
The usefulness of a cup is in its emptiness, Bruce Lee
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Christophe Pettus | 2020-08-07 00:43:29 | Advancing the archiver position safely |
| Previous Message | Lokesh Vij | 2020-08-06 22:03:54 | Standard practices for granting privileges |