Sequence values change during upgrade - Mailing list pgsql-general

From Danut Soare
Subject Sequence values change during upgrade
Date
Msg-id F295D74C-B606-4845-8C38-9C7EA4DC7378@yahoo.com
Whole thread Raw
Responses Re: Sequence values change during upgrade
List pgsql-general
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




pgsql-general by date:

Previous
From: Muhammad Imtiaz
Date:
Subject: Re: pg_stat_io clarifications: background worker, writes and reads
Next
From: Sašo Gantar
Date:
Subject: problem with query