| From: | Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at> |
|---|---|
| To: | Holger Jakobs <holger(at)jakobs(dot)com>, pgsql-admin(at)lists(dot)postgresql(dot)org |
| Subject: | Re: Does pg_dump custom format only compress the table data? |
| Date: | 2026-02-03 12:47:49 |
| Message-ID: | 240b5c920d864da8157e65f8b7683c6a5e6d8aae.camel@cybertec.at |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ron Johnson | 2026-02-03 16:16:30 | Re: Does pg_dump custom format only compress the table data? |
| Previous Message | Ron Johnson | 2026-02-03 08:13:37 | Re: Does pg_dump custom format only compress the table data? |