Re: Upgrade to 12.2 using same data directory - Mailing list pgsql-general

On Tue, 2020-02-25 at 11:58 +0000, Mihalidesová Jana wrote:
> Is there possibility to upgrade from 10.6 to 12.2 using exact same data directory?
> First problem is with initialing of “new” cluster. Then pg_upgrade check fail.
> 
> ./pg_upgrade -b $OLD/bin -B $NEWd/bin -d $OLD -D $OLD -k -c

No, but that is not necessary.

- Create a new cluster on the same file system as the old one.

- Run "pg_upgrade" with the -k option.

- Remove the old cluster and move the new one in the place of
  the old one.

- Start the server (with the new binaries of course).

Don't forget to ANALYZE.

Yours,
Laurenz Albe
-- 
Cybertec | https://www.cybertec-postgresql.com