PostgreSQL Logical Replication

spedersoli

Hello, I'm new to postgresql and I have requirement to sync the data in single source table to single target table in different database (same server). The tables are the same, all DML changes on source table need to be pushed to target table. Is logical replication best solution for this? I'm a little confused because documentation seems to indicate replication is for copying objects from one server to another, which I'm guessing is the typical use case, but I would like to use this approach for my use case. 

chrisqtran

Hi there,

Thank you for reaching out.

Can you please specify which Redgate product you are using in this case?

Stoo1954

In your case, setting up logical replication between the source and target tables would allow you to efficiently replicate DML (Data Manipulation Language) changes from one table to the other. This means that any inserts, updates, or deletes made to the source table would be automatically propagated to the target table, ensuring consistent data across both.