PostgreSQL Logical Replication
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.
0 · Share on Twitter