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

From Rich Shepard
Subject Re: Move cluster to new host, upgraded version
Date
Msg-id alpine.LNX.2.20.1811120551030.21497@salmo.appl-ecosys.com
Whole thread Raw
In response to Re: Move cluster to new host, upgraded version  (Ron <ronljohnsonjr@gmail.com>)
Responses Re: Move cluster to new host, upgraded version
List pgsql-general
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.

   Anywho, specifying the 10.5 version's hostname (-h) to pg_dumpall on the
11.1 version resulted a few seconds later with an output file.

Regards,

Rich


pgsql-general by date:

Previous
From: Karl Martin Skoldebrand
Date:
Subject: RE: Recommendation for upgrading from PostgreSQL 9.3
Next
From: Ron
Date:
Subject: Re: Move cluster to new host, upgraded version