pglogical
pglogical copied to clipboard
how to replicate replication data/status
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~