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.