Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1s7Acp-0045Zg-Ts for pgsql-general@arkaria.postgresql.org; Wed, 15 May 2024 09:08:41 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1s7Acp-00CgtE-Db for pgsql-general@arkaria.postgresql.org; Wed, 15 May 2024 09:08:39 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1s79bm-00Bcep-6z for pgsql-general@lists.postgresql.org; Wed, 15 May 2024 08:03:30 +0000 Received: from sonic308-56.consmr.mail.ne1.yahoo.com ([66.163.187.31]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1s79bf-000KZ3-Lm for pgsql-general@lists.postgresql.org; Wed, 15 May 2024 08:03:29 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s2048; t=1715760201; bh=9jm6OG+cj2uJwVr9YzAtQLVXsSL4zv0Pj1YCuXPAXjw=; h=From:Date:Subject:To:References:From:Subject:Reply-To; b=iwYPXZeM2yeBPDe997JeKbkGEuy51MS9slI76kh7dCcjI9jR92Ny2dZXEHZD/uivmrGTruwXy0kGEJCwmgzzx/rvkGKVY0xbuURdkdfwCXjpQbEuliK0D666Eipzr9k/WDWlK81RmjmFFeRzr07KrCDf2clcJfBFUct/4udRR0OIIEram900mDkn7BPEiotQFhoBMHOjBXtId4sb13HBBS1v1yN/ObbP5fTrG8FmKXhx8PYRCvPaDAf5f/ydCEjmgmFFep8/33plQgGM6Goz7l9ZSqyeq21RhKDLi9jdU/aU4nVp7+xwA0jHDkRc7Uef6cSD4lTOERZsmbUSvWK/Ow== X-SONIC-DKIM-SIGN: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s2048; t=1715760201; bh=97mlmGb5Ay9MRykt6FFEl2J66JDYMFLBIrTz+5u3e/m=; h=X-Sonic-MF:From:Date:Subject:To:From:Subject; b=Nn+PR1X7lkxxGpeulUXOxmCJWPCO4mYg9zs3SbTZPX46u+9ABjDAQ91MqRkedYXjTiD+gvMeOhEpIcAnRvz/ztObWQqO97QVdzjdGkflqmb7EyCUiS2Bc/3tIbI/Y9isRy+0yhikwNXWIrWJhut/Hv0087d6t/0vmvBfWolt/O/niCKEineLL6KqY2vFI4AgarmgMFRWJQbMmVReY3YkWehUQYHG334ROMayVyJDrbs3ZeJ+APcbC2GPAxitGk2iQ97EHAYUOAyTS7g+FjIP6nb2By/EvgepI7xpeUEzKdn4oQMpN7nrowVwVgRNfxNP8Z85wOEEIAxbfAEZiEQmOQ== X-YMail-OSG: _RKQnKYVM1lqQ9tL8nL9R4hkGcxfKDeWlFYNHwcupZfHuCHYGlsUEuofrh9lT3B FMCMHUxJfMBbkxnwJalQULP2acnCAMM.ug4ikCx4_r7X.1RL19FdqJgpTFLeT3yZH.YbfImPkAED TOm.MnPwp2ViJKzy5cigatjaBK2WUey35OJV_haScUSYCCDkYub2rro4QvJIIupS_AitoyCSTSND incJ1MtL_U6Y0SkFIPJPdd.wtrprkIRb73nzlV7Fy2uu7n8hwsIiQWj4QHgW.VKkds2xFdac_PeV IGb7xzkPG8C1tKVyOASHAk_VGQ6p2dRmUnV7ClToXKaUelQoNgxByO8rfQA8XsmQee70zWlReXpF p8DdcWBf0UkR9FpYC3RhxWjIBircnhfLbmzqSSfj3h7Y_hDuvTv9nr3kC7bt3w7ykotRVfBG9q9Q I.hggVp.HIfWgFPr6U0vhO8_poMnftGMaNnHLf66mgIYSe8oTnant4Iww35KHpL0IBTi6pWqcP6r ggYssT1KfVtGI3ElXy1CU97PF39CpgdDckpqfer2hfAdphTfYS1ZLagPwY6fjJ1DIHP7Mw0muQAz cbzJIC9Du8F9afvZFnXDXZDWoOClxri_GlanTNwXVe6OCiXLVjH97jlRrk5GWRy7x6T0n24zLemv fyxI5m12nIRlANYToj6IsAYx0u_tJMYAHXBdaan8YOky.tXISO7VUPj1qUb4v9Kr5nUAT9lTzMQl ubk63SSEoJPf0SzIU37g0DUqxs6.awK0.GqunK4MfY86Tya6i8xoX3XyKxF1gdrk1ezRsjvwm0AZ a1U1u5FDCRPYWUDNcs9Eu23UR_sIeyxggvTq.ztM15pdQY_zGm8.mr5GAFevAvaBe.JtvA3plINm jMi9XshahzfRPnAxp_imhPWNvBKcwMnOBscISwnq0.cKOGJYGgVpP_rcwDwQ8Gb5UkrvRJbh1QmG kOFh5yGtz3wwcybGH31EK4rdB8dWPE_._RAU4z.9c57Bzsb0Rp2Pc1OwJuwe3zUabunImWvw4KwN afcWQMie2THHZot5BQNYwJUMXF_y3e.QFCWcIalNgd1C8OLYMx7poGXXVD_lHl9t7NAJ6.9KBMK5 bONdi3Td2bS.4gUGmwTKD1NpNfKSJc_kfZDYHkJlIqkjUI.SbQsXKJvB5YcbMsdfr3ha0V2VagFL KtB9MnAXHzmQI.eErYubJfbpldIFKgaEG2Rc9spi7VVt1.HHwPRB5CS.jJ76t9v64p8EvGl8qG.4 gDp3niLQRTiHIiHYXfisrm.B2mpfSEiqnkaeOj8KNgQj1HO0bDXIuaMluHElBYfUiRpzLIqaiOhb jRR7TnRsouPTqgOhqiDiHRh3FcfgA34VXSUb.so6Skm0wTRPOgcBqYdEsqjrYnXqLfTRP7K4nBd9 PDL7e8CcXvhrbfpz0kaXn_y_XdJxZ0xAoFMA7CHVGWOmswJrtZQHJ_4KBad1XSRePUFnqxvXaEDy VzqxfNCv.4r7xcxQOx57qwg0Hb32gcBS5f6jS6muobEQyqgE3P5cDB9AfbvBM6BYY9uekTz9uRen I6W3incLDuwZUD4ANwj3Ud3G9JNuMkUirn.RPmnmXmA5SDxu.DMDmd_K0qh0Bfme51sZEGCb187P 5ZTYWnpF35qz3WPT0U6fXAdIkyr5U4Ts9lo3tpV27fZjhJPG9UbsfYOFJt4dnU_keH0PvTJ7FuSx bV8nyRrU1cIn0gEb8xy90XpnjMxCbnJsNHES0V4FeRyMQ8R5gRPdVr3bOYnnVbioqxCJ7d9a7Fv6 kV2hBi2c50UokzhtqtR7BgRdemu3721T3vadgXsfrXfbNDFSSiFWrjiCYM1qP_s590qMRH19QgQg 0OyU2PN02iYDN54M4dnKZme.0D7yZoLUMMVmjJeFp4wnVrPElnG8DJMiCfQSnT.pexnEEEHA8QUH yuupY6eci0Jd4EbpMOgu_yA_m1jnIXbp22iAPTJ9SLR5.R0xdsVx_jEZyFfAbHO8VgUbCKXk9rph caAKdRlkDzbU_A1cBC0xvrstBkbOeWP1CDLC6hryu_sftcTacfrAQtruoQSQf8LzBPri8CcSn8Ia wc0jwfrjgwQyShlwBD7Ind6SviEmgfYjKcBndgUF4wf0BiR7rUu.5j1iNm4iaxbnXuErHDg2o3Vo ROy9Rym6obQ2HLKp2fLCRQH5vhOkhfmrRao6v7CjSsRb.amQbGoxgTwfwCNB8 X-Sonic-MF: X-Sonic-ID: a6ab81a2-9bf4-40c4-ae58-53b49863705a Received: from sonic.gate.mail.ne1.yahoo.com by sonic308.consmr.mail.ne1.yahoo.com with HTTP; Wed, 15 May 2024 08:03:21 +0000 Received: by hermes--production-ir2-7b99fc9bb6-mp7rb (Yahoo Inc. Hermes SMTP Server) with ESMTPA ID dee29a53cdda08c010bfab2aa02b8b06; Wed, 15 May 2024 08:03:17 +0000 (UTC) Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable From: Danut Soare Mime-Version: 1.0 (1.0) Date: Wed, 15 May 2024 11:03:05 +0300 Subject: Sequence values change during upgrade Message-Id: To: pgsql-general@lists.postgresql.org X-Mailer: iPhone Mail (21E236) References: Content-Length: 863 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Hi everyone. I=E2=80=99m upgrading the PostgreSQL version from 12 to 16 using pg_upgrade= utility with -k option. After upgrading the database, before starting any a= pplication processing, on checking the last value of some sequences, the val= ue has been changed to a value different from the original value. Not all bu= t some of the sequences have modified value. I=E2=80=99ve repeated the upgra= de several times and each time the same sequences have changed with the same= values. I=E2=80=99ve expected that the upgrade would not interfere with the= application data =E2=80=A6=20 This is the upgrade command: /usr/pgsql-16/bin/pg_upgrade \ =E2=80=94old-datadir=3D/u01/pgrdb/12/app \ =E2=80=94new-data for=3D/u01/pgrdb/16/app \ =E2=80=94old-bindir=3D/usr/pgsql-12/bin \ =E2=80=94new-bindir=3D/usr/pgsql-16/bin \ -k Best regards, D=C4=83nu=C8=9B Soare