Re: Sequence values change during upgrade

2024-05-16 Thread Danut Soare
Hi, Thank you for your answer. Here is the requested information. select last_value from seq_name; The difference was less than 32 except one sequence with difference equal to 32 The cache used for sequence creation was 1. Thank you once again! Dănuț Soare > On 15 May 2024, at 14:01, Laurenz

Re: Sequence values change during upgrade

2024-05-15 Thread Laurenz Albe
On Wed, 2024-05-15 at 15:17 +0300, Danut Soare wrote: > The difference was less than 32 except one sequence with difference equal to > 32 > > The cache used for sequence creation was 1. Great. Then everything is working as expected. Yours, Laurenz Albe

Re: Sequence values change during upgrade

2024-05-15 Thread Laurenz Albe
On Wed, 2024-05-15 at 11:03 +0300, Danut Soare wrote: >  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 > chang

Sequence values change during upgrade

2024-05-15 Thread Danut Soare
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 changed to a value different from the original valu