Date: Sat, 12 Apr 2025 05:34:52 +0000 (UTC)
From: "sivapostgres@yahoo.com" <sivapostgres@yahoo.com>
Reply-To: "sivapostgres@yahoo.com" <sivapostgres@yahoo.com>
To: "David G. Johnston" <david.g.johnston@gmail.com>
Cc: Pgsql-general <pgsql-general@postgresql.org>, 
	Adrian Klaver <adrian.klaver@aklaver.com>
Message-ID: <312140824.825355.1744436092713@mail.yahoo.com>
In-Reply-To: <CAKFQuwb+b3syAE=GSNT7hDySyCc=k98mn+EkeUs73O-dFcrcwA@mail.gmail.com>
References: <1477036526.178965.1744376140698.ref@mail.yahoo.com> <1477036526.178965.1744376140698@mail.yahoo.com> <40a86c92-5fc9-447d-969e-2a61cc98629c@aklaver.com> <1494046583.828048.1744434369825@mail.yahoo.com> <CAKFQuwb+b3syAE=GSNT7hDySyCc=k98mn+EkeUs73O-dFcrcwA@mail.gmail.com>
Subject: Re: To take backup of Postgresql Database without large objects
MIME-Version: 1.0
Content-Type: multipart/alternative; 
	boundary="----=_Part_825354_1644818569.1744436092712"
Content-Length: 3323
Archived-At: <https://www.postgresql.org/message-id/312140824.825355.1744436092713%40mail.yahoo.com>
Precedence: bulk

------=_Part_825354_1644818569.1744436092712
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

 Thanks.Then I've misunderstood large objects.=C2=A0 Is there document to e=
xplain large objects?=C2=A0=C2=A0We store images in bytea column.
Happiness Always
BKR Sivaprakash
    On Saturday 12 April, 2025 at 10:44:21 am IST, David G. Johnston <david=
.g.johnston@gmail.com> wrote: =20
=20
 On Friday, April 11, 2025, sivapostgres@yahoo.com <sivapostgres@yahoo.com>=
 wrote:

bytea field also included in the backup.=C2=A0 =C2=A0

Bytea typed columns are completely separate things than large objects.=C2=
=A0 You cannot exclude individual columns using pg_dump.
David J.
 =20
------=_Part_825354_1644818569.1744436092712
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

<html><head></head><body><div class=3D"ydpc3b9fb43yahoo-style-wrap" style=
=3D"font-family:times new roman, new york, times, serif;font-size:16px;"><d=
iv></div>
        <div dir=3D"ltr" data-setdir=3D"false">Thanks.</div><div dir=3D"ltr=
" data-setdir=3D"false">Then I've misunderstood large objects.&nbsp; Is the=
re document to explain large objects?&nbsp;&nbsp;</div><div dir=3D"ltr" dat=
a-setdir=3D"false">We store images in bytea column.</div><div dir=3D"ltr" d=
ata-setdir=3D"false"><br></div><div dir=3D"ltr" data-setdir=3D"false">Happi=
ness Always<br>BKR Sivaprakash</div><div><br></div>
       =20
        </div><div id=3D"yahoo_quoted_5373236600" class=3D"yahoo_quoted">
            <div style=3D"font-family:'Helvetica Neue', Helvetica, Arial, s=
ans-serif;font-size:13px;color:#26282a;">
               =20
                <div>
                        On Saturday 12 April, 2025 at 10:44:21 am IST, Davi=
d G. Johnston &lt;david.g.johnston@gmail.com&gt; wrote:
                    </div>
                    <div><br></div>
                    <div><br></div>
               =20
               =20
                <div><div id=3D"yiv1696082608"><div>On Friday, April 11, 20=
25, <a rel=3D"nofollow noopener noreferrer" shape=3D"rect" ymailto=3D"mailt=
o:sivapostgres@yahoo.com" target=3D"_blank" href=3D"mailto:sivapostgres@yah=
oo.com">sivapostgres@yahoo.com</a> &lt;<a rel=3D"nofollow noopener noreferr=
er" shape=3D"rect" ymailto=3D"mailto:sivapostgres@yahoo.com" target=3D"_bla=
nk" href=3D"mailto:sivapostgres@yahoo.com">sivapostgres@yahoo.com</a>&gt; w=
rote:<blockquote style=3D"margin:0 0 0 .8ex;border-left:1px #ccc solid;padd=
ing-left:1ex;" class=3D"yiv1696082608gmail_quote"><div id=3D"yiv1696082608y=
qtfd13873" class=3D"yiv1696082608yqt6217380799"><div style=3D"font-family:t=
imes new roman, new york, times, serif;font-size:16px;"><div dir=3D"ltr"><d=
iv dir=3D"ltr"><br clear=3D"none"></div><div dir=3D"ltr">bytea field also i=
ncluded in the backup.&nbsp; &nbsp;</div></div></div></div></blockquote><di=
v><br clear=3D"none"></div><div>Bytea typed columns are completely separate=
 things than large objects.&nbsp; You cannot exclude individual columns usi=
ng pg_dump.</div><div><br clear=3D"none"></div><div>David J.</div><div id=
=3D"yiv1696082608yqtfd57183" class=3D"yiv1696082608yqt6217380799"><div><br =
clear=3D"none"></div>
</div></div></div></div>
            </div>
        </div></body></html>
------=_Part_825354_1644818569.1744436092712--