Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1cGSlJ-0004lv-6w for pgsql-committers@arkaria.postgresql.org; Mon, 12 Dec 2016 15:43:33 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1cGSlI-0006At-KY for pgsql-committers@arkaria.postgresql.org; Mon, 12 Dec 2016 15:43:32 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1cGSl5-0005wE-ER for pgsql-committers@postgresql.org; Mon, 12 Dec 2016 15:43:19 +0000 Received: from sss.pgh.pa.us ([66.207.139.130]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1cGSl2-0001XF-3c for pgsql-committers@postgresql.org; Mon, 12 Dec 2016 15:43:18 +0000 Received: from sss1.sss.pgh.pa.us (localhost [127.0.0.1]) by sss.pgh.pa.us (8.14.4/8.14.4) with ESMTP id uBCFh0YL027275; Mon, 12 Dec 2016 10:43:01 -0500 From: Tom Lane To: Peter Eisentraut cc: pgsql-committers@postgresql.org Subject: Re: pgsql: Add support for temporary replication slots In-reply-to: References: Comments: In-reply-to Peter Eisentraut message dated "Mon, 12 Dec 2016 14:16:34 +0000" MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-ID: <27273.1481557380.1@sss.pgh.pa.us> Content-Transfer-Encoding: quoted-printable Date: Mon, 12 Dec 2016 10:43:00 -0500 Message-ID: <27274.1481557380@sss.pgh.pa.us> X-Pg-Spam-Score: -5.0 (-----) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-committers Precedence: bulk Sender: pgsql-committers-owner@postgresql.org Peter Eisentraut writes: > Add support for temporary replication slots Some of the slower buildfarm members are failing test-decoding-check since this went in. At least on prairiedog, it looks like a race condition in the test: ** /Users/buildfarm/bf-data/HEAD/pgsql.build/contrib/test_decoding/expected= /slot.out Mon Dec 12 09:24:32 2016 --- /Users/buildfarm/bf-data/HEAD/pgsql.build/contrib/test_decoding/./regre= ssion_output/results/slot.out Mon Dec 12 10:01:31 2016 *************** *** 32,38 **** =20=20 -- should fail because the temporary slot was dropped automatically SELECT pg_drop_replication_slot('regression_slot_t'); ! ERROR: replication slot "regression_slot_t" does not exist -- test switching between slots in a session SELECT 'init' FROM pg_create_logical_replication_slot('regression_slot1',= 'test_decoding', true); ?column?=20 --- 32,38 ---- =20=20 -- should fail because the temporary slot was dropped automatically SELECT pg_drop_replication_slot('regression_slot_t'); ! ERROR: replication slot "regression_slot_t" is active for PID 17615 -- test switching between slots in a session SELECT 'init' FROM pg_create_logical_replication_slot('regression_slot1',= 'test_decoding', true); ?column?=20 regards, tom lane --=20 Sent via pgsql-committers mailing list (pgsql-committers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-committers