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
posta un mese fa76 visualizzazioni
Nessuna risposta

Accesso non effettuato. Accedi per postare una risposta.

Una buona risposta soddisfa chiaramente la domanda, fornisce un feedback costruttivo e incoraggia la crescita professionale del richiedente.

Linee guida per rispondere alle domande