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 0f099724-7b56-765e-7845-148f3aef7e34@gmail.com
Whole thread Raw
In response to Re: Move cluster to new host, upgraded version  (Rich Shepard <rshepard@appl-ecosys.com>)
List pgsql-general
On 11/12/2018 07:55 AM, Rich Shepard wrote:
> On Sun, 11 Nov 2018, Ron wrote:
>
>> 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.
>
> Ron,
>
>   I've several databases, none 'large.' When I've used pg_dumpall in the
> past it's always with the clean option (-c) and the output directed to a
> specified filename with the -f option. I don't find an -F option on the man
> page.

Hmm.  Apparently -F is only an option to pg_dump.  (I use multiple pg_dump 
statements + "pg_dumpall --globals-only".)

-- 
Angular momentum makes the world go 'round.


pgsql-general by date:

Previous
From: Rich Shepard
Date:
Subject: Re: Move cluster to new host, upgraded version
Next
From: Adrian Klaver
Date:
Subject: Re: Recommendation for upgrading from PostgreSQL 9.3