Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1vnBBu-003LmC-2p for pgsql-admin@arkaria.postgresql.org; Tue, 03 Feb 2026 07:51:19 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1vnBBt-003mpc-30 for pgsql-admin@arkaria.postgresql.org; Tue, 03 Feb 2026 07:51:17 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1vnBBt-003mpT-1g for pgsql-admin@lists.postgresql.org; Tue, 03 Feb 2026 07:51:17 +0000 Received: from rs.plausibolo.de ([85.214.83.89] helo=plausibolo.de) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.98.2) (envelope-from ) id 1vnBBr-00000000not-08ep for pgsql-admin@lists.postgresql.org; Tue, 03 Feb 2026 07:51:16 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/simple; d=jakobs.com; s=default; t=1770105073; bh=DBNSUd/z0ZaB2IP/woh/O9A15iu4SY5lozwoCbGd9Hw=; h=Date:Subject:To:References:From:In-Reply-To:From; b=DjNI2SgE/Cl+rmXQGd9mRmkvoTZn1IgsQ8ShGEG9cdtGnkyn99bNQ8b2cv/ODi3Nw yXAv6RRXdQLbVooqzUQIrJ3IrQYng0cohVzAM5eW7/p9svaepNYd7+FYdChZQJPEvK DTrmmjyj2VW480WOSSw/ckgZDQWXWunXCDg/TAkXC+LXeAuaEJEqF7IhJEPwH0SZei M7d2Ds4EHaPiQJAXnPkHvdn8JyOxrBcHwAQbOqzDwvTE51Z810+rBa2cxRYAV3tdUK IllhAeVVJszY4RNuMoirg8ctKO1AU4I7BbrSOcCG6I0kE4AlGRL7iZJ3RZGItbXUtJ SwhJ6xfulpRyg== Received: from localhost (localhost [127.0.0.1]) by rs.plausibolo.de (Postfix) with ESMTP id CF4CA380A01; Tue, 3 Feb 2026 08:51:13 +0100 (CET) Received: from plausibolo.de ([127.0.0.1]) by localhost (h2367442.stratoserver.net [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id bkMQ0iF-jolv; Tue, 3 Feb 2026 08:51:13 +0100 (CET) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/simple; d=jakobs.com; s=default; t=1770105072; bh=DBNSUd/z0ZaB2IP/woh/O9A15iu4SY5lozwoCbGd9Hw=; h=Date:Subject:To:References:From:In-Reply-To:From; b=SUvsgZJzOOfdJApPDbCJtfldGYDGMyie7p3Z6RTBTWRFYOC7ccd8az5neFB9nuYyH M6RdT5NPgyu2nVKB6jxinwTNRGkD9nmJ+tAj1aZok49Npak8WxXkhBaPpf5TcaGbEy Mc6HtFCVRTfkyq2T4Xu71rGkbj5JTRsjofrz6cGj0GHr4VvYEkoBomcQK9UEzbdzFQ 6OrcNZGDPQmozZLg6SdiHsn5znONFvKJtCxjSRYRLiW5BItl8mEcaaOlqAu2ruS/UA JIP7xtINN5YczwPyGcK6AXmq0/iSNZ0Ql47ns6KATBjKGqAugD2XmppBIhdYOydE5h Ak2v9ON+9Rr4Q== Received: from [192.168.222.128] (unknown [91.26.205.242]) by rs.plausibolo.de (Postfix) with ESMTPSA id ABDDB380496; Tue, 3 Feb 2026 08:51:12 +0100 (CET) Message-ID: <6bff91db-843e-4858-95dd-cc8bfb90c012@jakobs.com> Date: Tue, 3 Feb 2026 08:51:11 +0100 MIME-Version: 1.0 User-Agent: Mozilla Thunderbird Subject: Re: Does pg_dump custom format only compress the table data? To: pgsql-admin@lists.postgresql.org References: Content-Language: en-GB, de-DE From: Holger Jakobs Autocrypt: addr=holger@jakobs.com; keydata= xsDiBEG8IA8RBAC6WqUzEPTjest7MvFca5WlI47EgtKzOy1D1X9gSEmPj0sQrilNGEitY/+Q kPnCvI3odz1XXf/MZQtXwlxJA4lPmx8/K7MqBj9vh0J5jRznpE7l+SBDmmDobIqBAgl6BZvH 1C7e2y72h5T1/plrXonLUGzthqBtsvWl0ogoyTJqiwCg6AOhYX+Xbcl8/AXy4F4qbUq4LXsD /j6yCKRkyleN688y9YpuS5J6/ZZ/OBCM74pa2iNge3GmXn1JeUowF693QFCGHkpswmDIoGhL 5iM6GHj9HFB6rTXW5H3sR1y6ta7vXwoNBGkgiM89B1a/KsLT5L6MZgZ5AV0tj6vxwAsuLixS SDiNVNAd8vp2FfqdLlOgThsgVIwKBACsCzZa1VxpdoNSYnkTOSZhEjZkbWApdneQ2bTxXJgW +fWgVeLiojCp6I1AmQqzwHz8UN1nrsQjH8Rnxt2J/C5H/Ek9jlOFakFQXlPMZw3tNeTA1P3B 3zPyq6hKFPZHFklUquE3gHVjnX9qxSW0xvFirf6xAMCMYWRnCQHRgiXoAc0hSG9sZ2VyIEph a29icyA8aG9sZ2VyQGpha29icy5jb20+wnsEExECADsCGwMGCwkIBwMCAxUCAwMWAgECHgEC F4AWIQScuJCxWJK1p5BOebGKV5yTsxlhugUCaVdWsQUJMQE4HAAKCRCKV5yTsxlhureAAJ96 hJrXLiFGQJknuPn8vYEFTvQe4gCgjfc8YoZBMiEgbgibbp+9Ho93YZLOwE0EQbwgEBAEAKIa ShfwcoKhx0LBF0zNz2yIOzXDRg1rKFM+cr0iLfDPNLZH01LJaw9BXLHqGRV9KYroITlHN+4N TOtgSDJpX/a9PckP0aSj5G4WeN5C9WjyFzX1uYFKf3kBOSL6EXL/rwyqkyWwbtjIKW5FKleH arGWFuHYXNMhCaIRABHiQUITAAMFA/9nVjqfChfD/kmYsksVy9lmUV+fiD1OPIxLAfnT8Beo 4ClxzL0lLOhMVjzsi2YaSEPSqPXw8kFK3a6oBIauTb/nlcrn3pFaeh7Iv2bOPmvrCgOo81Fc hsrzl+gZUgxGtv8S5+BI4/kfpUfJu8E8PgKmkTDhDR9GwwJo5y+JuSMeisJmBBgRAgAmAhsM FiEEnLiQsViStaeQTnmxileck7MZYboFAmlXVsYFCTEBODYACgkQileck7MZYbomuQCgj9xe vI2QAGxQS+u27l+7zpHvUAEAoNL+6+cWX1zG3GfEk5j0nAmwPtyi In-Reply-To: Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk 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