From: | Glen Eustace <geustace(at)godzone(dot)net(dot)nz> |
---|---|
To: | pgsql-general(at)lists(dot)postgresql(dot)org |
Subject: | Moving the master to a new server |
Date: | 2022-02-14 19:29:42 |
Message-ID: | 8891e8ab-2351-8b97-5496-f3bf4b19922b@godzone.net.nz |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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.
Currently the slave serves as a read-only target for various services so
they should all just keep running.
The postgresql versions are 10.20 on the old and 10.17 on the new.
(Basically this is a CentOS7 to Rocky8 migration) I have been using the
PGDG rhel version so it is a little ahead of the appstream
Comments ?
--
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Glen Eustace,
GodZone Internet Services, a division of AGRE Enterprises Ltd.,
P.O. Box 8020, Palmerston North, New Zealand 4446 Ph +64 6 357 8168, Mob +64 27 542 4015
“Specialising in providing low-cost professional Internet Services since 1997"
From | Date | Subject | |
---|---|---|---|
Next Message | Alan Hodgson | 2022-02-14 19:39:21 | Re: Moving the master to a new server |
Previous Message | JORGE MALDONADO | 2022-02-14 17:47:23 | npgsql versus dotConnect data provider |