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 1oGmBQ-0002ut-9b for pgsql-hackers@arkaria.postgresql.org; Wed, 27 Jul 2022 18:55:00 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1oGmBP-0007W1-43 for pgsql-hackers@arkaria.postgresql.org; Wed, 27 Jul 2022 18:54:59 +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 1oGmBO-0007Vr-O4 for pgsql-hackers@lists.postgresql.org; Wed, 27 Jul 2022 18:54:58 +0000 Received: from out5-smtp.messagingengine.com ([66.111.4.29]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1oGmBL-00052g-Hj for pgsql-hackers@postgresql.org; Wed, 27 Jul 2022 18:54:58 +0000 Received: from compute3.internal (compute3.nyi.internal [10.202.2.43]) by mailout.nyi.internal (Postfix) with ESMTP id 6BB4E5C00F1; Wed, 27 Jul 2022 14:54:52 -0400 (EDT) Received: from mailfrontend1 ([10.202.2.162]) by compute3.internal (MEProxy); Wed, 27 Jul 2022 14:54:52 -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=1658948092; x=1659034492; bh=T lIUQXHz7a2a8nJVR7iGtgSbPwgb3YAeR9U9N0F5lCg=; b=H/SvW1NHTLZO1tHGV 4VGSXCOOnNpBlGIqBuHI9uOiwQ5xbfL811EK4mtaxsSDLHgGJ8Q2R6eWnRhj/1DU TC7faHrhUshBIp6BtDpUPhT1VOmJpru9/vsVw4rIovbe5rWdjfketBONyamd+WD4 kP2qZ6KzuavLrmSKvzh5h0QzZphFyUUWW6GsAmzMWr3HlT2QvJAl/R/uFe1kQp+x 75M/WDosFJIk/+KT9NPzztb6n6Teo9RTWjRB43vgqY5NhID4YslA7ZMj+4EhfdUr 1nAUr3elbKplCEEF69Kok92v9P3WY8zFlvvwFGL/D78kSK4aQWdkYKP85BewuC6V mDE5A== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgedvfedrvdduvddgudefudcutefuodetggdotefrod ftvfcurfhrohhfihhlvgemucfhrghsthforghilhdpqfgfvfdpuffrtefokffrpgfnqfgh necuuegrihhlohhuthemuceftddtnecunecujfgurhepfffhvfevuffkgggtugfgjgesmh ekreertddtjeenucfhrhhomheptehlvhgrrhhoucfjvghrrhgvrhgruceorghlvhhhvghr rhgvsegrlhhvhhdrnhhoqdhiphdrohhrgheqnecuggftrfgrthhtvghrnhepgfegjeehle ekvefgheffudetkedtkeehgfelhfduhfevtddtteeihfefteefhfegnecuffhomhgrihhn pehgihhthhhusgdrtghomhdptghirhhruhhsqdgtihdrtghomhdpvghnthgvrhhprhhish gvuggsrdgtohhmpdhtfihithhtvghrrdgtohhmnecuvehluhhsthgvrhfuihiivgeptden ucfrrghrrghmpehmrghilhhfrhhomheprghlvhhhvghrrhgvsegrlhhvhhdrnhhoqdhiph drohhrgh X-ME-Proxy: Feedback-ID: ia2694551:Fastmail Received: by mail.messagingengine.com (Postfix) with ESMTPA; Wed, 27 Jul 2022 14:54:51 -0400 (EDT) Received: by perhan.alvh.no-ip.org (Postfix, from userid 1000) id 87525372; Wed, 27 Jul 2022 20:54:49 +0200 (CEST) Date: Wed, 27 Jul 2022 20:54:49 +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: <20220727185449.2ixbv3fe4mxuzpwk@alvherre.pgsql> MIME-Version: 1.0 Content-Type: multipart/mixed; boundary="muecx67dktuttuk3" Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: <20220720105049.jk52353p6ce35idb@alvherre.pgsql> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --muecx67dktuttuk3 Content-Type: text/plain; charset=utf-8 Content-Disposition: inline Content-Transfer-Encoding: 8bit Okay, I think I'm done with this. Here's v27 for the master branch, where I fixed some comments as well as thinkos in the test script. The ones on older branches aren't materially different, they just have tonnes of conflicts resolved. I'll get this pushed tomorrow morning. I have run it through CI and it seems ... not completely broken, at least, but I have no working recipes for Windows on branches 14 and older, so it doesn't really work fully. If anybody does, please share. You can see mine here https://github.com/alvherre/postgres/commits/REL_11_STABLE [etc] https://cirrus-ci.com/build/5320904228995072 https://cirrus-ci.com/github/alvherre/postgres -- Álvaro Herrera PostgreSQL Developer — https://www.EnterpriseDB.com/ "Every machine is a smoke machine if you operate it wrong enough." https://twitter.com/libseybieda/status/1541673325781196801 --muecx67dktuttuk3 Content-Type: text/x-diff; charset=utf-8 Content-Disposition: attachment; filename="v27-0001-Fix-replay-of-create-database-records-on-standby.patch" Content-Transfer-Encoding: 8bit