Hi everyone.
I’m upgrading the PostgreSQL version from 12 to 16 using pg_upgrade utility with -k option. After upgrading the
database,before starting any application processing, on checking the last value of some sequences, the value has been
changedto a value different from the original value. Not all but some of the sequences have modified value. I’ve
repeatedthe upgrade several times and each time the same sequences have changed with the same values. I’ve expected
thatthe upgrade would not interfere with the application data …
This is the upgrade command:
/usr/pgsql-16/bin/pg_upgrade \
—old-datadir=/u01/pgrdb/12/app \
—new-data for=/u01/pgrdb/16/app \
—old-bindir=/usr/pgsql-12/bin \
—new-bindir=/usr/pgsql-16/bin \
-k
Best regards,
Dănuț Soare