Date: Fri, 11 Apr 2025 12:55:40 +0000 (UTC)
From: "sivapostgres@yahoo.com" <sivapostgres@yahoo.com>
Reply-To: "sivapostgres@yahoo.com" <sivapostgres@yahoo.com>
To: Pgsql-general <pgsql-general@postgresql.org>
Message-ID: <1477036526.178965.1744376140698@mail.yahoo.com>
Subject: Re: To take backup of Postgresql Database without large objects
MIME-Version: 1.0
Content-Type: multipart/alternative; 
	boundary="----=_Part_178964_330714853.1744376140697"
References: <1477036526.178965.1744376140698.ref@mail.yahoo.com>
Content-Length: 3157
Archived-At: <https://www.postgresql.org/message-id/1477036526.178965.1744376140698%40mail.yahoo.com>
Precedence: bulk

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

Hello,
Using=C2=A0PostgreSQL 15.1, compiled by Visual C++ build 1914, 64-bit in Wi=
ndows 10.
Trying to take backup of a database, using pg_dump, where one table contain=
s bytea datatype, which I don't want to include in the backup.
My command was:"E:\DBBackup\bin\pg_dump.exe"=C2=A0 -h 192.168.1.1 -p 5432 -=
U <username> --no-blobs -F c -v -f "E:\DBBackup\demo6_110420251637.bak" dem=
o6=C2=A0

the backup includes the bytea field also.=C2=A0=C2=A0
I tried with=C2=A0"E:\DBBackup\bin\pg_dump.exe"=C2=A0 -h 192.168.1.1 -p 543=
2 -U <username> -B -F c -v -f "E:\DBBackup\demo6_110420251637.bak" demo6=C2=
=A0

also, which also included the bytea field.
What wrong I'm doing?=C2=A0 Couldn't figure it out.=C2=A0 =C2=A0Any help is=
 appreciated.
Happiness Always
BKR Sivaprakash

------=_Part_178964_330714853.1744376140697
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

<html><head></head><body><div class=3D"yahoo-style-wrap" style=3D"font-fami=
ly:times new roman, new york, times, serif;font-size:16px;"><div dir=3D"ltr=
" data-setdir=3D"false">Hello,</div><div dir=3D"ltr" data-setdir=3D"false">=
<br></div><div dir=3D"ltr" data-setdir=3D"false">Using&nbsp;<span>PostgreSQ=
L 15.1, compiled by Visual C++ build 1914, 64-bit in Windows 10.</span></di=
v><div dir=3D"ltr" data-setdir=3D"false"><span><br></span></div><div dir=3D=
"ltr" data-setdir=3D"false">Trying to take backup of a database, using pg_d=
ump, where one table contains bytea datatype, which I don't want to include=
 in the backup.</div><div dir=3D"ltr" data-setdir=3D"false"><br></div><div =
dir=3D"ltr" data-setdir=3D"false">My command was:</div><div dir=3D"ltr" dat=
a-setdir=3D"false"><span>"E:\DBBackup\bin\pg_dump.exe"&nbsp; -h 192.168.1.1=
 -p 5432 -U &lt;username&gt; --no-blobs -F c -v -f "E:\DBBackup\demo6_11042=
0251637.bak" demo6&nbsp;</span><br></div><div dir=3D"ltr" data-setdir=3D"fa=
lse"><span><br></span></div><div dir=3D"ltr" data-setdir=3D"false">the back=
up includes the bytea field also.&nbsp;&nbsp;</div><div dir=3D"ltr" data-se=
tdir=3D"false"><br></div><div dir=3D"ltr" data-setdir=3D"false">I tried wit=
h&nbsp;</div><div dir=3D"ltr" data-setdir=3D"false"><div><div dir=3D"ltr" d=
ata-setdir=3D"false" style=3D"color: rgb(0, 0, 0); font-family: &quot;times=
 new roman&quot;, &quot;new york&quot;, times, serif; font-size: 16px;">"E:=
\DBBackup\bin\pg_dump.exe"&nbsp; -h 192.168.1.1 -p 5432 -U &lt;username&gt;=
 -B -F c -v -f "E:\DBBackup\demo6_110420251637.bak" demo6&nbsp;<br></div><d=
iv><br></div></div>also, which also included the bytea field.</div><div dir=
=3D"ltr" data-setdir=3D"false"><br></div><div dir=3D"ltr" data-setdir=3D"fa=
lse">What wrong I'm doing?&nbsp; Couldn't figure it out.&nbsp; &nbsp;Any he=
lp is appreciated.</div><div dir=3D"ltr" data-setdir=3D"false"><br></div><d=
iv dir=3D"ltr" data-setdir=3D"false">Happiness Always<br>BKR Sivaprakash</d=
iv><div dir=3D"ltr" data-setdir=3D"false"><br></div></div></body></html>
------=_Part_178964_330714853.1744376140697--