Re: To take backup of Postgresql Database without large objects

From: "sivapostgres(at)yahoo(dot)com" <sivapostgres(at)yahoo(dot)com>
To: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
Cc: Pgsql-general <pgsql-general(at)postgresql(dot)org>, Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
Subject: Re: To take backup of Postgresql Database without large objects
Date: 2025-04-12 05:34:52
Message-ID: 312140824.825355.1744436092713@mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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(dot)g(dot)johnston(at)gmail(dot)com> wrote:

On Friday, April 11, 2025, sivapostgres(at)yahoo(dot)com <sivapostgres(at)yahoo(dot)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.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Christophe Pettus 2025-04-12 05:37:19 Re: To take backup of Postgresql Database without large objects
Previous Message David G. Johnston 2025-04-12 05:14:00 Re: To take backup of Postgresql Database without large objects