Re: Moving the master to a new server

From: Alan Hodgson <ahodgson(at)lists(dot)simkin(dot)ca>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: Moving the master to a new server
Date: 2022-02-14 21:44:45
Message-ID: d8c6c7d6ed67485e7d0af0db64d50b7cb9255f4e.camel@lists.simkin.ca
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Tue, 2022-02-15 at 08:58 +1300, Glen Eustace wrote:
>
> But upgrading that way takes too long for the master so I build a
> new
> server instead. So, if I shutdown both postgresql instances old and
> new,
> rsync the data directory and restart on the new. I should be OK ?
>

Should be, yeah.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message David G. Johnston 2022-02-15 00:06:16 Rows From but with Subqueries (or a cleaner non-array-using alternative)?
Previous Message Tom Lane 2022-02-14 21:44:06 Re: table not found on publisher