News for hackers. Stuff that matters.

A comment on Minimal downtime major PostgreSQL version upgrades with pg_easy_replicate.

Re:Minimal downtime major PostgreSQL version upgrades with p... by hans_castorp on Tuesday June 20, 2023 @05:19PM (#36410806)
There is also a new (OpenSource) Postgres extension that claims to provide multi-master replication based on logical replication, BDR and pglogical

https://pgedge.github.io/spock/

which can also be used for online upgrades.

It however only supports Postgres 15 and (not yet released) 16

[ Parent | on HN ]
Re:Minimal downtime major PostgreSQL version upgrades with p... by justinclift on Wednesday June 21, 2023 @01:55AM (#36414898)
Cool, that's good info. Hadn't come across it before. :)

The GitHub repo page for it is here, for anyone else interested in taking a look: https://github.com/pgEdge/spock

[ Parent | on HN ]
Re:Minimal downtime major PostgreSQL version upgrades with p... by mb4nck on Wednesday June 21, 2023 @12:40PM (#36420881)
spock and pgedge are cool, but they are NOT open source (and they try hard to make it look like they are).

It is under the Confluent license (with s/confluent/pgedge/), basically a source-available-but-Amazon-cannot-use-it kind of license.

[ Parent | on HN ]