Postgres Pro
Downloads
Home   >   mailing lists

Re: Moving the master to a new server - Mailing list pgsql-general

From Alan Hodgson
Subject Re: Moving the master to a new server
Date
Msg-id d8c6c7d6ed67485e7d0af0db64d50b7cb9255f4e.camel@lists.simkin.ca
Whole thread Raw
In response to Re: Moving the master to a new server  (Glen Eustace <geustace@godzone.net.nz>)
List pgsql-general
Tree view
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.

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: table not found on publisher
Next
From: "David G. Johnston"
Date:
Subject: Rows From but with Subqueries (or a cleaner non-array-using alternative)?