From: Ron <ronljohnsonjr@gmail.com>
To: pgsql-admin@lists.postgresql.org
Subject: Re: TIL: In pg_dump, beware the combo of "-Fd" and "-Z"
Date: Tue, 19 Jan 2021 23:37:26 -0600
Message-ID: <d68bd2ad-f9ba-21e0-6b32-da9e4476b008@gmail.com> (raw)
In-Reply-To: <249144ee-e91c-adfb-bcfa-dc1c5462e0c4@03s.net>
References: <1ad81a44-b39e-5854-ba82-0bd1b61bef25@gmail.com>
<CAKFQuwYcWQP=G45=oTHkXa5f2EN_emSJbAy1chOg+hTd_wrjmg@mail.gmail.com>
<267c0d6d-6a02-4c3a-b928-75472ce66de0@gmail.com>
<249144ee-e91c-adfb-bcfa-dc1c5462e0c4@03s.net>
On 1/19/21 10:54 PM, Adrian Ho wrote:
> On 20/1/21 5:11 am, Ron wrote:
>> On 1/19/21 1:55 PM, David G. Johnston wrote:
>>> On Tuesday, January 19, 2021, Ron <ronljohnsonjr@gmail.com
>>> <mailto:ronljohnsonjr@gmail.com>> wrote:
>>>
>>>
>>> For a project using 9.6, I have this command backing up a database:
>>> So, for the 12 project, I copied it over, removing the "0", since I
>>> want these backups compressed.
>>>
>>>
>>> The versions in use doesn’t seem pertinent to the observation - this
>>> behavior hasn’t changed (at least in the docs).
>>>
>>>
>>> Since the -Z default is "6"
>>>
>>>
>>> It is? Where do you see this?
>>
>> https://www.postgresql.org/docs/12/app-pgdump.html
>>
>> "-Z 0..9"
>> "the default is to compress at a moderate level."
>>
>> It doesn't say "6", but every other bit of software I've used defaults to
>> level 6.
>
> A quick look at the `pg_dump` source code indicates that:
>
> * `-Z` requires an argument, and
>
> * the argument is converted to an integer with the `atoi()` C function
>
> This means that `-Z` actually took `-v` as its argument, which `atoi()`
> converts to integer 0. That explains what you saw, and I'm also guessing
> you did NOT get verbose output from your second command.
>
That's right.
--
Angular momentum makes the world go 'round.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: ronljohnsonjr@gmail.com, pgsql-admin@lists.postgresql.org
Subject: Re: TIL: In pg_dump, beware the combo of "-Fd" and "-Z"
In-Reply-To: <d68bd2ad-f9ba-21e0-6b32-da9e4476b008@gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox