Logical Replication to Older Version - Mailing list pgsql-general

From Miles Elam
Subject Logical Replication to Older Version
Date
Msg-id CAALojA_A+6CO375Fbh6+6oUuMJmY5aaYfMihBP4O9yfJrKsF6g@mail.gmail.com
Whole thread Raw
Responses Re: Logical Replication to Older Version  (Miles Elam <miles.elam@productops.com>)
List pgsql-general
We recently upgraded from v9.6 to v13 but are seeing some problems. It's on AWS Aurora, so I won't ask to diagnose a heavily altered version. We're hoping for better results with v12, but when we set up logical replication from v13 to v12, while the initial data snapshot copies the data, pg_stat_replication remains empty.

There are no v13-specific features or idioms in use in the databases. As a sanity check, should it be possible to set up logical replication from a newer version of PostgreSQL to an older version? Has this scenario been tested? Has the logical replication protocol changed between versions?


Thanks in advance,

Miles Elam

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: No xmin in pg_database
Next
From: Miles Elam
Date:
Subject: Re: Logical Replication to Older Version