Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1ZMbdp-0005WT-5x for pgsql-admin@arkaria.postgresql.org; Tue, 04 Aug 2015 12:48:25 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84) (envelope-from ) id 1ZMbdo-0007JF-H9 for pgsql-admin@arkaria.postgresql.org; Tue, 04 Aug 2015 12:48:24 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84) (envelope-from ) id 1ZMbcC-0005K3-7E for pgsql-admin@postgresql.org; Tue, 04 Aug 2015 12:46:44 +0000 Received: from mbob.nabble.com ([162.253.133.15]) by makus.postgresql.org with esmtp (Exim 4.84) (envelope-from ) id 1ZMbc5-0002Rb-O2 for pgsql-admin@postgresql.org; Tue, 04 Aug 2015 12:46:43 +0000 Received: from msam.nabble.com (unknown [162.253.133.85]) by mbob.nabble.com (Postfix) with ESMTP id 19E7F128D7F2 for ; Tue, 4 Aug 2015 05:47:14 -0700 (PDT) Date: Tue, 4 Aug 2015 05:46:37 -0700 (MST) From: jkilborn To: pgsql-admin@postgresql.org Message-ID: <1438692397419-5860795.post@n5.nabble.com> Subject: postgres not deleting trigger file MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Pg-Spam-Score: -1.2 (-) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-admin Precedence: bulk Sender: pgsql-admin-owner@postgresql.org Im using postgres 9.4 with pgpool-II-94 and have streaming resplication setup between two db servers. When I fail the primary db, pgpool creates the /tmp/trigger_file, and the secondary server becomes the primary and is put in read/write mode. However, the trigger file doesnt get deleted. I am not sure where to debug why the trigger file doesnt get removed. I have even tried using a recover_end_command to remove the trigger file, but that doesnt seem to happen. my failover script for pgpool creates the trigger file, then set it to chmod 777 so that postgres user can remove it. pgpool runs as root, while postgres runs as postgres user. Any ideas where to look on this issue of trigger file not being removed? -- View this message in context: http://postgresql.nabble.com/postgres-not-deleting-trigger-file-tp5860795.html Sent from the PostgreSQL - admin mailing list archive at Nabble.com. -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin