Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1gF9SW-0007mz-Hz for pgsql-admin@arkaria.postgresql.org; Wed, 24 Oct 2018 03:03:48 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1gF9SU-0005l5-NB for pgsql-admin@arkaria.postgresql.org; Wed, 24 Oct 2018 03:03:46 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1gF9ST-0005kw-VH for pgsql-admin@lists.postgresql.org; Wed, 24 Oct 2018 03:03:46 +0000 Received: from resqmta-ch2-06v.sys.comcast.net ([2001:558:fe21:29:69:252:207:38]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1gF9SQ-0000sA-AP for pgsql-admin@postgresql.org; Wed, 24 Oct 2018 03:03:44 +0000 Received: from resomta-ch2-18v.sys.comcast.net ([69.252.207.114]) by resqmta-ch2-06v.sys.comcast.net with ESMTP id F92hgA6twk1qbF9SNgIvvh; Wed, 24 Oct 2018 03:03:39 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=comcast.net; s=q20161114; t=1540350219; bh=73BbIdSn0sBpjX1+h/mMJ3DO4+a5ox9ZZjgw+jtCmmc=; h=Received:Received:Received:From:To:Subject:Date:Message-ID: MIME-Version:Content-Type; b=iVUkGw/W+G/aVaBha7vO1BG9R8X+c/t0jSakJrXwrf4hYgHiu2DMK90wDuqtWFlHv qC5Saezw7dflVpQmcSI+XnzB0GJnh8JIr5JMamSO3nGWpa8ywgiby/j6Nyl6IZ8SDx n4ndKjvVJsd5Efu8sUXnMifa119RlaBIGA8szF14JFUVMnbj85VChj64yovMfHPM91 IpHLQdGpNlkL+lHoRPyyAp2gQMmRBmnEAFtfq5gI98cMSiRMdaVjraKNkdY++wW/oy HJTE2f2xXom2SQW0ofsH5mk4wiUneK0ulVs8+G5Sr+VduJ5FJPc+LZ0J8HQgVHqJAu k5iSjccPvFLyA== Received: from jsievers.comcast.net ([12.187.116.132]) by resomta-ch2-18v.sys.comcast.net with ESMTPA id F9SBgNyX1aBerF9SCgFYO0; Wed, 24 Oct 2018 03:03:37 +0000 Received: from jsievers.enova.com (localhost [127.0.0.1]) by jsievers.comcast.net (Postfix) with ESMTP id A4B21260056; Tue, 23 Oct 2018 22:03:27 -0500 (CDT) From: Jerry Sievers To: Julien Riou Cc: Jerry Sievers , "pgsql-admin\@postgresql.org" Subject: Re: No Known Snapshots error w/pg_recvlogical and wal2json plugin... References: <87mur4pilj.fsf@jsievers.enova.com> Date: Tue, 23 Oct 2018 22:03:27 -0500 In-Reply-To: (Julien Riou's message of "Wed, 24 Oct 2018 02:48:20 +0000") Message-ID: <87va5syrk0.fsf@jsievers.enova.com> User-Agent: Gnus/5.13 (Gnus v5.13) Emacs/25.1 (gnu/linux) MIME-Version: 1.0 Content-Type: text/plain X-CMAE-Envelope: MS4wfEUWkpS9UTgLwyd9yodFmCKyRBfGjLZNm3A3RuNqkxk+8XzL8MAfytIM6kM21RFY7M4HWX6jErQpvi0ESLbBb7NfYXgxxrUQCA8OZLCv2KecmWlICpb+ xVVXKgBZxfW2NcD/evA+sCa6z+QWDcQ93Sepz2MKhqGcJBclFScY5c643wOkhjz5enopBO4neau0OAGAsNOeGiLYX6lTsPLjm6yBa/yyRk5V/SuFdOX2SQLo 5Cyni2uDjPQCzyrGeFUn/dOnDsyonisuS8TKvlqL/6Y= List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk Julien Riou writes: > On October 23, 2018 9:29:28 PM GMT+02:00, Jerry Sievers wrote: > >>Admins, just curious if anyone's seen this running something like the >>combo in $subject, or has any insight whatsoever. >> >>I find the error message in the src file seen later but not had time to >>snapshots"); > > Hello, > > This is a wal2json issue I've encountered too: https://github.com/eulerto/wal2json/issues/74 Yup, thanks! I went and flipped the include-unchanged-toast option to false soon after posting this and problem went away at least for the system I was testing with. -- Jerry Sievers Postgres DBA/Development Consulting e: postgres.consulting@comcast.net p: 312.241.7800