Postgres Pro
Downloads
Home   >   mailing lists

Re: To take backup of Postgresql Database without large objects - Mailing list pgsql-general

From sivapostgres@yahoo.com
Subject Re: To take backup of Postgresql Database without large objects
Date
Msg-id 312140824.825355.1744436092713@mail.yahoo.com
Whole thread Raw
In response to Re: To take backup of Postgresql Database without large objects  ("David G. Johnston" <david.g.johnston@gmail.com>)
Responses Re: To take backup of Postgresql Database without large objects
List pgsql-general
Tree view
Thanks.
Then I've misunderstood large objects.  Is there document to explain large objects?  
We 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:


On Friday, April 11, 2025, sivapostgres@yahoo.com <sivapostgres@yahoo.com> wrote:

bytea field also included in the backup.   

Bytea typed columns are completely separate things than large objects.  You cannot exclude individual columns using pg_dump.

David J.

pgsql-general by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: To take backup of Postgresql Database without large objects
Next
From: Christophe Pettus
Date:
Subject: Re: To take backup of Postgresql Database without large objects