Does pg_dump custom format only compress the table data?

From: Ron Johnson <ronljohnsonjr(at)gmail(dot)com>
To: Pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org>
Subject: Does pg_dump custom format only compress the table data?
Date: 2026-02-02 15:55:31
Message-ID: CANzqJaAiTvMbuTUX86vZVCUY62KyHPffd_Dt1Po6Jmqv_9A_Bg@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-admin

PG 17.7

Zlvl="--compress=zstd:long"
db=mumble
pg_dump -Fc $Zlvl -v -d${db} -f ${db}.dump 2> ${db}.log

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?

--
Death to <Redacted>, and butter sauce.
Don't boil me, I'm still alive.
<Redacted> lobster!

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Laurenz Albe 2026-02-03 06:06:18 Re: Does pg_dump custom format only compress the table data?
Previous Message Alicja Kucharczyk 2026-01-29 15:09:08 Re: Setting huge_pages=off when HugePages are allocated in Linux?