Re: Upgrade check failed from 11.5 to 12.1

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Lu, Dan" <Dan(dot)Lu(at)sig(dot)com>
Cc: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Upgrade check failed from 11.5 to 12.1
Date: 2020-12-18 21:55:04
Message-ID: 216128.1608328504@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"Lu, Dan" <Dan(dot)Lu(at)sig(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Lu, Dan 2020-12-18 22:56:08 RE: Upgrade check failed from 11.5 to 12.1
Previous Message Tom Lane 2020-12-18 20:57:45 Re: Unexpected result count from update statement on partitioned table