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
