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 1nbIUF-0008CF-7o for pgsql-hackers@arkaria.postgresql.org; Mon, 04 Apr 2022 08:54:59 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1nbIUE-0001Re-4Q for pgsql-hackers@arkaria.postgresql.org; Mon, 04 Apr 2022 08:54: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 1nbIUD-0001RT-Pi for pgsql-hackers@lists.postgresql.org; Mon, 04 Apr 2022 08:54:57 +0000 Received: from mail-pg1-x52a.google.com ([2607:f8b0:4864:20::52a]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1nbIUB-0004BK-ND for pgsql-hackers@postgresql.org; Mon, 04 Apr 2022 08:54:57 +0000 Received: by mail-pg1-x52a.google.com with SMTP id c11so7778015pgu.11 for ; Mon, 04 Apr 2022 01:54:55 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20210112; h=date:message-id:to:cc:subject:from:in-reply-to:references :user-agent:mime-version:content-transfer-encoding; bh=IGdY8AWx+3a6HwHG1ckNHi8daVc1RK7AiLXR2cTYXe8=; b=LiumBxUAPQQ9vBAjseDn+6/Hdxq3h3eMfK9Nla7FbeuB7A69Bh9lWtn3ZdkEzInLLP oAOutNBL1boqthiQNspqxxaQAAO0ib1Q+XBEzjkGK9jevPJe1l0liDP8nxqAR+ezH73z 3lTaY+qawbYtq9YLr6q1+/41+LTIMQaYNs9r+RcbqA+OxmLyY3M+zwdfYHzOkdVgulqR 46/8ZRPIXk/ev74jVycYy9/YTR5lNELqO1xZgy3vzUh45S0QOQbRP3Mnz+tOLbxS8rAd q0wwg8F8WznaOqf6pmjikCwDxWUUQOn1kdSmuyyMncWxvsIyAKKs5tLHEAWF1/cVBD8z t5+A== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; h=x-gm-message-state:date:message-id:to:cc:subject:from:in-reply-to :references:user-agent:mime-version:content-transfer-encoding; bh=IGdY8AWx+3a6HwHG1ckNHi8daVc1RK7AiLXR2cTYXe8=; b=lXmofFWh0kF2ZTg+2FcZe5wN4K376t8qdTYU4bOn/mBY4cyqBvk7cXXRcJteQkrQR4 n6wfdr67LGXCCVD24kdZOoHsYhgczeeait6gZhbMJ1zJQJOhL23st5ou3STV/Iv/rrKh yA+GfzX0lQ19FrHPqcAGeK67zUuPleDBButB6yEK4aBUaOSZtq4k42zZU4g1uvKl+6tR a76xX7M4yYRBF0rSJLhipHvG4yp7a7h/V9Qy1aUqCLD0BlFOfnB+ZpZS7Jgemnre5+08 uI/LwlaFZ8FtN587fa60ci+WQxdqW3gvzRPGXI3mxRAalKj1yGOr70IRG5h0tOIDj+bZ xUhg== X-Gm-Message-State: AOAM532p3KZFS7u7GIsFE53uULufdhev5JIDFj51Ih54NTCMFoMhU/wk 04BUUieUl4sTVi+KYixlIAw= X-Google-Smtp-Source: ABdhPJx+FuSaRkbBidzz/3bUZzTyk1euFsDJJikd8JqF5dAOAhWJLwOfcSgK5rzNy1t9lD53H6JMWg== X-Received: by 2002:a65:490c:0:b0:382:692a:b1fa with SMTP id p12-20020a65490c000000b00382692ab1famr25712320pgs.150.1649062493425; Mon, 04 Apr 2022 01:54:53 -0700 (PDT) Received: from localhost (KD036014041111.ppp-bb.dion.ne.jp. [36.14.41.111]) by smtp.gmail.com with ESMTPSA id g15-20020a63be4f000000b0039934531e95sm1636819pgo.18.2022.04.04.01.54.51 (version=TLS1_3 cipher=TLS_CHACHA20_POLY1305_SHA256 bits=256/256); Mon, 04 Apr 2022 01:54:52 -0700 (PDT) Date: Mon, 04 Apr 2022 17:54:49 +0900 (JST) Message-Id: <20220404.175449.837744764428020019.horikyota.ntt@gmail.com> To: robertmhaas@gmail.com Cc: alvherre@alvh.no-ip.org, michael@paquier.xyz, rjuju123@gmail.com, pgsql-hackers@postgresql.org Subject: Re: standby recovery fails (tablespace related) (tentative patch and discussion) From: Kyotaro Horiguchi In-Reply-To: <20220404.172948.678193664696814690.horikyota.ntt@gmail.com> References: <20220401.132157.1998467224568735059.horikyota.ntt@gmail.com> <20220404.172948.678193664696814690.horikyota.ntt@gmail.com> User-Agent: Mew version 6.8 on Emacs 26.1 Mime-Version: 1.0 Content-Type: Text/Plain; charset=us-ascii Content-Transfer-Encoding: 7bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk At Mon, 04 Apr 2022 17:29:48 +0900 (JST), Kyotaro Horiguchi wrote in > I haven't found how the patch caused creation of a relation file that > is to be removed soon. However, I find that v19 patch fails by maybe > due to some change in Cluster.pm. It takes a bit more time to check > that.. I was a bit away, of course the wal-logged create database interfares with the patch here. But I haven't found that why it stops creating database directory under pg_tblspc. regards. -- Kyotaro Horiguchi NTT Open Source Software Center