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 1m4GGT-0003WO-KI for pgsql-docs@arkaria.postgresql.org; Fri, 16 Jul 2021 05:19:57 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1m4GGS-0001cv-30 for pgsql-docs@arkaria.postgresql.org; Fri, 16 Jul 2021 05:19:56 +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 1m4GGR-0001cn-Oo for pgsql-docs@lists.postgresql.org; Fri, 16 Jul 2021 05:19:55 +0000 Received: from mail-wr1-x434.google.com ([2a00:1450:4864:20::434]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1m4GGN-0004kP-RV for pgsql-docs@lists.postgresql.org; Fri, 16 Jul 2021 05:19:55 +0000 Received: by mail-wr1-x434.google.com with SMTP id t5so10563495wrw.12 for ; Thu, 15 Jul 2021 22:19:51 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=cybertec-at.20150623.gappssmtp.com; s=20150623; h=message-id:subject:from:to:date:in-reply-to:references:user-agent :mime-version:content-transfer-encoding; bh=nVSb6SQJePHEqByKGE91rpyneLBQlG/7ZgLLKwBV4Z8=; b=xkA9Jh8EbfU6KxcWQXwAGsSPTpf1iXv3MtslbvJZy1NP6HRu/kS6y7ehRD4yEl8Mit AHd0Kp5/RPli1eqT4WC6trPYaAJ4tkWE6IitldfsgfbMpYPTE0XY410cthzM9lpuZkol k4h8p1b10jXEsyIpZTU5Fsn3tm0iF0UimNN6p3Y+77LAnU85jXr57DiNg8xOpbTjcPJo 6v8ia4cFBtCQyOwHVO8xW1h4Z7VXXK1oYkJIeFlNNVyA5pO4smF7da3aQXXlveyz2L+o FIDClTLUCQHgHOymDxd0Ldv9O8jqwnQscdSeBxhgK4d6fkbmkEmM9NvI/EBZdYz4KAoQ 13JA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:message-id:subject:from:to:date:in-reply-to :references:user-agent:mime-version:content-transfer-encoding; bh=nVSb6SQJePHEqByKGE91rpyneLBQlG/7ZgLLKwBV4Z8=; b=oPM6GPRRS/EQQuKtmxgh74dEmcLZuxGBynz45NowgCyQjeEIA+aCKjMuOTAi3K1wUD y/qp4VRMbStUXmgUwcneERGjLfspILJlz7s3tKbKs+mjSBWIHtjF9cY26E1ATrsAtXBD M6h68X7hinW/NvrUyBbePSB2/CAk12cc/0tdNKHZ6IORHBfbhdzMZk951SKQfp9RM6Yg 2no2IuazsXJ+9L9lj06BA8miSdiaVP3RX9Zch107mpQ6jjcj379HUwObSpKbkROitNWp UJiIqB3SWy5FZ692vAqzQ5sXS/WXovQNL4Prdzt1jHZJbE1MjkFnmm92BR2NyPn3/Nre iq2Q== X-Gm-Message-State: AOAM5310h7pYN4mhcgfXbejzuKfhhh6gbER6jTLeDMVuMSkuC5DfJxO2 7rLkYA9mGldEDswR+7Sa1cCZ84VPUQQ2sQ== X-Google-Smtp-Source: ABdhPJzUj9t4YRWPeuRVk+9rWKZSexMNINCF3DFFJUKrDrnO5mzLn/zrmjSZzfdEx5Q7xLIv9vLYRQ== X-Received: by 2002:adf:f9cb:: with SMTP id w11mr10041503wrr.57.1626412789472; Thu, 15 Jul 2021 22:19:49 -0700 (PDT) Received: from localhost.localdomain (217-149-173-202.nat.highway.telekom.at. [217.149.173.202]) by smtp.gmail.com with ESMTPSA id s17sm8717653wrv.2.2021.07.15.22.19.48 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Thu, 15 Jul 2021 22:19:49 -0700 (PDT) Message-ID: Subject: Re: No mention of standby.signal in pg_ugprade docs From: Laurenz Albe To: Dan Stoner , pgsql-docs@lists.postgresql.org Date: Fri, 16 Jul 2021 07:19:48 +0200 In-Reply-To: <1A5A1B6E-7BB6-47EB-8443-40222B769404@iris.washington.edu> References: <1A5A1B6E-7BB6-47EB-8443-40222B769404@iris.washington.edu> Content-Type: text/plain; charset="UTF-8" User-Agent: Evolution 3.36.5 (3.36.5-2.fc32) MIME-Version: 1.0 Content-Transfer-Encoding: 7bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Thu, 2021-07-15 at 14:39 -0400, Dan Stoner wrote: > I noticed that standby.signal is not mentioned anywhere in the pg_upgrade document. > > https://www.postgresql.org/docs/13/pgupgrade.html > > I had trouble the first time I tried to start my secondary because it didn't connect to the primary / start streaming until I touched the signal > file. The signal file is obliterated during the rsync but there is no mention of putting it back or preserving it. I think you are right. I will incorporate that in my patch to improve the documentation: https://www.postgr.es/m/22f129004bb66cd91e1dfd3345a9787f5039f3ae.camel%40cybertec.at Yours, Laurenz Albe