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
demandé il y a un mois79 vues
Aucune réponse

Vous n'êtes pas connecté. Se connecter pour publier une réponse.

Une bonne réponse répond clairement à la question, contient des commentaires constructifs et encourage le développement professionnel de la personne qui pose la question.

Instructions pour répondre aux questions