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 1qlBVZ-001dud-4Q for pgsql-general@arkaria.postgresql.org; Tue, 26 Sep 2023 17:06:01 +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 1qlBVX-00DZbh-S7 for pgsql-general@arkaria.postgresql.org; Tue, 26 Sep 2023 17:05:59 +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 1ql7gM-00BrQ8-Ic for pgsql-general@lists.postgresql.org; Tue, 26 Sep 2023 13:00:54 +0000 Received: from mo4-p00-ob.smtp.rzone.de ([81.169.146.220]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1ql7gJ-006jrw-8L for pgsql-general@postgresql.org; Tue, 26 Sep 2023 13:00:53 +0000 ARC-Seal: i=1; a=rsa-sha256; t=1695733247; cv=none; d=strato.com; s=strato-dkim-0002; b=Qn4AoXdpaVUfxtbd/qQjvgi7PBcJS+/uVJoq8zXJwICpYkC9vtiyiN2gfsL9aVPZZd v9rIrnQQE6mUuMEJtfjYDf5aaALhsactQ4N46BAK2Uqu3igmV8eUG6ofkuErSFAl62mB U6orl+Lau5GXdam4TzSSMvcsHSLPefrf2666I3CJUmmbyfmleLFQ5IgBG3YOZlTsoLIt sl3saGqGlPXCB+VqxT21hLw6eY+G2u1CK1dDTNhE/IWHI4wBRoTcr0wc3eZyqylCP81W CR7aNdFyV5o8fLGZb7hpRKSUb/uKU28sqtfX8XZCy9OY5cYQnMVe7fhhEdBq6ZBrCWqj IgdA== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; t=1695733247; s=strato-dkim-0002; d=strato.com; h=Subject:Message-ID:To:From:Date:Cc:Date:From:Subject:Sender; bh=j/tSKHpugD6vmY2oAWek7tshyBrtDUla4pwAzosyhMk=; b=BiIhvwQJ96jXhIjvDJyMKCx4kxuyo8FV6sZBjuBHk6TlsVGhRa9o5AzHgmHifG1n8e kynMjqW3VB0Fb47ErgP1ZO+djQUgfL/+EkdCL17bHOXGEqGEss7mApTuZM9rDFRtGN1U ZepWZT5Hng1vVAXSAJg2C5ChpK9Y/u4qpFnTMr3WVzmxrrppOfUATpS2TZogT5QeLqbd sYj3hpTiYdhwn6EOYo0tLFzqol1Iv5X9iRqxP2kp3XAIPttjOT2GvzVR/PuIJ0JQmt33 FgOmI9yqgAd/kXJ2xMV8cG5GaHBMmrDCd8MG4oyu2zn7GURmi1cbaGbIJFLIiIAzhER8 8Y5Q== ARC-Authentication-Results: i=1; strato.com; arc=none; dkim=none X-RZG-CLASS-ID: mo00 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; t=1695733247; s=strato-dkim-0002; d=tuschehund.de; h=Subject:Message-ID:To:From:Date:Cc:Date:From:Subject:Sender; bh=j/tSKHpugD6vmY2oAWek7tshyBrtDUla4pwAzosyhMk=; b=X1o8b0YnAnEiRV/KZi/98TVdMQWctCmEg6MoVUOk16su/124Fx2TH/w/FYa6p986DB 4XEMP1CvNpW6D9A3ZWA10bShiV2xmKrcnzTN46L2aMli2eErqdLWAODd2GON/NUEZ85I dca3jEQY5BH6hdaxBA/xIZjz9vFO3YHgwkEhyfylt9IDW4H+MyI0BqwoCBdFF9iESR1T BTjWB3xJu1jN4kr2rY/35s7c6eo+9MS8TodudllC4MaLGCLQZT0gry1+wZzLApqLwWHJ F34Ve84F3lXnWR1a//uX4muTOZmvZlZ62uB9Iczxy8Cs3lGqk7pVotAGF9vflSV8TgC5 c6tg== DKIM-Signature: v=1; a=ed25519-sha256; c=relaxed/relaxed; t=1695733247; s=strato-dkim-0003; d=tuschehund.de; h=Subject:Message-ID:To:From:Date:Cc:Date:From:Subject:Sender; bh=j/tSKHpugD6vmY2oAWek7tshyBrtDUla4pwAzosyhMk=; b=XIoh9eFQYX3ia5OiH4DU3Fj+awrTf1gMp+d2lSoxgnHQnqKsqR6AwnTgySssoaExY6 mOQ15i2bUOtrTYzaZTBA== X-RZG-AUTH: ":PGsHfUWlW+tE6dGLopx2tLHUf2ZSPNp165/ViMXYddg/otfF87vGByLk0QyiSLBPKwS3IQ==" Received: from ox-live-app301.back.ox.d0m.de by smtp-ox.front (RZmta 49.8.2 AUTH) with ESMTPSA id L03f7cz8QD0l2Uz (using TLSv1.2 with cipher ECDHE-RSA-AES256-GCM-SHA384 (curve X9_62_prime256v1 with 256 ECDH bits, eq. 3072 bits RSA)) (Client did not present a certificate) for ; Tue, 26 Sep 2023 15:00:47 +0200 (CEST) Date: Tue, 26 Sep 2023 15:00:47 +0200 (CEST) From: pgchem pgchem To: "pgsql-general@postgresql.org" Message-ID: <850790501.593275.1695733247433@webmail.strato.de> Subject: Is the logfile the only place to find the finish LSN? MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_593274_1589615493.1695733247431" X-Priority: 3 Importance: Normal X-Mailer: Open-Xchange Mailer v7.10.6-Rev51 X-Originating-Client: open-xchange-appsuite Content-Transfer-Encoding: 7bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk ------=_Part_593274_1589615493.1695733247431 MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 7bit Hello all, according to: https://www.postgresql.org/docs/current/logical-replication-conflicts.html or https://www.postgresql.fastware.com/blog/addressing-replication-conflicts-using-alter-subscription-skip The logfile is the _only_ place to find the transaction finish LSN that must be skipped if logical replication is stuck on a conflict. Is the logfile the only place to find this information, or can it also be found somewhere inside the database, e. g. in some system catalog view? best regards Ernst-Georg ------=_Part_593274_1589615493.1695733247431 MIME-Version: 1.0 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: 7bit
Hello all,
 
according to:
 
 
or
 
 
The logfile is the _only_ place to find the transaction finish LSN that must be skipped if logical replication is stuck on a conflict. Is the logfile the only place to find this information, or can it also be found somewhere inside the database, e. g. in some system catalog view?
 
best regards
 
Ernst-Georg
------=_Part_593274_1589615493.1695733247431--