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 1tUr1F-003JJX-JW for pgsql-hackers@arkaria.postgresql.org; Mon, 06 Jan 2025 17:36:02 +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 1tUr1D-00AimD-TT for pgsql-hackers@arkaria.postgresql.org; Mon, 06 Jan 2025 17:35:59 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1tUr1D-00Aim5-I3 for pgsql-hackers@lists.postgresql.org; Mon, 06 Jan 2025 17:35:59 +0000 Received: from mail-yb1-xb31.google.com ([2607:f8b0:4864:20::b31]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1tUr1A-000BZg-35 for pgsql-hackers@postgresql.org; Mon, 06 Jan 2025 17:35:58 +0000 Received: by mail-yb1-xb31.google.com with SMTP id 3f1490d57ef6-e54d268bc3dso50724276.1 for ; Mon, 06 Jan 2025 09:35:57 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1736184956; x=1736789756; darn=postgresql.org; h=in-reply-to:content-disposition:mime-version:references:message-id :subject:cc:to:from:date:from:to:cc:subject:date:message-id:reply-to; bh=qnj6/3zzuMx2BtsS83zzGhMzL7IrNumJ7bkGaJE12Rc=; b=JiDMdhCPPsM3CeV2pOL27WN2lG6h0dD/7lcPnY+d07JiyrxUszkGwpPVsrv3v2S8Gq 1tXyfaVaiPVTN9EkR4GdDvUe+rQOYi5qy/Jpun14TTAq+sqWg8deRzzwwszKwh+CsKHe YXWN1WXvgDqg2UWsmx9ZesfpX3lUJEpwlxASad3APEArh9OZ2uFLBqC6jjbQMGlK2JA2 j6cD8lQZBetcDhaxG7BRSNF4rK2AH3Uv3AcK5OWhRMn2ImMbrsLJITCv0t8Ki0p5RRd3 83n4g4ZoE2ic7bhRlm+/pXW9uJmENgwlwOX31BQhAzqJaLgLTpdRx+BiIrjCfpETjp2p IE6g== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1736184956; x=1736789756; h=in-reply-to: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=qnj6/3zzuMx2BtsS83zzGhMzL7IrNumJ7bkGaJE12Rc=; b=gtl66mrP2HNpG6E6Df8gpU2t8/9hvEyB/Qm9QA2Ty0RC+PR8oolc1UrjSNI36f4wK4 6ThmRCYGVWUaUoxbsPbAcAYuppBWS/eCEh+6z3hNFJolx9F7dFv6TeycVV0no6+0MOVd MvfAg8t1DYiC3Xn37sLOEE/Hd9aatvCWokrjy+BLmQPY87EZ8KuXaTXk/BfPI788eD4m A4W5F10SeBkx/XxqMcG3vWsw71BMmhW1TPhhYOWc8EbL95Ad5DV+SPOsqB78ltS1Gxbv zws1ORSIQzQi9ORCSvuBSLnLubA3zvOAf8XI2u7i9patjS8bDAbbJ6/f2KD05XzJo37w c6KA== X-Forwarded-Encrypted: i=1; AJvYcCW8v56iwnuNlyAhKgqRMG16GyFk3M+3gSejVz98izLbOG6qXwIJByEvL6L3X9BRXcAhVbSu+hBGP08UxKbW@postgresql.org X-Gm-Message-State: AOJu0YykA4fXK9a9ZatSux+wa9yBcItECymtWbGNh3WhiPsJdh7RCR7B tPasgPz4yzubWTMXVTlV6Gr2Xd2FWkHI400eLNdiiLEuiE6DSBMRNcKk3A== X-Gm-Gg: ASbGncseN20zneaUPj/f3zllZgxFh4wPnDm5WpaZNflUj9s87kKvp0tHCAzUuW9bldq Khf3Yv67eYNdlywmJauGXXh4uxL3BWhrJCMWvML3Dp6Ba7jshFgb4GmD/FSVnmxLQmV1ib2rLEF sqBln0JjFch9U31N6GvJ5XV/LdvVzUZ5Kt4VBAhJQLv6iQbeQfUTQHVOAwybdlQA3BrkKzbDFCb DRZ/PM5X5auMH1VGvsglSdCR3eSxu+9KSCRR63E6s2OjT5mN9/FSD5dd/J9G2AXn5Ds9zrE3WG/ 2HC+YevXJgteAPVkRFMT5SPNC+fEzmC9QaDxuYyprLFjE07OX4Im X-Google-Smtp-Source: AGHT+IFgQsdBrV3QmN+Y/1/YRA33LI1DAMn+5mVf06gEfPCCxrYW/5RVGCjZ+zmZ0RpNgy3Jwub+cQ== X-Received: by 2002:a25:ad65:0:b0:e53:a95b:9885 with SMTP id 3f1490d57ef6-e53a95b9b36mr29797023276.34.1736184956342; Mon, 06 Jan 2025 09:35:56 -0800 (PST) Received: from nathan (162-195-168-172.lightspeed.stlsmo.sbcglobal.net. [162.195.168.172]) by smtp.gmail.com with ESMTPSA id 3f1490d57ef6-e537cbebb78sm9074203276.5.2025.01.06.09.35.55 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Mon, 06 Jan 2025 09:35:55 -0800 (PST) Date: Mon, 6 Jan 2025 11:35:54 -0600 From: Nathan Bossart To: Mahendra Singh Thalor Cc: Magnus Hagander , Tom Lane , Andrew Dunstan , PostgreSQL-development , Dilip Kumar Subject: Re: Non-text mode for pg_dumpall Message-ID: References: <740696.1718036463@sss.pgh.pa.us> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Thu, Jan 02, 2025 at 02:05:13AM +0530, Mahendra Singh Thalor wrote: > Here, I am attaching an updated patch. I fixed some bugs of v01 patch and > did some code cleanup also. Thank you for picking this up! I started to review it, but the documentation changes didn't build, and a few tests in check-world are failing. Would you mind resolving those issues? Also, if you haven't already, please add an entry to the next commitfest [0] to ensure that 1) this feature is tracked and 2) the automated tests will run. + if (dbfile) + { + printfPQExpBuffer(&cmd, "\"%s\" %s %s", pg_dump_bin, + dbfile, create_opts); + appendPQExpBufferStr(&cmd, " -F d "); + } Have you given any thought to allowing a directory of custom format files, as discussed upthread [1]? Perhaps that is better handled as a follow-up patch, but it'd be good to understand the plan, anyway. [0] https://commitfest.postgresql.org [1] https://postgr.es/m/CABUevExoQ26jo%2BaQ9QZq%2BUMA1aD6gfpm9xBnh_t5e0DhaCeRYA%40mail.gmail.com -- nathan