Logical Replication extension for PostgreSQL 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.
I am using pg9.6.
I need to move a provider to a new server, I plan to dump old sql and run the sql on the new server/databse.
So technically, the old and new are two databases.
When I drop old node in subscription, and create new node for new server, it will try a new INSERT operations on subscription server, and results in fail.
So in this case, is there any suggested better way to do this movment?
I am using pg9.6. I need to move a provider to a new server, I plan to dump old sql and run the sql on the new server/databse. So technically, the old and new are two databases.
When I drop old node in subscription, and create new node for new server, it will try a new INSERT operations on subscription server, and results in fail.
So in this case, is there any suggested better way to do this movment?