Request a Demo
Home   >   mailing lists

Does pg_dump custom format only compress the table data? - Mailing list pgsql-admin

From Ron Johnson
Subject Does pg_dump custom format only compress the table data?
Date
Msg-id CANzqJaAiTvMbuTUX86vZVCUY62KyHPffd_Dt1Po6Jmqv_9A_Bg@mail.gmail.com
Whole thread Raw
Responses Re: Does pg_dump custom format only compress the table data?
List pgsql-admin
Tree view
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!

pgsql-admin by date:

Previous
From: Alicja Kucharczyk
Date:
Subject: Re: Setting huge_pages=off when HugePages are allocated in Linux?
Next
From: Laurenz Albe
Date:
Subject: Re: Does pg_dump custom format only compress the table data?