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 1tuiwy-00B2xY-FI for pgsql-hackers@arkaria.postgresql.org; Wed, 19 Mar 2025 02:14:32 +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 1tuiww-00AIsJ-Nf for pgsql-hackers@arkaria.postgresql.org; Wed, 19 Mar 2025 02:14:30 +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 1tuiww-00AIsB-9Y for pgsql-hackers@lists.postgresql.org; Wed, 19 Mar 2025 02:14:30 +0000 Received: from mail-yw1-x1135.google.com ([2607:f8b0:4864:20::1135]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1tuiws-003fup-13 for pgsql-hackers@postgresql.org; Wed, 19 Mar 2025 02:14:29 +0000 Received: by mail-yw1-x1135.google.com with SMTP id 00721157ae682-6ff4faf858cso35040117b3.2 for ; Tue, 18 Mar 2025 19:14:26 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1742350465; x=1742955265; 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=709GUqxHJcRucR1N75ezuvOfoSO9czoW/ew6jVOKK9k=; b=WtH0Xr0qZbwrZxMb0S/i0azq5jVTXU751qFCkTtdMyF2J1HvBJ/WqLBcnO9do19xnO k4Lraa+zjSAfgrNZisMy2OipMnxCHkTXd0zUXHm6HHPC7NUhnzE4OxXqAteYkbKolJHa +kmzzKOvLYVtYJ1Mr4tJMAPYiP80TScyw0xFAl6HszA1iGZGp0K9Ar1+/i/RAY/MGpdj Vyp3AH4qoG+LyTv8EXelmnitf8vpFn1QpFThRjD2F2S1AObyyIinJUWroIucAPnKDF+y fU7X/yi+u4GTc/3rVjmePY+F2Z+zw4rYdbU8EO4g+yHy8lLgrZ/wJCxUoz/bkvpguV/Z 9VXg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1742350465; x=1742955265; 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=709GUqxHJcRucR1N75ezuvOfoSO9czoW/ew6jVOKK9k=; b=vp0ULm780hABms2rURePJhxbU+986CU8o3VcAoUOu65i6Ek9TsJ7FUQMoZ7Dk04aKa 0rzUrgztqPjK37QM0ts5LxISbIKCpKAuvDPqjwlHblapomCETXw3gSw5r6QDwBpEtDmA W2J3ijV++jkLaNHc+AJ9ert4FPBTOxLqVS6r++WOgx/XBIXe56RLgjHK0fhb971yw8e2 HNdCP8fg12uyhTOhoovQqCna0bL11cWrprwIpIXXoF1MWeN6iL37lFA+eEnINDp79kMe RlDrpzeAFLuY3CSuDCZKiJNXqnezHOEkw7GgQKkh/EeTHVSkmfzKzS6FCSCoaxP4FxMp UjVg== X-Forwarded-Encrypted: i=1; AJvYcCVXBDGL5BVDJsechSiD3YGycLX2MnHCKoc/q1GOLmo5Yhs99mw2OjrhpZWxySZitleVR9X13XjNpUzk7ga2@postgresql.org X-Gm-Message-State: AOJu0YwfuZchePvQxim6Z+gJYjWNsR72lj5e8G3KGlRIR0RvMtYF8eal DUSooUHGtEo1aYykL4akJvBS8KPZYR+ogfr0Jc5WCCDWizkwi7O4 X-Gm-Gg: ASbGncuM9MoMq7gnFvXF+ZnXQK4dhcNaZW6ehyo5/2buiEJFrvFBGCZBfiEpLrupzlZ 439JuotQxF3nBvrModR0KW/ealHBYqWPj3tTmrNYslS1/iMcDpVeyLMcLmE4ZCK63VWdd3JlOfP PTSxyAUQ/RYrg8BGaYSuGPxLX/cKLbbkOhFgnKmJo2W1GKMNBAJzL7dqfT00acVTjEBgRjk+/Fz Dz5nY2c5OB44A05BYs8lf1SJro21ej0QLSXaX0qI87ylNhCy4zefze3V/LbFRTYSCZuP5760TJ1 OThaFKbUjOsuxRAicjnlAGen8PT4Ogg7wrviYuVlSMth/E45pgaaunNUx4bwvCN90DUdBLLDw9b g14lnELPof3d4NOX5L/yeW79I569eu0YvJAPE+gtA X-Google-Smtp-Source: AGHT+IFdxPZv13fLP7lEpRjdcwsGc7J1EGLsu2yX5BEObl0Id1ZGFIyl55piB2q8JdLgol+TPdVJXQ== X-Received: by 2002:a05:690c:6284:b0:6e2:1527:446b with SMTP id 00721157ae682-7009bf586c9mr17138317b3.3.1742350465251; Tue, 18 Mar 2025 19:14:25 -0700 (PDT) Received: from nathan (162-195-168-172.lightspeed.stlsmo.sbcglobal.net. [162.195.168.172]) by smtp.gmail.com with ESMTPSA id 00721157ae682-6ff3288f3e2sm28766677b3.59.2025.03.18.19.14.23 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Tue, 18 Mar 2025 19:14:24 -0700 (PDT) Date: Tue, 18 Mar 2025 21:14:22 -0500 From: Nathan Bossart To: Andres Freund Cc: Tom Lane , Robert Haas , Greg Sabino Mullane , pgsql-hackers@postgresql.org, bruce@momjian.us Subject: Re: optimize file transfer in pg_upgrade Message-ID: References: <17820.1742306681@sss.pgh.pa.us> <7rhxl5nl5cuenm4kzprjhaojo74m2teuwzjffcrdi6bxx6b2wn@orb5h3mteh2y> MIME-Version: 1.0 Content-Type: multipart/mixed; boundary="alRlLvGJpBe9wL+1" Content-Disposition: inline In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --alRlLvGJpBe9wL+1 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline On Tue, Mar 18, 2025 at 02:08:42PM -0500, Nathan Bossart wrote: > For now, here's a new version of the test with a rewritten table. I also > tried to fix the expected error regex to handle some of the other error > messages for unsupported modes (as revealed by cfbot). And here is a new version of the full patch set. -- nathan --alRlLvGJpBe9wL+1 Content-Type: text/plain; charset=us-ascii Content-Disposition: attachment; filename="v7-0001-Add-test-for-pg_upgrade-file-transfer-modes.patch"