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 1uc5Xs-008q2E-9u for pgsql-hackers@arkaria.postgresql.org; Wed, 16 Jul 2025 17:03:52 +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 1uc5Xp-00C4Jm-Sx for pgsql-hackers@arkaria.postgresql.org; Wed, 16 Jul 2025 17:03:50 +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 1uc5Xp-00C4Je-J3 for pgsql-hackers@lists.postgresql.org; Wed, 16 Jul 2025 17:03:50 +0000 Received: from mail-pl1-x630.google.com ([2607:f8b0:4864:20::630]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1uc5Xo-007c4j-0A for pgsql-hackers@lists.postgresql.org; Wed, 16 Jul 2025 17:03:49 +0000 Received: by mail-pl1-x630.google.com with SMTP id d9443c01a7336-23649faf69fso714905ad.0 for ; Wed, 16 Jul 2025 10:03:47 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=j-davis-com.20230601.gappssmtp.com; s=20230601; t=1752685427; x=1753290227; darn=lists.postgresql.org; h=mime-version:user-agent:content-transfer-encoding:references :in-reply-to:date:cc:to:from:subject:message-id:from:to:cc:subject :date:message-id:reply-to; bh=3PkP6iN+Z+ohg/PNALJ/0Etimku9EbErHRquSKTI2SI=; b=RwgK4pVka3bMsugkhFMzOGnHVtX7C7h0SQqFlZ14NyQEWNWmaxP/A4EXolcvwb9Ucv JeRaPSzW4lzepmV7JOQhmXVpqA85S4ybkxu95mQd8g7aoJozC+SIHOEdLz0WFB0QeWQ3 6PgQDvagSBW4hAz67Qf51wmTnejD+pp322p6QNDtE+qEebo1p409q139STTn9oed3GQp fm0qxzT+uBrWqZeTGq6/5a1bNr2o2irgBnQ/H8OzwH1c7vrCF79jcBZDQFzYaCv3ikR6 AKfiMjAHVcBQAYv100sJ29oPWl4Fkr/PXN0uzkVQhOFqvt9XsbE7UbV4Yy68P71J7SvR 6bYA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1752685427; x=1753290227; h=mime-version:user-agent:content-transfer-encoding:references :in-reply-to:date:cc:to:from:subject:message-id:x-gm-message-state :from:to:cc:subject:date:message-id:reply-to; bh=3PkP6iN+Z+ohg/PNALJ/0Etimku9EbErHRquSKTI2SI=; b=Sv6SL0YVUUalhok4Cmfw4YuIr6ZvD8OvEN4lqi3PXivfaOE/gyK+BGsYIuZv7Qb3dl Q6U7IHuSCNHK6tFFOetHkh5+/4B2yiJYTs9Vru9zXdsPFGXJyKh2gAkCvHLooqwxDBB0 L1xA5RYItbNNS4XAMbu7uc2R9da6pYWVbX1UEjiXNqhea4RJriLyvYWMlGJ5HO8hDq/1 KClWOars7W7KlvFeKXaiK6GKizltUCFlxYA/lGkaDGtYIOkSGdxZmGLKd1PQ2TDc9dM1 fADIHphJPz1gHI/LJnkuEzA9fHts4SFJpGNCEh7+D6v+/N/QZSgERSi5C44deZz79ORT Jcbg== X-Gm-Message-State: AOJu0YzsTmaphm15SMpm6mkNFTNw5dv57R7KjAgsG+FRO+jxKEbnQiam 1I5XLcbhbqjksTvVN86LPgp2vNS52xSdJ12wY1aZLnIaiBRUFFuksMcGsbb8tDTbKxGjLt/VWwP Wj9g= X-Gm-Gg: ASbGnctdzqJjQHK4Xf/GmwXfx66jd5k59SG2MzIkuD6ceZeD4YedEiv+rLZYk0qQVdd Kb27DnvX0EL1AnDUJlOs/OJhfM9J44lwnVw50H1I3fMRK1UwK0spyLPbRklOTR1snM+S9KNqXVG QXgCdUe900kSqk+GUED19sUu5wnRL5rMuB4i0AM2WHbbDzWtDNBq+03WI0Cct7W7HAmbfPn9vfR /l49gC/bIY0TS35wgvq5k+SyQ9bpHw3rCHFdpkbyLDH/aUPx0BjYuQ+k0dpCdJzi56ipFFltVXG 93EN0cFN1K3oZV7yx9ZHUGewAs87osiD7m4VWtq9/Ll7ibHc2eJGC4xWq0cIOJBo0RvP02E86pC V0t2L4CVOt23vrQivhX4vnpLptsmHyfxb8/eIIzRlSLPUlQXj+Y+x0akdsb2sMK9puIsp X-Google-Smtp-Source: AGHT+IFXaiEK7XCo18pn3I6/fasV2+mKfWR8Iq6CpGKR3fP4H+YjBUo0eB1WmZw5VZK3X2LjIta3UA== X-Received: by 2002:a17:902:ccce:b0:235:f143:9b07 with SMTP id d9443c01a7336-23e25684c62mr57074035ad.5.1752685426539; Wed, 16 Jul 2025 10:03:46 -0700 (PDT) Received: from jeff-ws-bridge.lan (c-76-102-242-158.hsd1.ca.comcast.net. [76.102.242.158]) by smtp.gmail.com with ESMTPSA id d9443c01a7336-23de42ad948sm133915975ad.61.2025.07.16.10.03.44 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Wed, 16 Jul 2025 10:03:45 -0700 (PDT) Message-ID: <2d3aeb5264a55a792f809b78dec01018602ae3dd.camel@j-davis.com> Subject: Re: pg_dumpall dumps global objects with --statistics-only or --no-schema From: Jeff Davis To: Corey Huinker , Fujii Masao Cc: pgsql-hackers@lists.postgresql.org Date: Wed, 16 Jul 2025 10:03:44 -0700 In-Reply-To: References: <08129593-6f3c-4fb9-94b7-5aa2eefb99b0@oss.nttdata.com> Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable User-Agent: Evolution 3.52.3-0ubuntu1 MIME-Version: 1.0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Mon, 2025-06-30 at 16:44 -0400, Corey Huinker wrote: > >=20 > > Since pg_dumpall treats global objects as schema-level content, it > > currently > > includes them with --schema-only but skips them with --data-only. > > By that logic, > > it should also skip them when either --statistics-only or --no- > > schema is used. Thank you. >=20 > +1, pending resolution of the defaults issue. I went ahead and committed this as it clearly needs to be fixed. We can continue the options discussion. Regards, Jeff Davis