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 1qyN3h-007vpM-Vl for pgsql-hackers@arkaria.postgresql.org; Thu, 02 Nov 2023 02:03:45 +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 1qyN3g-00AIGI-0D for pgsql-hackers@arkaria.postgresql.org; Thu, 02 Nov 2023 02:03:44 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qyN3f-00AIGA-N6 for pgsql-hackers@lists.postgresql.org; Thu, 02 Nov 2023 02:03:43 +0000 Received: from mail-pf1-x433.google.com ([2607:f8b0:4864:20::433]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1qyN3b-003X8y-FM for pgsql-hackers@lists.postgresql.org; Thu, 02 Nov 2023 02:03:42 +0000 Received: by mail-pf1-x433.google.com with SMTP id d2e1a72fcca58-6c320a8ac5aso313311b3a.0 for ; Wed, 01 Nov 2023 19:03:39 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1698890618; x=1699495418; darn=lists.postgresql.org; h=content-transfer-encoding:mime-version:user-agent:references :in-reply-to:from:subject:cc:to:message-id:date:from:to:cc:subject :date:message-id:reply-to; bh=0CcmXHCCKgIFXdZ+VTRfL0itbTLb91j81VBeAf1PHsI=; b=dlpysGCG79oFpvKbFEfivyE1LlpV2u+aYsJCeYMLzvfah95y/lmIm39KU0hsZj2ae/ 6N2HHwdOK9Aq1pqaynjThi3F7QMKvlcwPmxH2T0WEh5N4DVkiqjTwGG3nVNOCKxpggeM 9ZiLxwFyqI7jI+o475jopMuUoPm0Skij32BBKLxHGGMoxcL4D9HJYBNltIlOuKn2mGrg qjz9gxOsoS5+oUaXrNbj6vOAggXyvZ0m1dxFfv4JrCxGaiTLF0pZiECdFZBFoX+g3F7F WFoNNLxf86lNei29TtQqyDIZWIenOPh5Qy3VvVtP5QjvCoD09fNUgs2OuDKhw6xHVdiD 7poA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1698890618; x=1699495418; h=content-transfer-encoding:mime-version:user-agent:references :in-reply-to:from:subject:cc:to:message-id:date:x-gm-message-state :from:to:cc:subject:date:message-id:reply-to; bh=0CcmXHCCKgIFXdZ+VTRfL0itbTLb91j81VBeAf1PHsI=; b=HR9Uz5U/7l9QSJ4orCAzM1FwAnoUoOe1l0adsXwnrpmS/tp2H6E2u5CztMKgH/5sfe FHq8+jXHbfNOJ8CZM13kGkOubSaGEMk5jA9QUyYQeI/pthaxjmi8Jv8GS/NFdrGHRwyv r71oQfzsK1A40QduAxadugmqdeLx6n5JR0qGxpEt5nIe4jdnbRJGsRIltLg5iUAvtV9n c75Ub7+ZxbUVhbZx5dY7HNAu6dBUAF2y2xVtW9A0eTcEe2o/tncMSsKOhD5yNpv4AhWN xMBQj5KxIIYN+NdbGsV8Tg0MHIGslU4nwgt7mQjWuiZMFIFG792wQo+P45tVl8mxSSJP JrAw== X-Gm-Message-State: AOJu0Yxn1cbjyNaf7fE6rejUsxbMrIsGjaaCqSEmJSEruNpO4hj+4rZ7 NQZM4x+S/mNIcD1ROuTXgoE= X-Google-Smtp-Source: AGHT+IFmijWKzplFEUfSYDWqc3JJSnM3EiMD/zXHN/EPPElP1j2WEPNUZO1FIL9G+4HMNEPnhRKWKw== X-Received: by 2002:a05:6a00:2284:b0:6be:5367:2131 with SMTP id f4-20020a056a00228400b006be53672131mr17377652pfe.24.1698890618304; Wed, 01 Nov 2023 19:03:38 -0700 (PDT) Received: from localhost (KD036014041111.ppp-bb.dion.ne.jp. [36.14.41.111]) by smtp.gmail.com with ESMTPSA id d21-20020aa78695000000b006c148c6767bsm1790148pfo.218.2023.11.01.19.03.36 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Wed, 01 Nov 2023 19:03:37 -0700 (PDT) Date: Thu, 02 Nov 2023 11:03:35 +0900 (JST) Message-Id: <20231102.110335.1808777803530400869.horikyota.ntt@gmail.com> To: michael@paquier.xyz Cc: robertmhaas@gmail.com, david@pgmasters.net, pgsql-hackers@lists.postgresql.org, zxwsbg12138@gmail.com, david.zhang@highgo.ca, andres@anarazel.de Subject: Re: Requiring recovery.signal or standby.signal when recovering with a backup_label From: Kyotaro Horiguchi In-Reply-To: References: User-Agent: Mew version 6.8 on Emacs 27.2 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 Wed, 1 Nov 2023 08:39:17 +0900, Michael Paquier wrote in > See in StartupXLOG(), around the comment "complain if we did not roll > forward far enough to reach". This complains if archive recovery has > been requested *or* if we retrieved a backup end LSN from the > backup_label. Please note that backupStartPoint is not reset even when reaching the backup end point during crash recovery. If backup_label enforces archive recovery, I think this point won't be an issue as you mentioned. For the record, my earlier proposal aimed to detect reaching the end point even during crash recovery. regards. -- Kyotaro Horiguchi NTT Open Source Software Center