what is suggested when I need to move a provider to a new server?

[jingjingan]

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?