public inbox for [email protected]
help / color / mirror / Atom feedRe: 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]>
2025-04-12 05:34 ` Re: To take backup of Postgresql Database without large objects [email protected] <[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: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 ` Re: To take backup of Postgresql Database without large objects Christophe Pettus <[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:14 Re: To take backup of Postgresql Database without large objects David G. Johnston <[email protected]>
2025-04-12 05:34 ` Re: To take backup of Postgresql Database without large objects [email protected] <[email protected]>
@ 2025-04-12 05:37 ` Christophe Pettus <[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