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 1u3T4W-00GH94-JH for pgsql-general@arkaria.postgresql.org; Sat, 12 Apr 2025 05:06:29 +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 1u3T4T-001IRz-Vj for pgsql-general@arkaria.postgresql.org; Sat, 12 Apr 2025 05:06:26 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1u3T4T-001IRq-31 for pgsql-general@lists.postgresql.org; Sat, 12 Apr 2025 05:06:25 +0000 Received: from sonic314-21.consmr.mail.sg3.yahoo.com ([106.10.240.145]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1u3T4Q-004Q8O-0G for pgsql-general@postgresql.org; Sat, 12 Apr 2025 05:06:24 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s2048; t=1744434377; bh=hVEIzDqW4XwwsE29srQAUJIeviXDjemSWg7YsT45Vgc=; h=Date:From:Reply-To:To:In-Reply-To:References:Subject:From:Subject:Reply-To; b=cPiZnUent694cmI3PY7ysRARpuIRMXlmQZCYYDezXBEN8ZQFb5DLjPlCDJ7a4W5RQbtojI5XetQXrcnO/TRBTP0DUafK8F+9dED7mtgRrDBjAnGZRakrdE8SeqNzNArlU3gpscw1sVPtUu3wHiDcref8Y7pXDQWNPpA4VGmmb4gUVQp0xji6QxsOeAsdgp/lVhnW93iv3Dy/YXZjdpVTV8OFo4gHSpxjqMfx6QZgHLVXCRsbnQ6H6IMPvp/CGv3vFSWkINMo4CCzYLmHWsX7VTLxT04cfkPDYHO7Ci0NeFzt9dmzCblq8VHZlfibgVRfgbhD+gmNGcBdavRQ1C+z2g== X-SONIC-DKIM-SIGN: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s2048; t=1744434377; bh=piOt0+FYjo0LLa5QtdQyrIbHMMZh3bvxys0fSN660TN=; h=X-Sonic-MF:X-Sonic-MF:Date:From:To:Subject:From:Subject; b=sULihuFim7uHwwieDffEtC00vzLnS4jSD68ejSoaM39J7+J+mLSmsR34odQmUFdcWFMVdz/b2S6eujG8/QycIPOJrg2UNyarNMpJvRYXLNxHu93rcg9ksOg0iTv05GQDowxEvDZqNam7zDmhAbHD5TWrm8qaeS8QWpYnRp4KaW2r8grWv48ynzinRfi9segQa0ie3QNxDTIg6JoG3e+/OBxN6/h3UaKE7PPvQu/lelxmlf8Ve1luT8PRHS5FciiHJXFAA/nfzOkeQCJ3ML+OoLZutDSfbOJimfLhtN6AeVckG1viZ3oQv3CUKuP9VELaoKYSHDWgfI3RmmzWjErV+A== X-YMail-OSG: uPZOCecVM1mlz8FjORicCixf6O630bJgVgHxbV0M9Ofb7fIAV.HRG1bhaeFmMd2 F_Z8PJEboVxYe7LnumG14wngHyDbTzfHMxgCSLZXbtSUizQYuL30t95Ozw0Rpc.DwwPElM05eK2f Pz9ed4N.FxKO5cYR5XLt2zI2biVNfch14xvf2uEAfTF58ebQEyEL5eKtUfp6XofSwrl6zMiAr_qH HGgg4LkkYKvoDU3R8g_6UuuivQxVvJ33h6XI.ghXpXI_UXTUsizQ0BGNDJGc48Cumyg8RZWtwnZL BqwxV.nYhevdfqiBOdyhIslGsI_9u6aObEdVb.7TnfOSQG.Ym.YXr3QvifDwALt8.Krwm_8aafwf nVtM293aY03OcCPAdf7C1syI0HseQ77OQAJhVf4s3PNHYYpjOhaaKCJxf3qe.lp9wjt2jUjRAuTv qqVIcAZhyBpgz6fik8iYNkOQUBHt5Br2K6js0GN2v1BshRzvLvBO3_CpCX2320IO5s25miPe5N.V XzEd1NqlrTEls9d2uuiQpvAiJUds5K2rqiC2WCpu4qKDuU1a1RvYMaA1S0M3kGp0cOLIPCjmKBxI WVQn0JpRtObWtlj9..hHB0XY_DFbpqF5T3mWnQnOe.kDHKFFSUWpNJd_m0tIqjVJzQNwRO2ZEloF Jo3WOwnpwtFwVYIYX_63Uer6yNsLcB_0kGqE_rYNj.WdzVsmwR5Ih9T5xeCa3ImQ33QwvSyZ.0_2 Ro8kGoZl5CXAtKErzKITFONtoiH8AoTUDiuE4DG7C8fvJ5hYJiCMSy4oHkewyqUn8q2cZWHc1pHf xXcEOUvX4NFSmEWztLd.uRJwSQMWk0AJl_12zLfSsFDmugJs34QyFQrFHzNy.UulOtR8fiTogZu7 j72FMzfA101d62C0D0uLIDKZrsIDysuXg7hUywQA1PNCwff4pE47QGvlyOZCP2QB9gliZjWzRJsZ sVUoyDcLY5I5bbjArBt5938NtgPVHAkYQa0tNddkb8bNMqqQCEHh.xptbVccqcWUWJB.Or63dI.p 8eFADN5hBz11YP8FljdXBU8660Aexm8llIMTKtpns_.W9ehvwOWwqVEqSJB18g8AEgeosvX02Z25 gGd5dKxt9kqhNOygzP2BDaGEECScfasCcfWPVXAkFYwEA3CG7LdU.YIjnZey89UNGwsevV5llmI1 xTmxZn_ka6mn1SUXXnaezxJmX8bWZKGjGiZrc5AiiaMKNSeh29aH2nqT29aJvaeami3Btg4d4ZIZ Ztl4jy6Lhna7UtMe6P181cf1BJxdUVHC8arcGCF0jjHtRLywIwZtgdsAFWYrOFR0r5qH37_0FtXV gb8j6ZScHDXi4VvMaJ5KFic0E7S4TyXihRh5lg4DrTOeayquYdwqCWNVpc3CYaBscWKS3XuoiyMi rU1CIP7lLiqd8vQ3K86kYSn9OKHzT_xcykXQg4EXTO_uJDjsf3PdauzJVD4xXc3Wc0PYGi6gIJJd iY1wo4xgIcobygcalI6lQ8Zm4ycQG8E811dT5uSgYj3ijc_ELcCCbwWht.XZz11D6Tttbal1U0Te u9fHxxWnZ1.3l2MGpFFNxlAGmckrS0byuHs52Kk93Y4tt2YlB.g1MS2q9Gga0MswCAMhm_rKbM_2 6mAHlQ4y_4cLWYaeEG41_JB5jk9UuLaaHOU16yT7ndrQtKVAAtjgK56xqmhLk8ufhgFJF7bMYfDl hpciEgX_dA2szB2X1EkO5mhMFt4n4f2r9vw6V9X3sI8rNLTMK57C8X2yEiqPqpSCPwp7rvnXlta7 xR75NpOFmrBzF3Yma8lIGZXy_jn5Cy2W5Khy1YogafSLUdMVHsaq.oqwkNgey2YW60eTRKkoPeD4 8CIz7brbKJ8Gup9QBjaD4Ne5qM9tI6BZMT5d1dryG49hQprv3NZacbNIWzU2OYy0jUoRivX.Z74K uEVsKbizIulJzIBC6.fyP1m4OBNYYR4ZBC2oq_QSciylgIBzEASxuN3RjoMLIUO_QczCC31fIFby oD6uYc1PWoayMEeztSYlcWP8lYLnX.e4PnGqFf062lI7CNZdyTkmIDWa4b1Nd4fmjwyaNkZKd7P7 ylFSGLhn8WuTrRDVJOd_GoZFaO5EZqRLlBAMAs949SKmh6n4KnGRpcD5hDTwAMPmxUfxyAzvR5nI O5IHq1yKP4aIXetkPB_SVKYvRWHQ5dybiNyanKJ1FKcdSrmLJ3EofxKI1Ou4GQtc8HjKGghizF8Q zRXZH8ExQFFbs_QKoJZK1tMt6qRiT1zuU9qIAu7WXHfhH.YPUyGUJVQej_eX9dWg9tkxEfqD7RtH XE64621bwocrD0iC_uwizw1zAXA-- X-Sonic-MF: X-Sonic-ID: ba8341eb-725a-4cb1-b4fd-271c047b4cb0 Received: from sonic.gate.mail.ne1.yahoo.com by sonic314.consmr.mail.sg3.yahoo.com with HTTP; Sat, 12 Apr 2025 05:06:17 +0000 Received: by hermes--production-gq1-74d64bb7d7-clzfg (Yahoo Inc. Hermes SMTP Server) with ESMTPA ID 7f63b847b3452de15c59084e689ab7f2; Sat, 12 Apr 2025 05:06:13 +0000 (UTC) X-YMail-OSG: YJetcFMVM1nb_ACGMTO_O._wenyyU2XPAwDbXGbZCjJewzv3XHKIvBYB.hjgDiY 5DdKkcdfTXDxziLRfvhf_UM00VfPiNk8clorUYMhiiDtqVghr3S82N_rSpl.GWGdna9hhSaMrF5r ZEHh0cdRG1gS87W.sIyJ1LYej.J6UQB_pWSBadw6Zd.IAm3K9cbjY0lIe4W92pjFM_xD8vZrQ0c5 MXkywUy.dp.QWKASQcueC6VJ7aZyV0I_QA5_DWmnbQsqV7wtrOZFoCIUoSJTrSelH9nh_9nm8FSv C0G2N4ushFG8xxUuZp2kpv.Au.7rmO5cpSAkobyqiEJ7o0NNk_.GrJ8y8x6AUkIaOvnTj2YMFmsO WvCBlEy2jP09.JvzgHQPE3nSPgHj2hVySWiWLjJS.ydaJSXc7g.CB0kxVQiUUPolhfaFxPgps0GC SXWkhO9D9hBLB_BPtZAfrAzWtUOJM9.CwaEnbmaHHFsf9TesdkQ1H_ReTZYd_zQGkZIFvFQ2DnT2 YA4rM_qxLLhDuIENoS5Z.xyVCjBsNgOTiQ1iFxRKVptNeRZ3LZweAxZIxAax6it9sylg5kaShDJ_ WWqr5KnlE8uQDiX_3ruHh7M_Ggbe1qUE7iALCffT7KwFGueN5KbIBfnX.wkEUsSdSm9CzwyeFSEE EIYlD2PuUJcGBYQVII4phMYzXaXCRH7QQxK.bLHDbmlI4WwvBMnAWFuCrReVh2Cf3ndW0gi_NCAF pcdzuTS2c10NGeTUH31f4.WKKtbmEMUsr3gmhYRgEIPrnjAXlJbfMM_1Shn22Kc7aB_vSnnWIWJ3 hJcx527MUhzMTBlGNBF5hYu.Bw1mjcZ6vDUunqqZeUz2P6acaXnqVLeR3cDe3RsCH1oER95adZsG mqRMfBq22wAphN6C9jJo7WGJQPzapN7t_QZYMH9KFfMl9JDeEKWrwXH2OEHLVgqooqfnI_LLcFl_ uuW0FM8ueEe34s9CnYxoDYsjJQPxwe6uJfE7TOlxTgYVXl1WsTXYMdbbakzA3kpQ.doGedR6c9AV HBvWmDBhWqRJ63hzW1fjUiBrVCsjMX_uBXO4sW6xeaIp6PjkQUpkeSVImxGygW2diawQaxDBIixg ndUDXvnpaeBFq_7T_8KQbiKgu0LQA5C8Y8ztIickOjEmasbHxK2Pzem80O7rUquhwIiS1.ST0Y8M lvY4Wm5chnbcDQ5h1Wio6kbVt9fsmdUX_Ac4NkryGpVCwkmvimOiCtB3A1tBob19GbhQMis79Ra0 4iF6jw3E8KkfFlEOHNVEbau8jgNr89vrF5UI9P85o58B3MAi0byc4roPUej_zP8WFWK5XnnZ0XfN UFRDxGAIDoVtChI9L4XgWxT3w3zdAmBOxYV4V.0j501ai2w_ymLniLgmUB1Ms64AoLdKVBgUItl7 nNglN2p6qMFdUP0ZrgE2ESOkEMdvJ5se8Y0mO8xPGKBgpfCnNA30yBTz4ok_UenB.YRZqVnTr8Qy 6OXhn3XHI1DA69YRv7zyJcwBuHaDMvBKPlCzPswj1Lvds4gqiKLl8jzn6uul2iwwcH39uSk6Lrkg xgA.oiRXxz8GopTmGjeR2jj3FKKSAFSaX6.eKYOnwbVDPJ_lxkFdlzIOKkVkL7h2bhAVhS6Bnvbd 4H22WLa3G84wM1KlDLWZYVszSDeTlQJZTqmdnVKUTznpIrpzybAKzBMQHwEVkJ_BqW4vYUSisn5r A4ERDXPil94Uh0NM.mewJXXjYlQRoaODv.Bsi7N9H8WrpViLwbT.GwvEtovr5pt_lfyFSzmwg9uv CxDgPhmtZw.EUQSFYvf8RhdvB_8_hI1W7M0eZ2OZLVFcaGpaLjJYEZ1iyZScYGXaJr4EYTCW9gT4 98Dw1cDocyIZfR9ddt5_OmKfJcdfoxRs9eZT.hJmA7KM2vVMSnj21CBjPEfmdXQe7gzQ0Us3s6Sr _y3QCJaZCVE7h1oph9mJDdBnckZ3hzgeGxGVRT3qZYG_JzsQ5t6xnYQeD8_QJ0j8upvMwyzi4L8l Mx_VjnKhpwKHFaRVrONOnu72yLL24tlp9kDwKhv4ZlLbUnnuV.ld881MfK5CX5l2z0y9zz81UXxI IJHu00BDh0j.MHR5o.VOxaQaPOsWBGNC5P2lHsAw8RUQt7WmHcBFu2LR49bLf4B.cVetq9AZvWHs LUod7HO1IgbDJM1Ya_1V4ERQ0Nat7tVdpbYWYhT7idBGQBFY0zeuj13JcaaExppO3_7vWn0PnvLf REXDHtqYMMarV5Sdo6qC859tuFHeWqR_C3gCjTIsbU8fJvsIv7mTZrOGdRjsg91SY6EztoH9_kA3 KlCZPQ8QJW4PYPPlz4iveSxKH3Z44W49RtEToZOMzSwW4KZKTM.RFauv1zeN08d2u_wuxsCSIyov y6Dr0 X-Sonic-MF: X-Sonic-ID: c8d9db9f-3b18-4078-bc16-dda90ce1f1a7 Received: from sonic.gate.mail.ne1.yahoo.com by sonic310.consmr.mail.gq1.yahoo.com with HTTP; Sat, 12 Apr 2025 05:06:11 +0000 Date: Sat, 12 Apr 2025 05:06:09 +0000 (UTC) From: "sivapostgres@yahoo.com" Reply-To: "sivapostgres@yahoo.com" To: Pgsql-general , Adrian Klaver Message-ID: <1494046583.828048.1744434369825@mail.yahoo.com> In-Reply-To: <40a86c92-5fc9-447d-969e-2a61cc98629c@aklaver.com> References: <1477036526.178965.1744376140698.ref@mail.yahoo.com> <1477036526.178965.1744376140698@mail.yahoo.com> <40a86c92-5fc9-447d-969e-2a61cc98629c@aklaver.com> Subject: Re: To take backup of Postgresql Database without large objects MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_828047_897517500.1744434369823" X-Mailer: WebService/1.1.23665 YMailNorrin Content-Length: 9964 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk ------=_Part_828047_897517500.1744434369823 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable I tried all the combinations, as mentioned in the documenthttps://www.post= gresql.org/docs/current/app-pgdump.html "E:\DBBackup\bin\pg_dump.exe" -h 192.168.1.1 -p 5432 -U --no-blo= bs -F c -v -f "E:\DBBackup\demo6_110420251637.bak" demo6=C2=A0 "E:\DBBackup\bin\pg_dump.exe" -h 192.168.1.1 -p 5432 -U -B -F c = -v -f "E:\DBBackup\demo6_110420251637.bak" demo6=C2=A0 "E:\DBBackup\bin\pg_dump.exe" -h 192.168.1.1 -p 5432 -U -B --no-= blobs -F c -v -f "E:\DBBackup\demo6_110420251637.bak" demo6=C2=A0 With version 15--no-large-objects=C2=A0 is not working.I tried with all the= other combinations.=C2=A0 NO LUCK. bytea field also included in the backup.=C2=A0 =C2=A0 I tried taking backup using pg_dump of version 17 also, with no luck.=C2=A0= =C2=A0[ Database version is 15 and the pg_dump version is 17 ].=C2=A0 Confirming this after restoring the backup file in a new database.=C2=A0 = =C2=A0The new database contains contents from bytea field also.=C2=A0=C2=A0 Either my command should be wrong or I'm missing something.=C2=A0=C2=A0 Happiness Always BKR Sivaprakash On Friday 11 April, 2025 at 08:31:31 pm IST, Adrian Klaver wrote: =20 =20 On 4/11/25 05:55, sivapostgres@yahoo.com wrote: > Hello, >=20 > Using PostgreSQL 15.1, compiled by Visual C++ build 1914, 64-bit in=20 > Windows 10. >=20 > Trying to take backup of a database, using pg_dump, where one table=20 > contains bytea datatype, which I don't want to include in the backup. >=20 > My command was: > "E:\DBBackup\bin\pg_dump.exe"=C2=A0 -h 192.168.1.1 -p 5432 -U = =20 > --no-blobs -F c -v -f "E:\DBBackup\demo6_110420251637.bak" demo6 >=20 > the backup includes the bytea field also. >=20 > I tried with > "E:\DBBackup\bin\pg_dump.exe"=C2=A0 -h 192.168.1.1 -p 5432 -U = -B=20 > -F c -v -f "E:\DBBackup\demo6_110420251637.bak" demo6 >=20 > also, which also included the bytea field. 1) Short version Short version bytea fields !=3D large objects. 2) Long version From here: https://www.postgresql.org/docs/current/app-pgdump.html -B --no-large-objects --no-blobs (deprecated) =C2=A0 =C2=A0 Exclude large objects in the dump. =C2=A0 =C2=A0 When both -b and -B are given, the behavior is to output larg= e=20 objects, when data is being dumped, see the -b documentation. Where large objects are defined here: https://www.postgresql.org/docs/current/largeobjects.html >=20 > What wrong I'm doing?=C2=A0 Couldn't figure it out.=C2=A0 =C2=A0Any help = is appreciated. >=20 > Happiness Always > BKR Sivaprakash >=20 --=20 Adrian Klaver adrian.klaver@aklaver.com =20 ------=_Part_828047_897517500.1744434369823 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
I tried all the combinations= , as mentioned in the document

=
"E:\DBBackup\bin\pg_dump.exe" -h 192.168.1.1 -p 5432= -U <username> --no-blobs -F c -v -f "E:\DBBackup\demo6_110420251637.= bak" demo6 

"E:\DB= Backup\bin\pg_dump.exe" -h 192.168.1.1 -p 5432 -U <username> -B -F c = -v -f "E:\DBBackup\demo6_110420251637.bak" demo6 

"E:\DBBackup\bin\pg_dump.exe" -h 192.168.1.1 -p 5432 -U <use= rname> -B --no-blobs -F c -v -f "E:\DBBackup\demo6_110420251637.bak" dem= o6 

With version = 15
--no-large-objects  is = not working.
I tried with all t= he other combinations.  NO LUCK.

bytea field also in= cluded in the backup.   

I tried taking backup = using pg_dump of version 17 also, with no luck.   [ Database vers= ion is 15 and the pg_dump version is 17 ]. 

=
Confirming this after restoring the = backup file in a new database.   The new database contains conten= ts from bytea field also.  

Either my command s= hould be wrong or I'm missing something.  

Happ= iness Always
BKR Sivaprakash

=20
=20
On Friday 11 April, 2025 at 08:31:31 pm IST, Adrian= Klaver <adrian.klaver@aklaver.com> wrote:


=20 =20
On 4/11/25 05:55, sivapostgres@yahoo.com wrote:
> Hello,
>
> Using PostgreSQL 15.1, compiled by= Visual C++ build 1914, 64-bit in
> Windows 10.
>
> Trying to take backup of a databa= se, using pg_dump, where one table
> contains bytea d= atatype, which I don't want to include in the backup.
>= ;
> My command was:
> "E:\DBBack= up\bin\pg_dump.exe"  -h 192.168.1.1 -p 5432 -U <username>
> --no-blobs -F c -v -f "E:\DBBackup\demo6_110420251637.bak= " demo6
>
> the backup includes = the bytea field also.
>
> I trie= d with
> "E:\DBBackup\bin\pg_dump.exe"  -h 192.16= 8.1.1 -p 5432 -U <username> -B
> -F c -v -f "E:= \DBBackup\demo6_110420251637.bak" demo6
>
> also, which also included the bytea field.
1) Short version

Shor= t version bytea fields !=3D large objects.

2) Long version

From here:

https://www.postg= resql.org/docs/current/app-pgdump.html

-B
--no-large-objects
--no-blobs (= deprecated)

    Exclude lar= ge objects in the dump.

    = When both -b and -B are given, the behavior is to output large
objects, when data is being dumped, see the -b documentation.

Where large objects are defined here:

https://www.p= ostgresql.org/docs/current/largeobjects.html





>
> What w= rong I'm doing?  Couldn't figure it out.   Any help is appre= ciated.
>
> Happiness Always
> BKR Sivaprakash

>

--
Adrian Klaver
adrian.klaver@aklaver.com




------=_Part_828047_897517500.1744434369823--