Re: Moving the master to a new server

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.