public inbox for pgsql-docs@postgresql.org
help / color / mirror / Atom feedFrom: Radoulov, Dimitre <cichomitiko@gmail.com>
To: Laurenz Albe <laurenz.albe@cybertec.at>
Cc: pgsql-docs@lists.postgresql.org
Subject: Re: Documentation clarification request: pg_dumpall and Large Objects
Date: Sat, 28 Feb 2026 10:45:40 +0100
Message-ID: <CAGJBphS8s=foA8nqtdCc_h5J5S7M91-jhgf1ATrd-jU1ov-58g@mail.gmail.com> (raw)
In-Reply-To: <ae61f593b83ef62e5737c205a04498ea281b8a02.camel@cybertec.at>
References: <CAGJBphSX2oMPPu=VM4U8NP4+qffFH_483tFQCJ_s-mOcN3DLDw@mail.gmail.com>
<d4ab85597252c7a529f64ffd5cc5b09d92504df4.camel@cybertec.at>
<CAGJBphS4TLNvAyNcWj_NSfer9SoDzco35apkT+8-wqXCthSK6w@mail.gmail.com>
<b8358ac2148b9daf30c27b50a8cb9c8f2c4e40f9.camel@cybertec.at>
<ae61f593b83ef62e5737c205a04498ea281b8a02.camel@cybertec.at>
Il Ven 27 Feb 2026, 23:23 Laurenz Albe <laurenz.albe@cybertec.at> ha
scritto:
> On Thu, 2025-12-04 at 19:11 +0100, Laurenz Albe wrote:
> > On Thu, 2025-12-04 at 18:12 +0100, Radoulov, Dimitre wrote:
> > > Il Gio 4 Dic 2025, 16:50 Laurenz Albe <laurenz.albe@cybertec.at> ha
> scritto:
> > > > On Thu, 2025-12-04 at 13:12 +0100, Radoulov, Dimitre wrote:
> > > > > I would like to request a clarification in the pg_dumpall
> > > > > documentation regarding Large Objects (LOBs). The current
> > > > > documentation does not explicitly state whether pg_dumpall includes
> > > > > Large Objects in its output.
> > > >
> > > > I admit that you have to go by circumstantial evidence here. But
> rather
> > > > than explicitly naming large objects, perhaps it would be useful to
> add something
> > > > like
> > > >
> > > > pg_dumpall is primarily intended as a tool to upgrade database
> clusters.
> > > > As such, it by default exports all data of the entire cluster.
> > > > The only part of the state of a database cluster that is *not*
> included
> > > > in the output of pg_dumpall are the configuration files and
> database parameters
> > > > changed with ALTER SYSTEM.
> >
> > Attached is a patch for such a change.
>
> Commit 763aaa06f0 has changed the situation: with the addition of other
> formats
> than the plain format, it no longer makes sense to say that pg_dumpall
> is not useful for backup. Still, we should clarify what is *not* included.
>
> The attached patch does that and in passing improves the readability.
>
Thank you for the update.
Best regards
Dimitre
>
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-docs@postgresql.org
Cc: cichomitiko@gmail.com, laurenz.albe@cybertec.at, pgsql-docs@lists.postgresql.org
Subject: Re: Documentation clarification request: pg_dumpall and Large Objects
In-Reply-To: <CAGJBphS8s=foA8nqtdCc_h5J5S7M91-jhgf1ATrd-jU1ov-58g@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox