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

From: Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>
To: Ron Johnson <ronljohnsonjr(at)gmail(dot)com>, Pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org>
Subject: Re: Does pg_dump custom format only compress the table data?
Date: 2026-02-03 06:06:18
Message-ID: e31d0f6daaef9a7ce7248f43bd1063d444b4e859.camel@cybertec.at
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Holger Jakobs 2026-02-03 07:51:11 Re: Does pg_dump custom format only compress the table data?
Previous Message Ron Johnson 2026-02-02 15:55:31 Does pg_dump custom format only compress the table data?