Message-ID: <b8358ac2148b9daf30c27b50a8cb9c8f2c4e40f9.camel@cybertec.at>
Subject: Re: Documentation clarification request: pg_dumpall and Large
 Objects
From: Laurenz Albe <laurenz.albe@cybertec.at>
To: "Radoulov, Dimitre" <cichomitiko@gmail.com>
Cc: pgsql-docs@lists.postgresql.org
Date: Thu, 04 Dec 2025 19:11:44 +0100
In-Reply-To: 
 <CAGJBphS4TLNvAyNcWj_NSfer9SoDzco35apkT+8-wqXCthSK6w@mail.gmail.com>
References: 
	<CAGJBphSX2oMPPu=VM4U8NP4+qffFH_483tFQCJ_s-mOcN3DLDw@mail.gmail.com>
	 <d4ab85597252c7a529f64ffd5cc5b09d92504df4.camel@cybertec.at>
	 <CAGJBphS4TLNvAyNcWj_NSfer9SoDzco35apkT+8-wqXCthSK6w@mail.gmail.com>
Content-Type: multipart/mixed; boundary="=-W/qdg/b9foHYsTg/DJ0m"
User-Agent: Evolution 3.56.2 (3.56.2-2.fc42) 
MIME-Version: 1.0
Archived-At: 
 <https://www.postgresql.org/message-id/b8358ac2148b9daf30c27b50a8cb9c8f2c4e40f9.camel%40cybertec.at>
Precedence: bulk

--=-W/qdg/b9foHYsTg/DJ0m
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

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 scrit=
to:
> > 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.
> >=20
> > I admit that you have to go by circumstantial evidence here.=C2=A0 But =
rather
> > than explicitly naming large objects, perhaps it would be useful to add=
 something
> > like
> >=20
> > =C2=A0 pg_dumpall is primarily intended as a tool to upgrade database c=
lusters.
> > =C2=A0 As such, it by default exports all data of the entire cluster.
> > =C2=A0 The only part of the state of a database cluster that is *not* i=
ncluded
> > =C2=A0 in the output of pg_dumpall are the configuration files and data=
base parameters
> > =C2=A0 changed with ALTER SYSTEM.
>=20
> Thank you again for your time and for considering the suggestion.

Attached is a patch for such a change.

I'll add it to the next commitfest.

Yours,
Laurenz Albe

--=-W/qdg/b9foHYsTg/DJ0m
Content-Disposition: attachment;
	filename="v1-0001-pg_dumpall-doc-clarify-scope-and-suggested-use.patch"
Content-Transfer-Encoding: base64
Content-Type: text/x-patch;
	name="v1-0001-pg_dumpall-doc-clarify-scope-and-suggested-use.patch";
	charset="UTF-8"

