Re: Upgrading to v12 - Mailing list pgsql-general

From Tom Lane
Subject Re: Upgrading to v12
Date
Msg-id 128408.1668205654@sss.pgh.pa.us
Whole thread Raw
In response to Re: Upgrading to v12  (Brad White <b55white@gmail.com>)
Responses Re: Upgrading to v12  (Brad White <b55white@gmail.com>)
List pgsql-general
Brad White <b55white@gmail.com> writes:
>> Can you do a pg_dump of that database?

> Yes. No visible problems. No errors reported.

Well, that's quite interesting, because pg_dump ought to read
all the same catalogs that pg_upgrade is failing to read.
So I'm not quite sure what's going on there.  Nonetheless,
your path forward is clear: use pg_dump (or better pg_dumpall)
and then load the output into a freshly initdb'd v12 installation.
It'll be a bit slower than the pg_upgrade way, but it'll work.

            regards, tom lane



pgsql-general by date:

Previous
From: Brad White
Date:
Subject: Re: Upgrading to v12
Next
From: Adrian Klaver
Date:
Subject: Re: Upgrading to v12