Hi Team,
We want to setup a replication between 2 PostgreSQL RDS instances using logical replication. The condition we have is that on the master instance, we have around 4 years of data, but on the second instance (ideally, slave), we want the data to be replicated from January 1, 2024. And also, only 20 tables should be replicated that have datetime or timestamp columns.
I tried to find different options to use with 'pg_logical_replication_table_allowed' but wasn't able to successfully achieve this requirement.
AWS OFICIALAtualizada há um ano
Which version of Postgres is the instance running? 15 added improvements for logical replication that might be what you are looking for. https://www.postgresql.org/docs/15/sql-createpublication.html