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 1oFrue-00050j-P1 for pgsql-hackers@arkaria.postgresql.org; Mon, 25 Jul 2022 06:49:56 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1oFrud-000888-9P for pgsql-hackers@arkaria.postgresql.org; Mon, 25 Jul 2022 06:49:55 +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 1oFruc-00087z-QF for pgsql-hackers@lists.postgresql.org; Mon, 25 Jul 2022 06:49:54 +0000 Received: from mail-lj1-x22f.google.com ([2a00:1450:4864:20::22f]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1oFrua-0000F6-CL for pgsql-hackers@lists.postgresql.org; Mon, 25 Jul 2022 06:49:53 +0000 Received: by mail-lj1-x22f.google.com with SMTP id w18so944428lje.1 for ; Sun, 24 Jul 2022 23:49:52 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20210112; h=mime-version:references:in-reply-to:from:date:message-id:subject:to :cc:content-transfer-encoding; bh=+MI169gX8/PqUT7VPHM08p8FIQUK0gCAtcwGeKHlTQA=; b=TgoDUJgLQaW7573UzNsuzfE726gnVLQq4madGKKzlU1U7iOIEPWVM1Q7Jzv8Z/iDnA YEUXJUmVUtdMjtRn+iA4195IYMc5vuBcDkvB91TYmX8JE/WU6l1YSlSIpwGkbeX1VXWn BvZXG9XRdl4/kIGpYqaA5Sn/Yq1q34gqzQNXH2HxlV/qpoElX6SpLNYzOEwnbld0G2gr OZ2uVtakn+Sn5s/ALSjQGMYk4WSI7bE1oqHtnaq43Os6H3dXGtBF2YKff9rOmnCM4YzE wGHdcAKihQYXgb5308NPFz/Z4f3w0AK4jt1kRzhtdUFxNOtolXiroHBLJ4SMZpcLDkv6 w4QQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; h=x-gm-message-state:mime-version:references:in-reply-to:from:date :message-id:subject:to:cc:content-transfer-encoding; bh=+MI169gX8/PqUT7VPHM08p8FIQUK0gCAtcwGeKHlTQA=; b=dRGIAhpMtbxAFd7XDzz14hE1Ym3lmJM9Um1QcquPRNO7XBVU95EGhsTF2dvJz/pS+V iXv9BpsyTjdQztkCvSGSDVOvruVIhEemaNvSzqx7z74cMRd83QV7O9R4Vqylcf6rnEx2 vgpQ6xrQrAKxjaDlJYeHCg3uf3qB8hn+R7vbBS4lSbhk8uZszp39LslGu8R54PNz/LrO jNaiFlmAYnkfz9d1xviuVLmpz5Ap8NDtv9J2muZur2tiNYFVmRP4btV3+iEYnZolM4QU aMLyb3J/dvyFffzkReoYUmBMQTnXsppz/HCOnm4ILxlK4fKG5BCCwd1A23yXXK1duWRF tYIg== X-Gm-Message-State: AJIora+tfiDcWZBlSVcouPejA9G6lDj2zkCE0QfzdmmWJgNVql81z+f2 nyXL25FTwIwdqGyp9r3TbKV2yPoHxFe/rY+umTo/bo4Z7RM= X-Google-Smtp-Source: AGRyM1uH7uMOjcoulmfayyGLYmXENY6d89PVTKLGJvPVGA6hfoXA0PujT0D8Kn2etdn/h7jnMlghnhtbRjjRixw15b4= X-Received: by 2002:a2e:a4a5:0:b0:25d:980f:8ba7 with SMTP id g5-20020a2ea4a5000000b0025d980f8ba7mr3992770ljm.513.1658731790732; Sun, 24 Jul 2022 23:49:50 -0700 (PDT) MIME-Version: 1.0 References: <165852348876.1168.5615622255167011778.pgcf@coridan.postgresql.org> In-Reply-To: <165852348876.1168.5615622255167011778.pgcf@coridan.postgresql.org> From: Bharath Rupireddy Date: Mon, 25 Jul 2022 12:19:40 +0530 Message-ID: Subject: Re: Add last failed connection error message to pg_stat_wal_receiver To: Cary Huang Cc: PostgreSQL Hackers Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Sat, Jul 23, 2022 at 2:29 AM Cary Huang wrote: > > The following review has been posted through the commitfest application: > make installcheck-world: tested, passed > Implements feature: tested, passed > Spec compliant: tested, passed > Documentation: tested, passed > > Hello > > The patch can be applied to PG master branch without problem and it passe= d regression and tap tests. I manually tested this feature too and the last= conn error is correctly shown in the pg_stat_get_wal_receiver output, whic= h does exactly as described. I think this feature is nice to have to troubl= eshoot replication issues on the standby side. Thanks a lot Cary for reviewing. It will be great if you can add yourself as a reviewer and set the status accordingly in the CF entry here - https://commitfest.postgresql.org/38/3666/. Regards, Bharath Rupireddy.