CODEWITHSUNDEEP
postgresqldatabase-replicationpostgres-fdw
CBat
CBat

Reputation: 13

Postgres data sync between different servers

I have 2 postgres clusters (A and B) on different servers. Whenever data is written to the table on server A, I want to copy the data to the table on server B. But the data retention in the table on server A is only 1 month whereas the data needs to be retained for 1 year on server B. (The tables are partitioned)

How can I achieve this?

Upvotes: 0

Views: 38

Answers (0)

Related Questions