Logical Replication extension for PostgreSQL 17, 16, 15, 14, 13, 12, 11, 10, 9.6, 9.5, 9.4 (Postgres), providing much faster replication than Slony, Bucardo or Londiste, as well as cross-version upgrades.
Let's say:
I have a provider node and a subscriber node; and some replication tables configured in the provider node.
And I need to move provider node from old machine to new machine.
After copy data from old machine to new machine, the pglogical does not work because while replicate data in new machine, it tries to insert duplicate row to subscriber and result in pk violated.
Is there a way to "clone" all things include replication status from old machine to new machine?
I have many such dbs need to move from old machine to new machine.
Let's say: I have a provider node and a subscriber node; and some replication tables configured in the provider node.
And I need to move provider node from old machine to new machine.
After copy data from old machine to new machine, the pglogical does not work because while replicate data in new machine, it tries to insert duplicate row to subscriber and result in pk violated.
Is there a way to "clone" all things include replication status from old machine to new machine?
I have many such dbs need to move from old machine to new machine.
Thanks~