On 4/11/25 22:06, sivapostg...@yahoo.com wrote:

Either my command should be wrong or I'm missing something.

This was explained in my post as  quoted below.


Happiness Always
BKR Sivaprakash

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


On 4/11/25 05:55, sivapostg...@yahoo.com <mailto:sivapostg...@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 database, using pg_dump, where one table
 > contains bytea datatype, which I don't want to include in the backup.
 >
 > My command was:
 > "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
 >
 > the backup includes the bytea field also.
 >
 > I tried with
 > "E:\DBBackup\bin\pg_dump.exe"  -h 192.168.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

Short version bytea fields != large objects.

2) Long version

 From here:

https://www.postgresql.org/docs/current/app-pgdump.html <https://www.postgresql.org/docs/current/app-pgdump.html>

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

     Exclude large 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.postgresql.org/docs/current/largeobjects.html <https://www.postgresql.org/docs/current/largeobjects.html>





 >
 > What wrong I'm doing?  Couldn't figure it out.   Any help is appreciated.
 >
 > Happiness Always
 > BKR Sivaprakash

 >

--
Adrian Klaver
adrian.kla...@aklaver.com <mailto:adrian.kla...@aklaver.com>





--
Adrian Klaver
adrian.kla...@aklaver.com



Reply via email to