Postgres logical replication with datetime condition

0

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.

Sravan
asked 14 days ago71 views
No Answers

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions