public inbox for [email protected]help / color / mirror / Atom feed
Re: To take backup of Postgresql Database without large objects 3+ messages / 3 participants [nested] [flat]
* Re: To take backup of Postgresql Database without large objects @ 2025-04-12 05:14 David G. Johnston <[email protected]> 0 siblings, 1 reply; 3+ messages in thread From: David G. Johnston @ 2025-04-12 05:14 UTC (permalink / raw) To: [email protected] <[email protected]>; +Cc: pgsql-general; Adrian Klaver <[email protected]> On Friday, April 11, 2025, [email protected] <[email protected]> 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. ^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: To take backup of Postgresql Database without large objects @ 2025-04-12 05:34 [email protected] <[email protected]> parent: David G. Johnston <[email protected]> 0 siblings, 1 reply; 3+ messages in thread From: [email protected] @ 2025-04-12 05:34 UTC (permalink / raw) To: David G. Johnston <[email protected]>; +Cc: pgsql-general; Adrian Klaver <[email protected]> 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 <[email protected]> wrote: On Friday, April 11, 2025, [email protected] <[email protected]> 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. ^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: To take backup of Postgresql Database without large objects @ 2025-04-12 05:37 Christophe Pettus <[email protected]> parent: [email protected] <[email protected]> 0 siblings, 0 replies; 3+ messages in thread From: Christophe Pettus @ 2025-04-12 05:37 UTC (permalink / raw) To: [email protected] <[email protected]>; +Cc: David G. Johnston <[email protected]>; pgsql-general; Adrian Klaver <[email protected]> > On Apr 11, 2025, at 22:34, [email protected] wrote: > Then I've misunderstood large objects. Is there document to explain large objects? Large objects are a relatively old and now little-used feature of PostgreSQL that predates the bytea type: https://www.postgresql.org/docs/current/largeobjects.html As was mentioned, you cannot exclude individual columns with pg_dump; you have to exclude the entire table. ^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2025-04-12 05:37 UTC | newest] Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2025-04-12 05:14 Re: To take backup of Postgresql Database without large objects David G. Johnston <[email protected]> 2025-04-12 05:34 ` [email protected] <[email protected]> 2025-04-12 05:37 ` Christophe Pettus <[email protected]>
This inbox is served by agora; see mirroring instructions for how to clone and mirror all data and code used for this inbox