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 1vvgn2-00E5xT-2S for pgsql-hackers@arkaria.postgresql.org; Thu, 26 Feb 2026 19:12:48 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1vvgm2-00F0iS-1I for pgsql-hackers@arkaria.postgresql.org; Thu, 26 Feb 2026 19:11:46 +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.96) (envelope-from ) id 1vvgm2-00F0iC-0A for pgsql-hackers@lists.postgresql.org; Thu, 26 Feb 2026 19:11:46 +0000 Received: from mail-qt1-x82c.google.com ([2607:f8b0:4864:20::82c]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1vvglz-00000001LiX-0AP7 for pgsql-hackers@lists.postgresql.org; Thu, 26 Feb 2026 19:11:45 +0000 Received: by mail-qt1-x82c.google.com with SMTP id d75a77b69052e-5069df1de6fso10395881cf.3 for ; Thu, 26 Feb 2026 11:11:44 -0800 (PST) ARC-Seal: i=1; a=rsa-sha256; t=1772133103; cv=none; d=google.com; s=arc-20240605; b=NDXCsh+rSSGfEdJ52YStqz2G1johVSm2UWuBBFAw/dgJz8vBSw4LWbLW25o8i3OmmH tzF8nlVhCQQGOCnItc5kH6P0UHP2YNibRYEFVbnTqkC7WSAQFHHb8tNO8uffyc2G+dDx +ybf+AtZbmL3jgcq1Vin8cPJgijnMjKjCoV2mSy7gbJLtpcvwf+XHymtUg2b+pncNuCr IubTe2yrliPRBCBDv6+2OO++TU0Y5fhdC6z9vUJBoO0hF3/lj9b0YlJLuwXr8ulYSs7R sLgwX4rBLVGWKTXBARfS4WfDiCquI5rWvE8L3HhqLnshDHFuWdLU6NgZKh+kZg/lWAto Ec/g== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=google.com; s=arc-20240605; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:dkim-signature; bh=AW+79gHYwPFSoCKRwhhdA5ER4j+3425kM8gu6zTa24Q=; fh=daXDPF2VWeqjsDZ/ct6PCfn2gewiCwufbIIVLqjElDA=; b=S1HPWIXFTmotN2x/1DSH/Qy6uioawGlobZGGJhcWd4YOaOxBKWrL4OZ30pdE880S4H kZ30LX67IDIr4X29JXpC0816SSRz0AL1Ox0DHhv4lklwFK/pc718HuqZDZPO/YFqdKZi v9tVjJ2RdmnbIsZmQzgElnMfu3xVXghv+ujITU5SQfZLICElt5hs61tjDkl1683tBMXs OSdDrdcxORQG9MHbIkVOhgB31eR+jN2TcEa+glDowtpQrjDWifK7upBgLSL6xwQsSuOO tOTqtnI7Nl2Gi8rrC20C7j7UV9oa/yTt83KHVUr//hpvZsZB4FtYPl0DgZeGqIlXpm9W HuAw==; darn=lists.postgresql.org ARC-Authentication-Results: i=1; mx.google.com; arc=none DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1772133103; x=1772737903; darn=lists.postgresql.org; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:from:to:cc:subject:date:message-id:reply-to; bh=AW+79gHYwPFSoCKRwhhdA5ER4j+3425kM8gu6zTa24Q=; b=JOn6YJsGQ+xlXS/nKbSK14GhSyuCgTNOFaWxWw6Pb26i1zhAXfQ2FMWevjruQJIO2X UI2Mh/usuncVIpN42ngeyRaYNxE+otTj+zYNtDDNq4sp9ib0kd5V/m8+Hgjoy8IlQnUz eN7t+ncanMX71ick3Cet9jMVmIltUu9lyq3GgRpuNzQCARlmYoGUB5W0MK7MdE2CPrqJ eOUSOlb7eq3MEjvLZYYZW1GdeTUko1gXfeJmhOy2gOdBnBy7anlAqcRlaGNTk0Ud6Wkp 4Zt7IxJeyicm8JvFJN98isKZpu/RGpcrrzgQrx5xbJd7aHhVf9VQ/8cjQOWC3MDocujm 2AJA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1772133103; x=1772737903; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:x-gm-gg:x-gm-message-state:from:to:cc:subject:date :message-id:reply-to; bh=AW+79gHYwPFSoCKRwhhdA5ER4j+3425kM8gu6zTa24Q=; b=WdpE3cvlSOG/dUnBRcOsQ3cXt1W0yhGU3efMolgDm3T3w8y5tB9EyPNWcGC7i+bi3l MReCuMr+hgo4fvi7iQIkUGmooH9gNKuwdcBBMGp4s29S0wSgEqSsCgfmJo4ujVExxC38 oFGwL1NqmWk7shDKjZN55JORlf6o/jbNrKbSJMqgG/RSF0k+id4b/bOKgp4SDvnriebP 4mOnM58UtwObxflVSJvBA9XQynjBSFr9Ps+2LTFYs6jE+7q/AhWgoQQugQHcOOWLOUyn AFmxWWdZzgpJ94D1sozwrCIp+Qo8OWzuGKkDtBN9omZVrA7JsZshhy5lCzQWnz90M2/J xiMA== X-Forwarded-Encrypted: i=1; AJvYcCWXmNr2XeAwaoXlpcdR597DpjBQsxGpPDr7ZTBYfHbQFpSDgzaijy/XGz4L+UYmGLYrKUzG/GqhmevE/LTS@lists.postgresql.org X-Gm-Message-State: AOJu0YyElIJdV+QO3lpFGe4iFSgRbu7gWi4IVAuA4tp1C+U2L+/rTa3F dR7OAOi7Vy+lnxrQsWmCdPALF9StXRPC16weSqZIEakzgEQUXf0icxLBWWKHKa5qYiJtoLLH2UJ XD+E2GXV09L7IQAAyuWyXVfpYWmqpaAM= X-Gm-Gg: ATEYQzwCH2cPtpmfamCreMK68K6ioJRdNie5CIsaRnnUYCCZl2Y31bSXtFPD3Y8J7OZ oYcvQj4CkMs561kp3wZ8WYWIaoJTwfzU3DhIquMKQeKFJD9+XG79L69DQYJACUjXwKa71d3jht2 8/bW4rPDlwy8MqCs6KSZhs5ZP00FpyOGFnjjYQsMfKcvtc+0LJZTDLhKvJyJAC8DQRDjli7Ujro BXjZ/7tJ09O1Mw4SRFxrrPDo9h+gFT9jNNxjd1+zJNkMkVIMxYVYJLXlig1dXtaV0ZFw0seQZIU C7ge4td/ X-Received: by 2002:ac8:57c9:0:b0:502:e1ed:c352 with SMTP id d75a77b69052e-50752822dc4mr587541cf.45.1772133103326; Thu, 26 Feb 2026 11:11:43 -0800 (PST) MIME-Version: 1.0 References: <3f22a8bb-29e8-40cc-97a1-309181da2c13@dunslane.net> <4022765f-38ee-48a3-b246-615b3f8e1c23@dunslane.net> <59d3616f-6d6d-40d5-87e2-e019e350b52d@dunslane.net> <7faf3a59-cfe1-45cb-a972-55e05560b414@dunslane.net> <2e7ada75-422c-4153-9437-ea0ce8d63521@dunslane.net> <84764ef6-2bcb-43f7-9037-d7b589857da9@dunslane.net> In-Reply-To: <84764ef6-2bcb-43f7-9037-d7b589857da9@dunslane.net> From: Mahendra Singh Thalor Date: Fri, 27 Feb 2026 00:41:31 +0530 X-Gm-Features: AaiRm533s3W0Tnr02Pbp4AQ9LXimaw0V-oRvhp2owVm1H3rAahWGuS3Q8paa0ng Message-ID: Subject: Re: Non-text mode for pg_dumpall To: Andrew Dunstan Cc: jian he , tushar , Vaibhav Dalvi , pgsql-hackers@lists.postgresql.org Content-Type: text/plain; charset="UTF-8" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Thu, 26 Feb 2026 at 19:32, Andrew Dunstan wrote: > > > On 2026-02-24 Tu 5:40 AM, Andrew Dunstan wrote: > > > > On 2026-02-24 Tu 2:21 AM, jian he wrote: > >> Hi. > >> > >> For v19, the commit message > >> """ > >> pg_restore is extended to handle these pg_dumpall archives, restoring > >> globals and then each database. The --globals-only and --no-globals > >> options control which parts are restored. > >> """ > >> There is no --no-globals option. > >> > >> In file src/bin/pg_dump/pg_dumpall.c, no need > >> `` > >> static pg_compress_specification compression_spec = {0}; > >> `` > >> Since compression_spec is only used in an IF branch, we can declare > >> it locally. > >> > >> > >> The options below are not supported for pg_restore non-text restore, > >> we can document this. > >> , > >> , > >> , > >> , > >> , > >> . > >> > >> > >> > > > > Thanks, fixed these. > > > > > > > > > pushed with a slight tweak. > > > cheers > > > andrew > > > -- > Andrew Dunstan > EDB: https://www.enterprisedb.com > Thanks Andrew for committing this patch. -- Thanks and Regards Mahendra Singh Thalor EnterpriseDB: http://www.enterprisedb.com