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 1oiUex-00017b-RS for pgsql-hackers@arkaria.postgresql.org; Wed, 12 Oct 2022 05:52:03 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1oiUew-0001HM-NF for pgsql-hackers@arkaria.postgresql.org; Wed, 12 Oct 2022 05:52:02 +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 1oiUdM-0004PN-9b for pgsql-hackers@lists.postgresql.org; Wed, 12 Oct 2022 05:50:24 +0000 Received: from wout2-smtp.messagingengine.com ([64.147.123.25]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1oiUdJ-0002Sd-Ut for pgsql-hackers@postgresql.org; Wed, 12 Oct 2022 05:50:23 +0000 Received: from compute4.internal (compute4.nyi.internal [10.202.2.44]) by mailout.west.internal (Postfix) with ESMTP id 4437B3200933; Wed, 12 Oct 2022 01:50:19 -0400 (EDT) Received: from mailfrontend1 ([10.202.2.162]) by compute4.internal (MEProxy); Wed, 12 Oct 2022 01:50:20 -0400 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=paquier.xyz; h= cc:cc:content-type:date:date:from:from:in-reply-to:in-reply-to :message-id:mime-version:references:reply-to:sender:subject :subject:to:to; s=fm3; t=1665553817; x=1665640217; bh=rLK2C+mB2j DdxXMDLPXTPL2x9emPqoemV2NuLMZMcPU=; b=tIf94mKCPbI0kOKuPEUwq31dxI MNJ6Iud3jr45R4Nn1QQuH2wQCeiccz5iws3/FIPFK7ANKh2AvZlMpg8EAqNQg0XT 5BqAeWcPn+5ugF/w//YQA7jkzIANc9V0oG5Bh3I0CIZNZ68N6RobM2sQPfwJIK4r 2oyZm+xwqfA/mAeNxyC6EWLJMwTCNCnpL6sRdHx8RESWBw802bFpb9rg743cCA6n xEnBkdM2dUr5ctQF1F9Bet6DvL3cluh/+vG4DEKrGryoSsfi5nndFKyEfIiXQexF t/z72W83EJsQqOZexixzKiZE8c76RwlQOXZIf+IZjIF1FAMLcAJfa+KRs2Og== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:cc:content-type:date:date:feedback-id :feedback-id:from:from:in-reply-to:in-reply-to:message-id :mime-version:references:reply-to:sender:subject:subject:to:to :x-me-proxy:x-me-proxy:x-me-sender:x-me-sender:x-sasl-enc; s= fm3; t=1665553817; x=1665640217; bh=rLK2C+mB2jDdxXMDLPXTPL2x9emP qoemV2NuLMZMcPU=; b=l6O07SY4KwryaVF6STwkRPmdBhlZ4Efa6O9hS/BOUMWh 5EJVtOPaxmxSDfDdKn5dlb674UheBo7uXLqLcvDn8MaB6qeJCiin/csc/91Lwg48 oUyZ6EyzQ1pPXBrzUrFqbK7Mt1VL9T8vOwqnhjvd3kmcGjxPM66/JiRAHNc8hS5o ozVWwqibelmiLBqOUfxWw6C8CNsa7pT0g1vBJZ/OwyQBeXrjHGFUS4Maojy2TUoa 2CGzSSFfUeP5zlGADCNOq7JJ1OoIvQly0MjrtKAjPOddYbu8itqiLIwJBgVRUnX/ 2gGp5mxLBPqEIzYgtuXqHEkbyd4eCktS2eVBAnCXEQ== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgedvfedrfeejjedguddtudcutefuodetggdotefrod ftvfcurfhrohhfihhlvgemucfhrghsthforghilhdpqfgfvfdpuffrtefokffrpgfnqfgh necuuegrihhlohhuthemuceftddtnecusecvtfgvtghiphhivghnthhsucdlqddutddtmd enfghrlhcuvffnffculdejtddmnecujfgurhepfffhvfevuffkfhggtggujgesghdtreer tddtvdenucfhrhhomhepofhitghhrggvlhcurfgrqhhuihgvrhcuoehmihgthhgrvghlse hprghquhhivghrrdighiiiqeenucggtffrrghtthgvrhhnpeetleeifedufffhhfdtteel geeggeffhfekueevteeigfduudevudetgfegiedvjeenucevlhhushhtvghrufhiiigvpe dtnecurfgrrhgrmhepmhgrihhlfhhrohhmpehmihgthhgrvghlsehprghquhhivghrrdig hiii X-ME-Proxy: Feedback-ID: i0fe9450f:Fastmail Received: by mail.messagingengine.com (Postfix) with ESMTPA; Wed, 12 Oct 2022 01:50:14 -0400 (EDT) Date: Wed, 12 Oct 2022 14:50:11 +0900 From: Michael Paquier To: Nathan Bossart Cc: Jacob Champion , Jan Wieck , Tom Lane , Bruce Momjian , Zhihong Yu , Andrew Dunstan , Magnus Hagander , Robins Tharakan , Peter Eisentraut , "pgsql-hackers@postgresql.org" Subject: Re: pg_upgrade failing for 200+ million Large Objects Message-ID: References: <988415.1616528159@sss.pgh.pa.us> <872315a8-99fc-da4e-463d-784cfb5a025d@wi3ck.info> <1010642.1616532950@sss.pgh.pa.us> <802b96e9-f5e1-015c-dfb9-8756974b11fc@wi3ck.info> <0263bf35-05d6-02a1-519b-b7895a918314@wi3ck.info> <20220825003227.GA1456581@nathanxps13> <663393ca-b2ff-26f0-2e2d-adc942aff4fd@timescale.com> <20220908231807.GA2242918@nathanxps13> <20220908233407.GA2244644@nathanxps13> MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha512; protocol="application/pgp-signature"; boundary="Z4cvF2FQaYe+xwFT" Content-Disposition: inline In-Reply-To: <20220908233407.GA2244644@nathanxps13> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --Z4cvF2FQaYe+xwFT Content-Type: text/plain; charset=us-ascii Content-Disposition: inline Content-Transfer-Encoding: quoted-printable On Thu, Sep 08, 2022 at 04:34:07PM -0700, Nathan Bossart wrote: > On Thu, Sep 08, 2022 at 04:29:10PM -0700, Jacob Champion wrote: >> To clarify, I agree that pg_dump should contain the core fix. What I'm >> questioning is the addition of --dump-options to make use of that fix >> from pg_upgrade, since it also lets the user do "exciting" new things >> like --exclude-schema and --include-foreign-data and so on. I don't >> think we should let them do that without a good reason. >=20 > Ah, yes, I think that is a fair point. It has been more than four weeks since the last activity of this thread and there has been what looks like some feedback to me, so marked as RwF for the time being. -- Michael --Z4cvF2FQaYe+xwFT Content-Type: application/pgp-signature; name="signature.asc" -----BEGIN PGP SIGNATURE----- iQIzBAABCgAdFiEEG72nH6vTowiyblFKnvQgOdbyQH0FAmNGVZMACgkQnvQgOdby QH2Tnw//e4swOy4vifXBPeQUuQvsQmnGC1TOOde2ayS6tJLX8D/Xk0/zzilDaKZq 7dcXV00A0ADdkYsd+XI5QR4LtXTdkE40jLvYikXgBLZHk6zIV/oUBsToL/fkHoOg xy0e7hIerwRoy1Ea7zFR77x07OkDlBQyW2Z5YJVGtsx/J+aGglV5/YZyNBfu5Ctb 2wniv7CLC3HW5UgtLKr3UTd1uFNmjQl7ksczWyV1LaZDE+k+RJsA7rsIxHvxlW3n Sr3Zi+Am3oxvar/C6UOqOQ35EyYhE9tu1I9quJn1WnbToszpHl712QO+CDL6qxIq PjBNklFYgz//GxF/3CH1RPbqWwU1BCNhr0NUJftN8aJ8WqxvKwMet/dfZHji2UhM QMDS2hfA6sYITc+DvtJXl6r3Fs1ZWLxUMp2QR/3uItgtfCV97Q9dlnzFJZHL0qok 3/+5W5+rXpxg6MgTUdWV7GqowPbkB/xIScKLsjBltl0qo2vcljn/OynmxanHJOSc 0O9JNjGWqRhQ5usJf3gBRPboRirWSi1Jn45BtvnlKInqCka6ZrUgti4H01fsQRFE ItM5PG+Qgq2urH1ipLJFq7KMxJFvy7jYFbW0s2oxRWAF1sQzKYpdEPE3i0QTum/Q XRe1I9fhyHgqVzRpXJSgmTj54TyJutYpc/4/KSFSY7mFsnSZFyg= =cRii -----END PGP SIGNATURE----- --Z4cvF2FQaYe+xwFT--