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.94.2) (envelope-from ) id 1sGgYC-00FvuM-Ag for pgsql-hackers@arkaria.postgresql.org; Mon, 10 Jun 2024 15:03:13 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1sGgYA-00DI3Z-Ea for pgsql-hackers@arkaria.postgresql.org; Mon, 10 Jun 2024 15:03:11 +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.94.2) (envelope-from ) id 1sGgYA-00DI3R-5K for pgsql-hackers@lists.postgresql.org; Mon, 10 Jun 2024 15:03:11 +0000 Received: from mail-io1-xd31.google.com ([2607:f8b0:4864:20::d31]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1sGgY8-000x21-Ta for pgsql-hackers@postgresql.org; Mon, 10 Jun 2024 15:03:10 +0000 Received: by mail-io1-xd31.google.com with SMTP id ca18e2360f4ac-7eb73eb209bso76652139f.1 for ; Mon, 10 Jun 2024 08:03:08 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1718031787; x=1718636587; darn=postgresql.org; h=in-reply-to:content-transfer-encoding:content-disposition :mime-version:references:message-id:subject:cc:to:from:date:from:to :cc:subject:date:message-id:reply-to; bh=2Ww8nPNCvhhIb3K48nVdFtdZMp2CRRRwn5IxIkJ2edE=; b=VhJbJX4ecqJLvGEsl14quJmQdeDafh6p1TSIYbyTFSClS/qpTt9wvydNEJi0oC3pWU fIyHy2pYaVQAbWD/oFZ2MI7PqmEIGzW25JnrKRVhoaVhdFw7M4EJGjRpD48DW7pO+wAe goSDUjZOGJE2QcdNaJ5F5ROJ4SzPySa9WOlvFhnjOVxJtntdn3zGS4yUEthPDg+hUxHt 2lMdtUJNgWBanKIb1p8LLGSLvqH1AJr5HuUAZlMhSnUuZHpBYPzqmpetRWCWK46Y79ta rojK9/ybGp1zznU0sV7tOqdkz/JK1fFRAfdTCIs1o7Hy4YDn/cJ2Y6lhRVgEPfqLzAtP jyYA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1718031787; x=1718636587; h=in-reply-to:content-transfer-encoding:content-disposition :mime-version:references:message-id:subject:cc:to:from:date :x-gm-message-state:from:to:cc:subject:date:message-id:reply-to; bh=2Ww8nPNCvhhIb3K48nVdFtdZMp2CRRRwn5IxIkJ2edE=; b=XxTtgEQ/B3aqSJmhzuRZ0kVpChM5Xtvk7MCkQjIspKlnTd2xMVUx/G7dYmFtsINV+d jI8a1IU4k5U+V+PUu171rPr2YTe4dnAS8ChkzhU8T2H4qWdqn4VXgPYSodVHUQr8joF4 SE9VrKRKXbaj8vTEgiLaL5zRkdFiKyZMFe+IVC5oOF5WzbnZxmlc5kL517aZXmTq/+tn Sq2dA652fWcy8NdIt9BaYmhKNZyafWLTCSQnaHEwS0LjbvwstaSeBdXSCYd/RmEXoL7k CAx2m3WCDYQw7/+WvxfI/v1Blo2vzlgbFZBmkBfaAtb45vPeemM/soLSUsxqGOY8yYZv WJrA== X-Forwarded-Encrypted: i=1; AJvYcCVAkVAgJuUm8M+XL4p4cF+uY+j8ZOG2TX7OCkpvntF0pzsSxwOxcsEiiizyX1chtss9a4mpaWlHDU4qd3geb4jdu80YuVCWkHWkFkIe X-Gm-Message-State: AOJu0Yy3dcuYMmInf1CxIvjuzeAxrCIo4g9c58Dar4mAP3PO79dvHX+g Qx0nClu3bHiUJLGPlVI/leq0DM726xF+qJqbEDOUqkmKup4fCE1a X-Google-Smtp-Source: AGHT+IE1wyWhaWixlPaSQmS6vwFKDztzQYUjQl1g5TyqJxzXi2hvKEDiOa86WUVS3/QBoqKmG/uW0Q== X-Received: by 2002:a05:6602:134b:b0:7de:c720:ab1f with SMTP id ca18e2360f4ac-7eb5727971fmr1139275539f.20.1718031786904; Mon, 10 Jun 2024 08:03:06 -0700 (PDT) Received: from nathan (162-195-168-172.lightspeed.stlsmo.sbcglobal.net. [162.195.168.172]) by smtp.gmail.com with ESMTPSA id 8926c6da1cb9f-4b7a23808c2sm2536258173.113.2024.06.10.08.03.06 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Mon, 10 Jun 2024 08:03:06 -0700 (PDT) Date: Mon, 10 Jun 2024 10:03:05 -0500 From: Nathan Bossart To: Magnus Hagander Cc: Andrew Dunstan , PostgreSQL-development Subject: Re: Non-text mode for pg_dumpall Message-ID: References: MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Mon, Jun 10, 2024 at 04:52:06PM +0200, Magnus Hagander wrote: > On Mon, Jun 10, 2024 at 4:14 PM Nathan Bossart > wrote: >> I'm curious why we couldn't also support the "custom" format. > > Or maybe even a combo - a directory of custom format files? Plus that one > special file being globals? I'd say that's what most use cases I've seen > would prefer. Is there a particular advantage to that approach as opposed to just using "directory" mode for everything? I know pg_upgrade uses "custom" mode for each of the databases, so a combo approach would be a closer match to the existing behavior, but that doesn't strike me as an especially strong reason to keep doing it that way. -- nathan