CODEWITHSUNDEEP
postgresqlhigh-availabilitypatch
user3837299
user3837299

Reputation: 339

Patching without downtime in postgres

Just wanted to know if i'm patching my postgres database and I should not have any downtime whatsoever what should i do ? (I'm patching both my Master and Slave Databases)

Upvotes: 0

Views: 922

Answers (1)

Laurenz Albe
Laurenz Albe

Reputation: 247215

If you don't mind running modified PostgreSQL servers, you can run a cluster solution like BDR or Postgres-XL.

With standard PostgreSQL, you can use streaming replication. First upgrade the standby, then manually fail over to the standby, upgrade the primary and use it as new standby server.

All these solutions require that you have a connection pooler like pgBouncer that allows you to redirect client connections between the servers.

Upvotes: 2

Related Questions