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 1tNIV6-009zV0-Ez for pgsql-general@arkaria.postgresql.org; Mon, 16 Dec 2024 21:19:37 +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 1tNIV3-00BAH6-H8 for pgsql-general@arkaria.postgresql.org; Mon, 16 Dec 2024 21:19:34 +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 1tNIV2-00BAGy-UC for pgsql-general@lists.postgresql.org; Mon, 16 Dec 2024 21:19:34 +0000 Received: from sonic319-20.consmr.mail.ne1.yahoo.com ([66.163.188.82]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1tNIV0-0002HG-FP for pgsql-general@postgresql.org; Mon, 16 Dec 2024 21:19:33 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s2048; t=1734383967; bh=KGkvOt3GUH542AIHRbZ8YXwQyNDHDs+PSnlLL82MMLA=; h=Date:From:To:In-Reply-To:References:Subject:From:Subject:Reply-To; b=n0917eHJTqDieNRcvyCdT8H9i36jefS8UpxDSmhXfhDqY0tadwR/MPAOHjKfTVtr7gmntvKRqIl6ikGKmxfotzvtAoP55nO6XOyOIJaQVQ5NEGFHpXEk5MYIwchoUoSkOqPc15Cll6MFgFPZctLAQHhVytJIei4Iq8BFusSWDR1qT4kvfPxfr0nUt1Hz3YxL4bhYh/SLdb8+jct2xkPaZGg4FZJZNlAiUwS1clsDhbzSjOpbH272t1fCPwrB3E+4DVFzhoL/F6hEflnDRIfSLf86dj2d0W3GWmzNnBqjqFL0Nu0snPKGk3LTLyhIIwRCor5KNEcWGm7VxPMe1NX+NA== X-SONIC-DKIM-SIGN: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s2048; t=1734383967; bh=RUmPcNb6ZvzhYiqWT4aQ+qfdlpLN4FEEz0z0I6v8K65=; h=X-Sonic-MF:Date:From:To:Subject:From:Subject; b=ZiT+51slpo16hnE3N2pg/Wb8m4xKjdEVic5OdabcnGnQrNhDsUrYcrPqp7Cv2L/CJb2LhjBPHZTHy1hKTbyC69r440awhkrWWkSYTWe4v1FcOgOryP7N1CqyqCUMlvVBR+JHx/MDn2r8402Hn26MEVfyn/cF88jzt7CAwnkqcZ1il6zeSAuOmMgieGIqT42C/BOZ8w1KB1ptMe3+92x0yBBLkkD/Wfdsy+xhV+n605T2zfAPcLpoPwHH9p7tKr3XZjHdKXG9PMTZYeaMfET5MmzB73mlEOCFQdTU4W/2oRFhcKgUmaicz/NVuEbDMwYLePCCkbe7lv18LAdB3HtLuA== X-YMail-OSG: ueuLoLQVM1lHrCzJvYvyk3liz5MDGWwFbIANKi5NifrSCFhcNXMouEVjbAkf4Ge Wyh1Awm819HdbYaVQe_PV9wEFEMUgvIoUZB73azG7y9aE45TgY2mZHCxiWebTqPml4Lui8fb9ZIX fHm4sa09MVvu9mdIKJ1C.mG1jSaG6ZG1B_GqxXzTmf0b0Zxb92f4MgsUJ13qKB6FipmWc.McvpTY EavEBV01PipVOOLcoEkbPUp.suQIdz1gojyzfwUL7vhYzkbx2ijgQOL2JYA3PWUbzhL2iipKQwf8 V7sYjf1Z1H_Kvj3MbGa8X_Y5OpZB0ogiVhMgYEyhpzusjE9CeVZzu3VG8NLzLAvfsqNZ0QXi2wdY qSXicTpemLY4fiNTz5l2F3DZRwk.DObA938SHkrF8VRz8TcGE_E2qHUMFOx8jX5WeUwJjo82_vEK rvjVP0GfdJE9uffUECrPfMoi1D9BoLUvgL8pM_46P971Pa262HeC0pVIash36hh.RpK10VbC4lG1 oAVz.dpZHgHui.jXsBNplZLqdCEwYZH4jjhELqBfE8JUJr2JH9O6BINfjQCTT_yuec0o9jBIcWpX _UmV1k2INarakI7yjNW_umgRl6a.8wJyVV2S_VtcVZny6b1HCuhXztCkmg0_H7KLkss_PD3PVq5q hpPvOrBxP_hdQXWKMtw0Nis6Pwi4U_kKX4uH17OwhImg.MA2HKdPHG4XQ43F.1HR_8pdANLT0I_w .ls2EkaEecby7wPGmcAchdUtruLpyYHI1_to9tiUgfOATd.G6nX_X7nBSm3dkIpv03zcN0iiJkyo utALF6IefSBqRle.7ANcX8FFRUIPASkarcqx3Bsv0x_8tU38MYDeDEuJoS0T12NN15LEOcF5b5dA qVvJ.5_uc1HPPv.IPObKzjgAmiCpJOqXIB8__gRuITwXlP7xKO1txeHDp9jMpGDqaWlvEvKjjHyr CTXhDrFes_qdGnXjred_wx4_WCtNSQtffcUyKQzilrqbhXyVyUv2HEPUP51hGQTp27v1GKPqlWZD SUfJYOZe_pMGOP1siMHVT8LCB7hNogdXDLsJKWLIcd7U5MA1M_gWdKB8v2RccHSArhG57bv8h00Z jDqGySN1Tq9fM7w0RsNkilQu.G.odgVi1KdoMt.tOlGlQBZjltsOYBtPt8FUYosawoXq8v2aGrx. NO_7rQv476uXSCs0u7MPt1I56fkB9wy4IoP.WIYFRLn2IKOtWb_JeEUm4vjbfSjKoE40k8x72vTI imbHD_UlfLnkT9UG26348Ib.o7xPAxNjRHLv92MXDhY.GDC5p6vL7xpoEtrhrSFeg8RyApQmBtm_ b.qeEgwnbtXeB84aAoubre.oqPK2bCA5qwhBVS5LDzKNy27QwrEXu2fw02C4vxI7lHLikl9btBxj aMLrbBGfI7NmgFL4TDZwfbs6pyTnEtHlDqt6C0k54OBvj8jrjvaLskbYpfSStCafYO_jmMypGuV4 _q5RcRVr.Im8z4ikWEyH4yFsgcvfdQGIxkXoyuH9HsuZ3m2BKkpW78ZFxENSr3Rxw5eryiUkbzn_ .C8dV65SX.nzweE9n7Ojon2bYAOAMaDYcZUaY.rbXlOMIruAr6pu5aoZP0u8lpMVSL4qHhurF0WP dXg3jLJiqRg7CLGj24Mmyu9SwhkIOlfdyTysfwvtm..ip0dxmTCopCwWPlvt0QoAfoCjcrTDOCN4 DBeNCq2DxJXL6rKrVjooDFciEQXHu9fVzC8xCrm_BXRE5DjE1unmEy8t3oHLUOwngS._OovoITOm xH.MegUSIOHimNDPHyLXu0IFf8WHxiWXmFmB.uuNUzuBld47uu0reKfGRq.qwYzz8q3QQHvQVzlh VaugvDccR1nqLkgiC4r_ionVqjeh.oW5N2jXklX6JTrdnkSHpRjPOoJLysbd1K1Yk2P0vVIbH.fQ 5LUgJswGWEEeBKwHUS1Xe5FqoB2kaTenhWLcWRx5_E3HpO2fP5z5f.0DH860zwlNMKgyo0Dd.AWt HaBpFAzWEKl.aODVCPsvmhCnuutGoACny6T9N4gZW.jijy8C7g2tE39L17XD6LM7N1kGN_2hVbmV gIWKOpuTss8wfausb8AaWWw9jlZNoiPc2oCS0sOdeK.sZwtqyyuFFuUAIaG.1KyQqBhaB4iCIrVK Ae0834sGq9P0BtHBXcLVoRHAwmZJ4hP6PSnogoKhcpGsPsse_Ztvj2p01YlMifGq2fK1OX3vi7Kj TwOaYZiyq1L5c3DCqlicQZySzRFFlyEGAQUof3wKLurC2pVne1W.TjLU6HmOB8g-- X-Sonic-MF: X-Sonic-ID: 941e16b1-7bfa-427a-830c-16a842ad04b5 Received: from sonic.gate.mail.ne1.yahoo.com by sonic319.consmr.mail.ne1.yahoo.com with HTTP; Mon, 16 Dec 2024 21:19:27 +0000 Date: Mon, 16 Dec 2024 21:19:20 +0000 (UTC) From: Bharani SV-forum To: Ron Johnson , pgsql-general , Adrian Klaver Message-ID: <101139100.4053671.1734383960480@mail.yahoo.com> In-Reply-To: <037a8338-3434-47d4-aaad-ef186d4d3250@aklaver.com> 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> 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_4053670_635903127.1734383960478" X-Mailer: WebService/1.1.23040 YMailNorrin Content-Length: 7832 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk ------=_Part_4053670_635903127.1734383960478 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable TeamI am getting the following error. pg_dump: error: error reading large object 2113418: pg_dump: error: could not open large object 3391830:=C2=A0 I tried to give this command DB name =3D abcefg ALTER DATABASE abcefgd SET lo_compat_privileges=3Don; and reran and once again , i am getting the same error while doing using psql/pg_dump from old version server running 13.18 [ OS = =3D Amazon Linux release 2 (Karoo) ]. Will be pg_dump and pg_restore to restore in the new VM with new OS [OS=3D = amazon linux 2023]=C2=A0and new DB bin pgsql ver 15.09. We were told by AWS team, in the new VM tagged OS [OS=3D amazon linux 2023]= =C2=A0, pgsql Ver 13.16 is not supported I cross checkedSELECT oid, count(*)=C2=A0 FROM pg_largeobject_metadata grou= p by oid order by oid ;Rows =3D=C2=A0 4260170 rows Can you suggest On Wednesday, December 11, 2024 at 03:57:31 PM EST, Adrian Klaver wrote: =20 =20 On 12/11/24 11:12, Bharani SV-forum wrote: > Team > As suggested from old server, post shutdown of DB, I did OS level dump=20 > of PG_DATA folder and had restored in the new server. If you follow the process shown here: https://www.postgresql.org/message-id/CAKAnmmKZdhnhdNRd3OgDyEco9OPkT%3DqA_T= eWMFMRvUM9pXauKg%40mail.gmail.com You would not have to do the below. >=20 > Any idea on how to install the older binary postgres 13.18 ( OS=3DAmazon= =20 > Linux 2023.6.20241121) under a dedicated folder suffixed as the=20 > following e.g.) /usr/pgsql1318 >=20 > System Admin had already installed newer version pgsql 15.08 binaries in= =20 > the=C2=A0 new server (OS=3D Amazon Linux 2023.6.20241121) in the folder "= /usr/bin/" >=20 > We were quoted , OS =3D Amazon Linux 2023.6.20241121 doesnot support=20 > postgres ver 15.10 (Community edition) under its AWS-EC2. That does not reflect well on Amazon Linux, that it is missing two=20 critical bug releases. >=20 > Regards >=20 >=20 >=20 --=20 Adrian Klaver adrian.klaver@aklaver.com =20 ------=_Part_4053670_635903127.1734383960478 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
Team
I am getting the following error.

pg_dump: error: error read= ing large object 2113418:

pg_dump: error: could no= t open large object 3391830: 

I tried to give this command DB name =3D abcefg

ALTER DATABASE abcefgd SET lo_compat_p= rivileges=3Don;

and reran a= nd once again , i am getting the same error

while doing using psql/pg_dump f= rom old version server running 13.18 [ OS =3D Amazon Linux release 2 (Karoo) ].

Will be pg_dump and pg_restore to restore in the new VM with= new OS [OS=3D a
We were told by AWS team, in the new VM tagged OS [OS= =3D amazon linux 2023]=  , pgsql Ver 13.16 is not supported

I cross checked
= SELECT oid, count(*)  FROM pg_largeobject_metadata group by oid order = by oid ;
Rows =3D  4260170= rows

Can you suggest
=


=20
------=_Part_4053670_635903127.1734383960478--