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 1tNK9f-00ABrX-Eh for pgsql-general@arkaria.postgresql.org; Mon, 16 Dec 2024 23:05:35 +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 1tNK9b-00CGmV-TG for pgsql-general@arkaria.postgresql.org; Mon, 16 Dec 2024 23:05:33 +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 1tNK9b-00CGmN-GL for pgsql-general@lists.postgresql.org; Mon, 16 Dec 2024 23:05:32 +0000 Received: from sonic311-25.consmr.mail.ne1.yahoo.com ([66.163.188.206]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1tNK9V-0003IK-9l for pgsql-general@postgresql.org; Mon, 16 Dec 2024 23:05:31 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s2048; t=1734390323; bh=Q3lvpazj7VWdIAsOaHmGFHgIMI64ZIggAmhqFbfsjHk=; h=Date:From:To:In-Reply-To:References:Subject:From:Subject:Reply-To; b=ow8vQigyOgATJ21Xo7QMatquZJ7BqLSn5EH6EKZf/IE5Fln7yUP1uYTeqBnlV55r5whSaMPa2cZwRLqHt6I4lAvVPgpMnbjCZEhhgMmgL0JvQXjnOw1DHAgIceuP11nJ5HztGfq8WY08unJpEgrgTNfRONkZRD46yJQyX5bIBUhgpfAKr536WCq1/4jKMHd/GBb8UtDAgPzaEtDb778U12LqNcptUxEvk/cQsVSvoIG2+iTiqOZ2fmHrrntOVoPNdXbXsUdbQGIYMZxp6vmtU1WGNvmGbCV4bVv9gECanriqU2DLyN/5/ZZ1GOxLtzX+CP/dZaLZggL9sts/NIJiig== X-SONIC-DKIM-SIGN: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s2048; t=1734390323; bh=QNPY8eCU9O+WoUteyN5dMR8vzbOlwpPiXgumI9v/Cym=; h=X-Sonic-MF:Date:From:To:Subject:From:Subject; b=gyjXs4oZsjsIEnlDWUXmTF1FOKnBjn6TTeJx8jzqZviZ+JMZ1FUrs/g+kgl/AWIpXt/vjJ7X0zM+xYls+hCqA9Z9ByB/EGlcr0y6/bO3UEBePDmzftIdAll1ddkGUu4AsqkTJwJZwfhFLBzZyPY+j4px75xH1Z1xyDNg+QfZXhf/RME4QH6DoDf++ecDjd1ncXVmuABu2Pw8+dzaT/xSeWOITt78OcLNv91SmkOnCy3GrJpajTxIlC6nk+ZVbDFqSgJ9TPpWKjN+ziILZgKa4oJuJC/QKcztN4NFJdRd0PqFDSGkeArqQJ5ZtIoTMLD2RNmXFCDOOtwAV9EvsovPaQ== X-YMail-OSG: D3dvMXcVM1lAzStzr5RS4GHrlPTBH79APJjii3agzvrUchg513XmkEzeE8rbIru .AOdeS3lV_JtHm6XvspWiDk5IJt6XrizBNl1mBo0ahhOebn9baKJJV_IOHry24kf7k_KZ.cUfP2p e9AgAkgTyVamIgqvduG6IE5jyzB0q9FG6P9NW6QqRm61v3A7nbi9r3WqXf1UYvj7r_6rYW8g7JDA zhpHALvaRRtHPmmzkEpWE_Ew1HKrbnDmCLEbt2jzjNi2eqxhAIxM4Wb8cTr5ce39d.G8AgsLgE8Q fONM33DHq7gQyKaL1FzdJEUIRS1jCdXFDTBtCmrycq_2oNiKA4pNyauXygvgu_EEhx4rjx2QbCQV o8UK7P5q6OP.ysOAzmR8t4Yj4rf_dDomwpelPI.ayMjMdKKeS7AhflRTy0Dzy3kXZM41srAMEWxS 8KjuSSEgFZPOjMWCHSRMDq9.sUs78HlVzsM77u97dd6rLfXjfhwupPGfrxySTJxfKr_XkU6Sovfb hVqJHYozNsaZIRAaZSXs2PCnPyUSLD6jl9aTwGGY1mlr916SI13QIkm9haIzraxNoesfwAw4eogZ xEXN2qsSIRawwJEwV3EhLn9tdkOCq4OGqpnzw.iqBRIQsG5r_lNmtm6adAf5oqsma.CacbhWCQAM uZ7fhXWGqYSfZUG3dtewsI60fNIo1P63MYCMKtumVvpr_kxCKb2QRoYs6OHG7G23XDxF0xDjIW6Z DDJlVIjuVIt.ryMw27FwhPUIM5hHxsrmOgO0VBTsh1IA9NSGoHpCvsXiCbk3ghQd4rwVwOl.FJP_ uqSt27FfSKp5J7OWmOUsm6CrRNv62KaXluze.DioOr9_4064yFXKT9XQQ50A9C1CgSanTjXHKVRi 5KgWHSnvv4zTASq6zwHbAqvE.jreMgS_7_6dlQi2YuSIGDGpaSXzvAshse7glJMlSNdrJ7PlZPfv 2YBqr0LZpb8tQCYy_gdccderbwBPFL96ANGaVoVO2CUQIK3XTMBki2AeEEVNqpKQs4NW5FVs0xZA 7z273dGqE3qhlb3HfgRjm6ybpiA5JUUx6k9v8F9fEEBYkiv2OpJiPYgKDJJN5W37Pg5GzHtg04Vi EilCdx8FsomYrw5YE0x0ko92okZLGgo6N6gFdldgHM0vMkDb0DRc02tTMH.jZORoWp0BIPPO1e7h Opi0ok1AcY8JFkgijVcvGIvaTsLU6KxkiDDjqsrYWo20JdojZ2iSezkqzFRe1lNHJk7fPIJRIpb1 bW4wHwgnivLdUGnPHlJy2lnQly7RyoyjTl4vxZuJLoMfOsgjGEe9MBOA8AgD5gtqMeR7FZzA9ipA w9sJSEjcK3bCcpCRpkOlrNBZHyG62Ag8RkZ0KWfYjBRaivlDKOy10KRwaNfD9tqpCvRkSZaVP1pY FbAq8_qHQCUyTkWoNyQigfQPF2oVyDcQCX12hm2vNdftJ.mXKkNSo9WU2PNKOiJPeFGUHTLfcvW8 bj0gy20ekyD8ay_19juIiIygLkJtZtIMMNnFn4iidzdDUOtPf1MifJ3LPPlowN4VtvSAHoqB7W3B R4mNk7Rxs_7O3LY93rfNzpeUzpdJpfn4y9U_NxsHnCPLlnAA8ZbcJWTNuv9ajJq9UaxUnYGnJLRs Wqp.QabTJIg7JfnqDj0BPs1Jdo67EwU.XNtrE2W.No2xrmZ0v2vN__WHY1ybhEWL4XepSlTSrWwZ MtCIKbjIeWOXp.MhDknROR750OYtZYk5MGvqLSzSElFYtDQGBoGDozHCw0hwvW7MBQ_9flUEig8i 60DEJySEmqylj4eaB3o8GWXWwUo4O1xc07zGLNmi2XnjcALY5xTvaYIoDI7to0N.2dQLi8ke4McI Y7k63vZ2f8JUYlAMZ7Hu4_vNHRJFQQ1jDHa0z3ysUIvILx2z11qpaEgKhI8ucOwyfwSEzRT1z0sE RF6ZtmBj3VBR7Q02gDQburdkym13EtpqQ11tDxE2JpzLV1ENDKGbOhSi_ui0W5G8Nkao_cBmle62 6HnNdj0An.XUtffa_vBqlrzBnJsffdEIFbElLIVNdvoJeD10OXdxE86fqHD2kpWiFFB5u6L_nXAe Z3hy4qk.CzTNG9l1QWyK8If2RqKkFp8yPRrC8RkqE4LcjFCKoRHtXnJvgc2O1Qqq95Min3pi3B98 btm3lYGvp.HfmgnZXrDve89RjsGYRLYTIE.2UBPXlPWLyFAyCwLyCjA3o4EqF9W9Om30JrUgHUSO 43J18Gk1Qf0XMR4bGszz7MUX32NVt1ney9v_nOslwhijzE7cDVssQVHGrB2xp9w-- X-Sonic-MF: X-Sonic-ID: a897b339-192e-4130-8ce9-31259a085685 Received: from sonic.gate.mail.ne1.yahoo.com by sonic311.consmr.mail.ne1.yahoo.com with HTTP; Mon, 16 Dec 2024 23:05:23 +0000 Date: Mon, 16 Dec 2024 23:05:18 +0000 (UTC) From: Bharani SV-forum To: Ron Johnson , pgsql-general , Adrian Klaver Message-ID: <1528119631.4096246.1734390318281@mail.yahoo.com> In-Reply-To: References: <0558ddd4d71641bdb41fa49b2425f73c@safrangroup.com> <98965993.3138805.1731699978332@mail.yahoo.com> <564950518.5117550.1733177884387@mail.yahoo.com> <07ab2d83-ffe5-4bec-9626-22a68f732579@aklaver.com> <273a88dc-4134-47d5-bc19-30ff5f97926c@aklaver.com> <498dfb34-4dd7-4f48-8188-355e1488d7e6@aklaver.com> <1061066336.5835157.1733316137292@mail.yahoo.com> <1918413683.2239751.1733944364448@mail.yahoo.com> <037a8338-3434-47d4-aaad-ef186d4d3250@aklaver.com> <101139100.4053671.1734383960480@mail.yahoo.com> <1875422740.4095620.1734388259706@mail.yahoo.com> Subject: Re: Additional Help in vetting my steps for Postgres DB upgrade from Ver 13.X to ver 15.X MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_4096245_438057847.1734390318280" X-Mailer: WebService/1.1.23040 YMailNorrin Content-Length: 6009 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk ------=_Part_4096245_438057847.1734390318280 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable TeamBeing dev server, I noticed, we haven't performed analyze/vacuum proce= ss. Noticed and re-triggerred vacuum full and analyze for all the application r= elated db's Re ran backup. No issue's appeared during backup. Not yet performed restoration in pgsql ver 15.09 in new vm with different O= S. Thank you for guiding me On Monday, December 16, 2024 at 05:49:28 PM EST, Adrian Klaver wrote: =20 =20 On 12/16/24 14:30, Bharani SV-forum wrote: > *a) * > *user =3D * > postgres >=20 > b) > *pg_dump version =3D * > /usr/bin/pg_dump -V >=20 > pg_dump (PostgreSQL) 13.16 >=20 > c) >=20 > *DB version* >=20 > select version () ; >=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 = =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0version > -------------------------------------------------------------------------= --------------------------------- >=C2=A0 =C2=A0PostgreSQL 13.16 on x86_64-pc-linux-gnu, compiled by gcc (GCC= ) 4.8.5=20 > 20150623 (Red Hat 4.8.5-44), 64-bit >=20 > *use this script for backup* >=20 > pg_dump -Fp -p 5432 -U "$USERNAME" "$DATABASE" >=20 > using username =3D postgres >=20 > for one of the DB (ver 13.16), it worked fine by doing oldvm =3D pg_dump= =20 > from ver 13.16 and > later restoring in new VM with new OS and new db binary 15.09, post=20 > creating dummy db (appln related) and restoring the pg_dump from oldvm . >=20 That's nice, but the issue is the case that did not work. What process where you running that caused the error? --=20 Adrian Klaver adrian.klaver@aklaver.com =20 ------=_Part_4096245_438057847.1734390318280 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
=
Team
Being dev server, I noticed, we haven't performed anal= yze/vacuum process.

<= div dir=3D"ltr" data-setdir=3D"false">Noticed and re-triggerred vacuum full= and analyze for all the application related db's

Re ran = backup.

No issue's appeared during backup.

Not yet performed restoration in pgsql ver 15.09 in new vm with differ= ent OS.

Thank you for guiding me


=20
=20
On Monday, December 16, 2024 at 05:49:28 PM EST, Ad= rian Klaver <adrian.klaver@aklaver.com> wrote:


=20 =20
On 12/16/24 14:30, Bharani SV-forum w= rote:
> *a) *
> *user =3D *
> postgres
>
> b= )
> *pg_dump version =3D *
> /usr= /bin/pg_dump -V
>
> pg_dump (Pos= tgreSQL) 13.16
>
> c)
>
> *DB version*
> =
> select version () ;
>  &n= bsp;                     =                      = ;      version
> ----------------------= ---------------------------------------------------------------------------= ---------
>   PostgreSQL 13.16 on x86_64-pc-= linux-gnu, compiled by gcc (GCC) 4.8.5
> 20150623 (Re= d Hat 4.8.5-44), 64-bit
>
> *use= this script for backup*
>
> pg_= dump -Fp -p 5432 -U "$USERNAME" "$DATABASE"
>
> using username =3D postgres
>
> for one of the DB (ver 13.16), it worked fine by doing oldv= m =3D pg_dump
> from ver 13.16 and
= > later restoring in new VM with new OS and new db binary 15.09, post > creating dummy db (appln related) and restoring the p= g_dump from oldvm .
>

That's nice, but the issue is the case that did not work.

What process where you running that caused the er= ror?
------=_Part_4096245_438057847.1734390318280--