Re: Upgrade check failed from 11.5 to 12.1 - Mailing list pgsql-general

From Tom Lane
Subject Re: Upgrade check failed from 11.5 to 12.1
Date
Msg-id 216128.1608328504@sss.pgh.pa.us
Whole thread Raw
In response to Upgrade check failed from 11.5 to 12.1  ("Lu, Dan" <Dan.Lu@sig.com>)
Responses RE: Upgrade check failed from 11.5 to 12.1
List pgsql-general
"Lu, Dan" <Dan.Lu@sig.com> writes:
> I am trying to upgrade an instance of PostgreSQL in unix from 11.5 to 12.1.

> UNIX:> pg_upgrade -d /hostname/pg/dpoc/data -D /hostname/pg/dpoc/data -b /hostname/pg/PostgreSQL-11.5/bin -B
/hostname/pg/PostgreSQL-12.1/bin-p 5432 -P 9432 -c -v 

No, you can't use the same directory to hold old and new versions at the
same time.  After you're done with the upgrade, you could move the new
data directory to be where the old one had been.

            regards, tom lane



pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Unexpected result count from update statement on partitioned table
Next
From: "Lu, Dan"
Date:
Subject: RE: Upgrade check failed from 11.5 to 12.1