Re: Move cluster to new host, upgraded version - Mailing list pgsql-general

From Ron
Subject Re: Move cluster to new host, upgraded version
Date
Msg-id 896f8cf1-ec19-b049-7e0a-05c971840366@gmail.com
Whole thread Raw
In response to Re: Move cluster to new host, upgraded version  (Rich Shepard <rshepard@appl-ecosys.com>)
Responses Re: Move cluster to new host, upgraded version
List pgsql-general
On 11/11/2018 02:51 PM, Rich Shepard wrote:
> On Sun, 11 Nov 2018, Adrian Klaver wrote:
>
>> pg_dumpall is going to need to run against a Postgres server not just a 
>> data directory.
>
> Adrian,
>
>   Of course. Yet it's the data directory that's written to the .sql file.

Unless your db is small, do a parallel dump.  Even then, do a "-Fc" backup 
instead.  That's been the recommended method for many years.


-- 
Angular momentum makes the world go 'round.


pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: Move cluster to new host, upgraded version
Next
From: magodo
Date:
Subject: pg9.6 when is a promoted cluster ready to accept "rewind" request?