Our Journey to PostgreSQL 12

Re:Our Journey to PostgreSQL 12 by paulryanrogers on Monday January 25, 2021 @07:33PM (#25910905)

Good questions. As logical replication matures it may someday be possible to replicate among versions.

[ Parent | on HN ]

Re:Our Journey to PostgreSQL 12 by skunkworker on Monday January 25, 2021 @08:46PM (#25911436)

Logical replication would be nice, but at the moment it's far too slow to replicate for heavy day-to-day use, other than doing a pg upgrade between primaries and replicas.

[ Parent | on HN ]

Re:Our Journey to PostgreSQL 12 by sharadov on Monday January 25, 2021 @07:44PM (#25911017)

I've replicated across different PG versions, there is an extension called mimeo, which is fantastic for logical replication https://pgxn.org/dist/mimeo/1.5.1/doc/howto_mimeo.html

[ Parent | on HN ]