Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1l1w3Z-0000Oo-K4 for pgsql-admin@arkaria.postgresql.org; Tue, 19 Jan 2021 18:48:45 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1l1w3Y-00058e-I4 for pgsql-admin@arkaria.postgresql.org; Tue, 19 Jan 2021 18:48:44 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1l1w3Y-00058X-7c for pgsql-admin@lists.postgresql.org; Tue, 19 Jan 2021 18:48:44 +0000 Received: from mail-oi1-x22d.google.com ([2607:f8b0:4864:20::22d]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1l1w3V-0000JZ-7o for pgsql-admin@postgresql.org; Tue, 19 Jan 2021 18:48:43 +0000 Received: by mail-oi1-x22d.google.com with SMTP id w8so475643oie.2 for ; Tue, 19 Jan 2021 10:48:40 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20161025; h=to:from:subject:message-id:date:user-agent:mime-version :content-transfer-encoding:content-language; bh=TOGUNaFagtmDp4OO0eMs/CksL7CkgHvOxL/tb1w6QNU=; b=twri5u4DKO5nYzWmoqAXBFiaBxuyKHdjo5W/xGOiYQOAMEwE8zaOUTCTIHQ3O+NXQp tD+JfkVpJUDLOI174qFmDkkqs9Mlig0xUW+sf79586wU7V69bQVABa66bPJB8a7sLI3z eFydj8ZI5pnnpb043MLSVHAjj+YaER6riGsa660vDPK3ksHQxnMSdoRZYK3B7ta29r+j zIS5Cn88r7ZD+rq8Ea+XiliUDl7Bmbx/wbSrehui5w1AgBNNwmsozHXFcSAIC553pYge kLJJq0Mj4ieJTTZ27R1R8FNpHD2+cpPe6hZMi0cyA7MG+exeo1aAXf4PSPEZpzROyYpt jLjQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:to:from:subject:message-id:date:user-agent :mime-version:content-transfer-encoding:content-language; bh=TOGUNaFagtmDp4OO0eMs/CksL7CkgHvOxL/tb1w6QNU=; b=duMThQSPxH6upT/KPIQyPHdzI98sWQ52aeRpXQp788Vu8d+Qzv0v+J5xOaBc2gi/tS OXwGm5ZOsHXMQG/0he0xSkhjDZAI0SNz5KHG4YUuk8wIgpb8tj6l/zWAq1Yaob3JQOdg ktOSO6LGsmqLMUxdPSPJrPWQPc/Z4meRXfP47ymXKcvCQ3f7zSs6dqMkYGwmcQhl+7bg kfQFwsqULgCAJBCA9k7x1XPLcZ9KOBJk/uwxqCw/4yGnSmpVTwJAlOyuFWeIMYc1DXdx T0IlK/GWkSoOLdgESjQ2u37KH6DWTbMUJOg4KOFHEk74Xv7WNgdTrhZCS5ln4i8tOnwL bSMQ== X-Gm-Message-State: AOAM531Uczjh6+2PbF+rdvo4UhOGkHe+wfmGuJ+uSZobPgnHucYpbajb i9MVuMVXllghCS9/P1jdJUaXMSo3wdPWoA== X-Google-Smtp-Source: ABdhPJwZDzA6zsZISKw6Wgn8QKNdsMXR4zhFAYugyrY0vFGHlM4ITdSQh8EoWjHH/ckb4KZNWqhtWg== X-Received: by 2002:aca:5b08:: with SMTP id p8mr719633oib.23.1611082118834; Tue, 19 Jan 2021 10:48:38 -0800 (PST) Received: from [192.168.88.10] (ip174-67-141-204.no.no.cox.net. [174.67.141.204]) by smtp.googlemail.com with ESMTPSA id d206sm1722341oia.10.2021.01.19.10.48.36 for (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Tue, 19 Jan 2021 10:48:38 -0800 (PST) To: pgsql-admin From: Ron Subject: TIL: In pg_dump, beware the combo of "-Fd" and "-Z" Message-ID: <1ad81a44-b39e-5854-ba82-0bd1b61bef25@gmail.com> Date: Tue, 19 Jan 2021 12:48:36 -0600 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:68.0) Gecko/20100101 Thunderbird/68.10.0 MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8; format=flowed Content-Transfer-Encoding: 8bit Content-Language: en-US List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk PostgreSQL 12.1-2.module+el8.1.1+4794+c82b6e09 from the RHEL 8.3 repository.  (Installing software outside of the RHEL is Against Policy.) For a project using 9.6, I have this command backing up a database: pg_dump -d ${DB} -j ${THREADS} -Fd -Z0 -v -f $DB 2> ${DB}_pgdump.log So, for the 12 project, I copied it over, removing the "0", since I want these backups compressed. pg_dump -d ${DB} -j ${THREADS} -Fd -Z -v -f $DB 2> ${DB}_pgdump.log Since the -Z default is "6", I assumed that would compress the backup.  It didn't, acting instead like "-Z0".  Removing "-Z" made it compress. This surprised me, and is very counter-intuitive.  A bug? -- Angular momentum makes the world go 'round.