Re: pg_upgrade 9.6 to 12 without 9.6 binaries

From: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
To: "Zwettler Markus (OIZ)" <Markus(dot)Zwettler(at)zuerich(dot)ch>, pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: pg_upgrade 9.6 to 12 without 9.6 binaries
Date: 2020-03-13 15:09:31
Message-ID: ba6bc784-c425-9747-9fb8-b2f408a254d7@aklaver.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(dot)klaver(at)aklaver(dot)com

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ron 2020-03-13 15:15:10 Re: vacuum full doubled database size
Previous Message Stefan Blanke 2020-03-13 14:29:57 Re: ERROR: invalid memory alloc request size 1073741824