On Tue, 2026-02-03 at 08:51 +0100, Holger Jakobs wrote:
> Am 03.02.26 um 07:06 schrieb Laurenz Albe:
> > On Mon, 2026-02-02 at 10:55 -0500, Ron Johnson wrote:
> > > Out of curiosity, I opened that dump file in vim, and saw not only DDL strings but cleartext table data.
> > >
> > > Why isn't it compressed?
> > Are your DDL statement large enough that you would expect that compressing
> > them would offer any real advantage?
>
> That wasn't the question. It was about why table DATA aren't compressed,
> but in clear text.
Ah, I see.
By default, you wouldn't see any table data, because they get compressed.
If a custom format dump is not compressed, the reason could be:
- PostgreSQL was built without support for compression (--without-zlib)
- pg_dump was called with --compress=0
Yours,
Laurenz Albe
