Re: pg_upgrade 9.6 to 12 without 9.6 binaries - Mailing list pgsql-general

From Adrian Klaver
Subject Re: pg_upgrade 9.6 to 12 without 9.6 binaries
Date
Msg-id ba6bc784-c425-9747-9fb8-b2f408a254d7@aklaver.com
Whole thread Raw
In response to pg_upgrade 9.6 to 12 without 9.6 binaries  ("Zwettler Markus (OIZ)" <Markus.Zwettler@zuerich.ch>)
Responses Re: pg_upgrade 9.6 to 12 without 9.6 binaries
List pgsql-general
On 3/13/20 6:47 AM, Zwettler Markus (OIZ) wrote:
> We are running Postgres 9.6 on server A.
> 
> We want to upgrade it to Postgres 12 on server B.
> 
> pg_upgrade requires the old (-b) and new (-B) binary set on the same server.
> 
> We don't want to install both binary sets on the same server as we had 
> some library conflicts in the past.
> 
> Is there still a way to use pg_upgrade without the old (-b) binary set 
> (I am aware of pg_dump/pg_restore)?

No. As I understand it pg_upgrade needs to see the state of old instance 
to recreate that state on the new instance.

> 
> Markus
> 


-- 
Adrian Klaver
adrian.klaver@aklaver.com



pgsql-general by date:

Previous
From: Stefan Blanke
Date:
Subject: Re: ERROR: invalid memory alloc request size 1073741824
Next
From: Ron
Date:
Subject: Re: vacuum full doubled database size