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 1oBfSy-0006Fv-SC for pgsql-hackers@arkaria.postgresql.org; Wed, 13 Jul 2022 16:44:01 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1oBfSw-0005E7-NY for pgsql-hackers@arkaria.postgresql.org; Wed, 13 Jul 2022 16:43:58 +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 1oBfSw-0005Ds-Bo for pgsql-hackers@lists.postgresql.org; Wed, 13 Jul 2022 16:43:58 +0000 Received: from out3-smtp.messagingengine.com ([66.111.4.27]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1oBfSo-0007rg-SM for pgsql-hackers@postgresql.org; Wed, 13 Jul 2022 16:43:57 +0000 Received: from compute2.internal (compute2.nyi.internal [10.202.2.46]) by mailout.nyi.internal (Postfix) with ESMTP id 826D65C0165; Wed, 13 Jul 2022 12:43:49 -0400 (EDT) Received: from mailfrontend1 ([10.202.2.162]) by compute2.internal (MEProxy); Wed, 13 Jul 2022 12:43:49 -0400 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:cc:content-transfer-encoding :content-type:date:date:feedback-id:feedback-id:from:from :in-reply-to:in-reply-to:message-id:mime-version: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=1657730629; x=1657817029; bh=x QRZEzyYU1UzPAS6me3yWv/ajxY61wI9HNtPW5G3d2g=; b=pAt2fiAYnZEXUYD7p l5TcKG+yUoJzR/solm2RL8aZV/LgIozwKPw6rcM6MOcsiLGPSem2rIcNl9SO5tcz 1vcL8BCXlUOF6EHNZjSUrUQ0FEx8nSdkuZVBvPrFLItZaPytq1jf4ywkOBqielB+ 4e4JTR1/A7d6QJtC/QlJwW4ndnjuqCTZ8VEqZp1E8HaQb+g9auFFvoiQdS1Fn9Tv gB7Rohtv/+uqdZM4wv+8+g0Ko++7wpHZBpiuBj7KXU7GLdbsle5R26A9xX/fw2zV U9TSG0cfnoqJfsvgXeyoE8pJIAU20VSue4+XN5lGsgO5QVCV7vSWXFzj4TnxwDEZ ev5IA== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgedvfedrudejjedguddtgecutefuodetggdotefrod ftvfcurfhrohhfihhlvgemucfhrghsthforghilhdpqfgfvfdpuffrtefokffrpgfnqfgh necuuegrihhlohhuthemuceftddtnecunecujfgurhepfffhvfevuffkgggtugfgjgesmh ekreertddtjeenucfhrhhomheptehlvhgrrhhoucfjvghrrhgvrhgruceorghlvhhhvghr rhgvsegrlhhvhhdrnhhoqdhiphdrohhrgheqnecuggftrfgrthhtvghrnhepudelkeekgf dttdettdekgfduvdeiffelteegjeeihfetheekveeftedtuddvhfeunecuffhomhgrihhn pegvnhhtvghrphhrihhsvggusgdrtghomhenucevlhhushhtvghrufhiiigvpedtnecurf grrhgrmhepmhgrihhlfhhrohhmpegrlhhvhhgvrhhrvgesrghlvhhhrdhnohdqihhprdho rhhg X-ME-Proxy: Feedback-ID: ia2694551:Fastmail Received: by mail.messagingengine.com (Postfix) with ESMTPA; Wed, 13 Jul 2022 12:43:48 -0400 (EDT) Received: by perhan.alvh.no-ip.org (Postfix, from userid 1000) id EF7BB36E; Wed, 13 Jul 2022 18:43:45 +0200 (CEST) Date: Wed, 13 Jul 2022 18:43:45 +0200 From: Alvaro Herrera To: Kyotaro Horiguchi Cc: dilipbalaut@gmail.com, robertmhaas@gmail.com, michael@paquier.xyz, rjuju123@gmail.com, pgsql-hackers@postgresql.org Subject: Re: standby recovery fails (tablespace related) (tentative patch and discussion) Message-ID: <20220713164345.j3n67rc45rpa4vop@alvherre.pgsql> MIME-Version: 1.0 Content-Type: multipart/mixed; boundary="fjxxjvhdbrq5f7rb" Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: <20220405.171857.1673205520427411283.horikyota.ntt@gmail.com> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --fjxxjvhdbrq5f7rb Content-Type: text/plain; charset=utf-8 Content-Disposition: inline Content-Transfer-Encoding: 8bit Not a review, just a preparatory rebase across some trivially conflicting changes. I also noticed that src/test/recovery/t/031_recovery_conflict.pl, which was added two days after v23 was sent, and which uses allow_in_place_tablespaces, bails out because of the checks introduced by this patch, so I made the check routine do nothing in that case. Anyway, here's v24. -- Álvaro Herrera Breisgau, Deutschland — https://www.EnterpriseDB.com/ "La conclusión que podemos sacar de esos estudios es que no podemos sacar ninguna conclusión de ellos" (Tanenbaum) --fjxxjvhdbrq5f7rb Content-Type: text/x-diff; charset=us-ascii Content-Disposition: attachment; filename="v24-0001-Fix-replay-of-create-database-records-on-standby.patch"