RnJvbSA4ODY3YTY0ZjRkMGM2YzUzMGJjMDAxYjhkYjczODAyZjI1Mjg0ZDE1IE1vbiBTZXAgMTcg
MDA6MDA6MDAgMjAwMQpGcm9tOiBMYXVyZW56IEFsYmUgPGxhdXJlbnouYWxiZUBjeWJlcnRlYy5h
dD4KRGF0ZTogVGh1LCA0IERlYyAyMDI1IDE5OjA5OjE3ICswMTAwClN1YmplY3Q6IFtQQVRDSCB2
MV0gcGdfZHVtcGFsbCBkb2M6IGNsYXJpZnkgc2NvcGUgYW5kIHN1Z2dlc3RlZCB1c2UKCkFkZCBh
IHBhcmFncmFwaCB0aGF0IGNsYXJpZmllcyB0aGF0IHBnX2R1bXBhbGwgaXMgbW9zdGx5IGFuIHVw
Z3JhZGUKdG9vbCBhbmQgZGVzY3JpYmVzIHRoZSBwYXJ0cyBvZiBhIGNsdXN0ZXIncyBzdGF0ZSB0
aGF0IGFyZSAqbm90KgppbmNsdWRlZCBpbiB0aGUgZHVtcC4KCkluIHRoZSBzcGlyaXQgb2YgYWRk
ZWQgY2xhcml0eSwgc3dhcCB0d28gc2VudGVuY2VzIGluIHRoZSBpbnRyb2R1Y3RvcnkKcGFyYWdy
YXBoLiAgV2l0aG91dCB0aGF0LCBpdCBpcyBub3QgY2xlYXIgd2hhdCB0aGUgIml0IiBhdCB0aGUg
YmVnaW5uaW5nCm9mIHRoZSBzZWNvbmQgc2VudGVuY2UgaXMgcmVmZXJyaW5nIHRvLgoKQXV0aG9y
OiBMYXVyZW56IEFsYmUgPGxhdXJlbnouYWxiZUBjeWJlcnRlYy5hdD4KRGlzY3Vzc2lvbjogaHR0
cHM6Ly9wb3N0Z3IuZXMvbS9DQUdKQnBoU1gyb01QUHUlM0RWTTRVOE5QNCUyQnFmZkZIXzQ4M3RG
UUNKX3MtbU9jTjNETER3JTQwbWFpbC5nbWFpbC5jb20KLS0tCiBkb2Mvc3JjL3NnbWwvcmVmL3Bn
X2R1bXBhbGwuc2dtbCB8IDE3ICsrKysrKysrKysrKystLS0tCiAxIGZpbGUgY2hhbmdlZCwgMTMg
aW5zZXJ0aW9ucygrKSwgNCBkZWxldGlvbnMoLSkKCmRpZmYgLS1naXQgYS9kb2Mvc3JjL3NnbWwv
cmVmL3BnX2R1bXBhbGwuc2dtbCBiL2RvYy9zcmMvc2dtbC9yZWYvcGdfZHVtcGFsbC5zZ21sCmlu
ZGV4IDg4MzRiN2VjMTQxLi5mNDZmMmU3MGI3ZiAxMDA2NDQKLS0tIGEvZG9jL3NyYy9zZ21sL3Jl
Zi9wZ19kdW1wYWxsLnNnbWwKKysrIGIvZG9jL3NyYy9zZ21sL3JlZi9wZ19kdW1wYWxsLnNnbWwK
QEAgLTMzLDE2ICszMywyNSBAQCBQb3N0Z3JlU1FMIGRvY3VtZW50YXRpb24KICAgPHBhcmE+CiAg
ICA8YXBwbGljYXRpb24+cGdfZHVtcGFsbDwvYXBwbGljYXRpb24+IGlzIGEgdXRpbGl0eSBmb3Ig
d3JpdGluZyBvdXQKICAgICg8cXVvdGU+ZHVtcGluZzwvcXVvdGU+KSBhbGwgPHByb2R1Y3RuYW1l
PlBvc3RncmVTUUw8L3Byb2R1Y3RuYW1lPiBkYXRhYmFzZXMKLSAgIG9mIGEgY2x1c3RlciBpbnRv
IG9uZSBzY3JpcHQgZmlsZS4gIFRoZSBzY3JpcHQgZmlsZSBjb250YWlucwotICAgPGFjcm9ueW0+
U1FMPC9hY3JvbnltPiBjb21tYW5kcyB0aGF0IGNhbiBiZSB1c2VkIGFzIGlucHV0IHRvIDx4cmVm
Ci0gICBsaW5rZW5kPSJhcHAtcHNxbCIvPiB0byByZXN0b3JlIHRoZSBkYXRhYmFzZXMuICBJdCBk
b2VzIHRoaXMgYnkKLSAgIGNhbGxpbmcgPHhyZWYgbGlua2VuZD0iYXBwLXBnZHVtcCIvPiBmb3Ig
ZWFjaCBkYXRhYmFzZSBpbiB0aGUgY2x1c3Rlci4KKyAgIG9mIGEgY2x1c3RlciBpbnRvIG9uZSBz
Y3JpcHQgZmlsZS4gIEl0IGRvZXMgdGhpcyBieSBjYWxsaW5nCisgICA8eHJlZiBsaW5rZW5kPSJh
cHAtcGdkdW1wIi8+IGZvciBlYWNoIGRhdGFiYXNlIGluIHRoZSBjbHVzdGVyLgorICAgVGhlIHJl
c3VsdGluZyBzY3JpcHQgZmlsZSBjb250YWlucyA8YWNyb255bT5TUUw8L2Fjcm9ueW0+IGNvbW1h
bmRzIHRoYXQKKyAgIGNhbiBiZSB1c2VkIGFzIGlucHV0IHRvIDx4cmVmIGxpbmtlbmQ9ImFwcC1w
c3FsIi8+IHRvIHJlc3RvcmUgdGhlIGRhdGFiYXNlcy4KICAgIDxhcHBsaWNhdGlvbj5wZ19kdW1w
YWxsPC9hcHBsaWNhdGlvbj4gYWxzbyBkdW1wcyBnbG9iYWwgb2JqZWN0cwogICAgdGhhdCBhcmUg
Y29tbW9uIHRvIGFsbCBkYXRhYmFzZXMsIG5hbWVseSBkYXRhYmFzZSByb2xlcywgdGFibGVzcGFj
ZXMsCiAgICBhbmQgcHJpdmlsZWdlIGdyYW50cyBmb3IgY29uZmlndXJhdGlvbiBwYXJhbWV0ZXJz
LgogICAgKDxhcHBsaWNhdGlvbj5wZ19kdW1wPC9hcHBsaWNhdGlvbj4gZG9lcyBub3Qgc2F2ZSB0
aGVzZSBvYmplY3RzLikKICAgPC9wYXJhPgogCisgIDxwYXJhPgorICAgPGFwcGxpY2F0aW9uPnBn
X2R1bXBhbGw8L2FwcGxpY2F0aW9uPiBpcyBwcmltYXJpbHkgaW50ZW5kZWQgYXMgYSB0b29sCisg
ICBmb3IgdXBncmFkaW5nIGRhdGFiYXNlIGNsdXN0ZXJzIChzZWUgPHhyZWYgbGlua2VuZD0idXBn
cmFkaW5nLXZpYS1wZ2R1bXBhbGwiLz4pLgorICAgQXMgc3VjaCwgaXQgYnkgZGVmYXVsdCBleHBv
cnRzIGFsbCBkYXRhIG9mIHRoZSBlbnRpcmUgY2x1c3Rlci4gIFRoZSBvbmx5CisgICBwYXJ0IG9m
IGEgZGF0YWJhc2UgY2x1c3RlcidzIHN0YXRlIHRoYXQgaXMgPGVtcGhhc2lzPm5vdDwvZW1waGFz
aXM+IGluY2x1ZGVkCisgICBpbiB0aGUgb3V0cHV0IG9mIDxhcHBsaWNhdGlvbj5wZ19kdW1wYWxs
PC9hcHBsaWNhdGlvbj4gYXJlIHRoZSBjb25maWd1cmF0aW9uCisgICBmaWxlcyBhbmQgZGF0YWJh
c2UgcGFyYW1ldGVycyBjaGFuZ2VkIHdpdGggPHhyZWYgbGlua2VuZD0ic3FsLWFsdGVyc3lzdGVt
Ii8+LgorICA8L3BhcmE+CisKICAgPHBhcmE+CiAgICBTaW5jZSA8YXBwbGljYXRpb24+cGdfZHVt
cGFsbDwvYXBwbGljYXRpb24+IHJlYWRzIHRhYmxlcyBmcm9tIGFsbAogICAgZGF0YWJhc2VzIHlv
dSB3aWxsIG1vc3QgbGlrZWx5IGhhdmUgdG8gY29ubmVjdCBhcyBhIGRhdGFiYXNlCi0tIAoyLjUy
LjAKCg==


--=-W/qdg/b9foHYsTg/DJ0m--