Re: Does pg_dump custom format only compress the table data?

From: Holger Jakobs <holger(at)jakobs(dot)com>
To: pgsql-admin(at)lists(dot)postgresql(dot)org
Subject: Re: Does pg_dump custom format only compress the table data?
Date: 2026-02-03 07:51:11
Message-ID: 6bff91db-843e-4858-95dd-cc8bfb90c012@jakobs.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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?
>
> Yours,
> Laurenz Albe

That wasn't the question. It was about why table DATA aren't compressed,
but in clear text.

Yours

Holger

--

Holger Jakobs, Bergisch Gladbach

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Ron Johnson 2026-02-03 08:13:37 Re: Does pg_dump custom format only compress the table data?
Previous Message Laurenz Albe 2026-02-03 06:06:18 Re: Does pg_dump custom format only compress the table data?