Re: Moving the master to a new server

From: Glen Eustace <geustace(at)godzone(dot)net(dot)nz>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: Moving the master to a new server
Date: 2022-02-15 19:11:09
Message-ID: 353d6183-a16d-7cd7-31b6-9364a0b6b2b9@godzone.net.nz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


On 16/02/22 1:58 am, Marc Millas wrote:
> another way would be to, while everything running, you create a second
> slave on the new machine on rocky8 with a pg_basebackup

Thanks, I did consider this as well.  Last night I did the move using
the rsync approach and it worked very well.

--
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
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"

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Merlin Moncure 2022-02-15 20:18:35 Re: Can we go beyond the standard to make Postgres radically better?
Previous Message Tomas Vondra 2022-02-15 13:55:42 Re: increasing effective_cache_size slows down join queries by a factor of 4000x