What are the challenges you face when working across database platforms? Take the survey
Options

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. 

Tagged:

Answers

  • Options
    Hi there,

    Thank you for reaching out.

    Can you please specify which Redgate product you are using in this case?
  • Options
    Stoo1954Stoo1954 Posts: 1 New member
    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.

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Emoji
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file