Re: Move cluster to new host, upgraded version

From: Rich Shepard <rshepard(at)appl-ecosys(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Move cluster to new host, upgraded version
Date: 2018-11-11 20:18:19
Message-ID: alpine.LNX.2.20.1811111216260.28051@salmo.appl-ecosys.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Sun, 11 Nov 2018, Andrew Gierth wrote:

> The most reliable and preferred procedure is to use the _new_ version's
> pg_dumpall, for example by allowing access to the old host from the new
> one (possibly using an ssh port forward), or (on OSes that make it easy to
> do package installs of multiple versions) to install the new pg_dump and
> pg_dumpall on the old system.

Andrew,

Using the SlackBuilds.org script with an updated version number worked for
11.1. So, I'll install it on the old desktop and upgrade in place. Then I
can use the 11.1 pg_dumpall on the data directory and copy that over to the
new desktop.

Thanks,

Rich

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2018-11-11 20:22:51 Re: Move cluster to new host, upgraded version
Previous Message Ravi Krishna 2018-11-11 20:16:58 Re: Copy data from DB2 (Linux) to PG