Re: Moving the master to a new server

[Alan Hodgson <ahodgson@xxxxxxxxxxxxxxx>]

On Tue, 2022-02-15 at 08:29 +1300, Glen Eustace wrote:

I need to move my master postgresql deployment to a new server.

I am comfortable with stopping all connections then doing a pg_dumpall >

psql to move the databases, they are not huge so this completes in an

acceptable time and I am not expecting any data loss but I am unsure of

what impact this will have on the streaming replication.  I will be

rebooting the new server with the old servers network configuration so I

am hoping that when I let connections back in, replication will just

restart but I cant find any documentation that says so.

pg_dump -> restore will break your streaming replication. You'll need to set it up again.

If the PG version isn't changing and you're still on the same version of Linux, rsync would be easier.