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 1oEUBq-00023Y-3w for pgsql-hackers@arkaria.postgresql.org; Thu, 21 Jul 2022 11:17:58 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1oEUBp-0008Ns-07 for pgsql-hackers@arkaria.postgresql.org; Thu, 21 Jul 2022 11:17:57 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1oEUBo-0008Nj-NT for pgsql-hackers@lists.postgresql.org; Thu, 21 Jul 2022 11:17:56 +0000 Received: from out3-smtp.messagingengine.com ([66.111.4.27]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1oEUBm-00088H-CT for pgsql-hackers@postgresql.org; Thu, 21 Jul 2022 11:17:55 +0000 Received: from compute2.internal (compute2.nyi.internal [10.202.2.46]) by mailout.nyi.internal (Postfix) with ESMTP id CA88C5C00A4; Thu, 21 Jul 2022 07:17:53 -0400 (EDT) Received: from mailfrontend1 ([10.202.2.162]) by compute2.internal (MEProxy); Thu, 21 Jul 2022 07:17:53 -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=1658402273; x=1658488673; bh=p l0tywhFymylKbQxPISWASzWw8zlVPngyRth0kXuJTk=; b=s4+n7OiqS3IjVuLZU wPAO7GbVaQZ6NtH+maWcuhAFtsLxSsGlIV6nxEHoRzBRSHqnD2XJtE/HCpJ9FRVI SOvKFRDW3mJG9qXritCWK3TlmPt/9X4GZ/IOs4O/mG8Um9UvPVayXpbqZLE9Y53Q 9kvSrwWaJIMUSk/wMe9N2Fo8U5jR9fXuHZ0YgtFQyk4e6BzClyBynNR2O5yQ4wlB 8Bkpb4Is7yHhUetE99QoQW+wSIWjdrAlA6Qy1s8fzS+AdaCNsSrdAwnyT26ZSOFn CQUwvbi9UjmwAfN47u0XRnmm2o21zu2W68aol8GDQzxWJEyEXDqeVi+f/KRtKhWn CieCQ== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgedvfedrudelledggedtucetufdoteggodetrfdotf fvucfrrhhofhhilhgvmecuhfgrshhtofgrihhlpdfqfgfvpdfurfetoffkrfgpnffqhgen uceurghilhhouhhtmecufedttdenucesvcftvggtihhpihgvnhhtshculddquddttddmne cujfgurhepfffhvfevuffkgggtugfgjgesthekredttddtjeenucfhrhhomheptehlvhgr rhhoucfjvghrrhgvrhgruceorghlvhhhvghrrhgvsegrlhhvhhdrnhhoqdhiphdrohhrgh eqnecuggftrfgrthhtvghrnhepkedthfekveduuefgueelteekgfejgeekueduudeuveeu vddufffggfetiefhvdefnecuffhomhgrihhnpehpohhsthhgrhgvshhqlhdrohhrghdpvg hnthgvrhhprhhishgvuggsrdgtohhmnecuvehluhhsthgvrhfuihiivgeptdenucfrrghr rghmpehmrghilhhfrhhomheprghlvhhhvghrrhgvsegrlhhvhhdrnhhoqdhiphdrohhrgh X-ME-Proxy: Feedback-ID: ia2694551:Fastmail Received: by mail.messagingengine.com (Postfix) with ESMTPA; Thu, 21 Jul 2022 07:17:53 -0400 (EDT) Received: by perhan.alvh.no-ip.org (Postfix, from userid 1000) id 910B8369; Thu, 21 Jul 2022 13:17:51 +0200 (CEST) Date: Thu, 21 Jul 2022 13:17:51 +0200 From: Alvaro Herrera To: Thomas Munro Cc: Kyotaro Horiguchi , Dilip Kumar , Robert Haas , Michael Paquier , Julien Rouhaud , pgsql-hackers Subject: Re: standby recovery fails (tablespace related) (tentative patch and discussion) Message-ID: <20220721111751.x7hod2xgrd76xr5c@alvherre.pgsql> MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On 2022-Jul-21, Thomas Munro wrote: > On Wed, Jul 20, 2022 at 10:51 PM Alvaro Herrera wrote: > > v26 here. I spent some time fighting the readdir() stuff for > > Windows (so that get_dirent_type returns LNK for junction points) > > but couldn't make it to work and was unable to figure out why. > > Was it because of this? > > https://www.postgresql.org/message-id/CA%2BhUKGKv%2B736Pc8kSj3%3DDijDGd1eC79-uT3Vi16n7jYkcc_raw%40mail.gmail.com Oh, that sounds very likely, yeah. I didn't think of testing the FILE_ATTRIBUTE_DIRECTORY bit for junction points. I +1 pushing both of these patches to 14. Then this patch becomes a couple of lines shorter. -- Álvaro Herrera PostgreSQL Developer — https://www.EnterpriseDB.com/ "Before you were born your parents weren't as boring as they are now. They got that way paying your bills, cleaning up your room and listening to you tell them how idealistic you are." -- Charles J. Sykes' advice to teenagers