Date: Tue, 4 Aug 2015 06:28:47 -0700 (MST)
From: jkilborn <jim.kilborn@swri.org>
To: pgsql-admin@postgresql.org
Message-ID: <1438694927835-5860802.post@n5.nabble.com>
In-Reply-To: 
 <CABzCKRC=yFbM0rwvBWBaF+ePunHcwhgK7F3tAeppKES-nLAyaA@mail.gmail.com>
References: <1438692397419-5860795.post@n5.nabble.com>
 <CABzCKRC=yFbM0rwvBWBaF+ePunHcwhgK7F3tAeppKES-nLAyaA@mail.gmail.com>
Subject: Re: postgres not deleting trigger file
MIME-Version: 1.0
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: quoted-printable
Precedence: bulk
Sender: pgsql-admin-owner@postgresql.org

Thanks for the reply.=20

I think the problem is permissions. The fact that the pgpool runs as root
user, its likely that postgres can=E2=80=99t remove the created trigger fil=
e.

I ended up doing two things in my pgp failover_stream.sh script, which
creates the file:
/bin/ssh -T $new_master /bin/touch $trigger_file
	/bin/ssh -T $new_master chown postgres $trigger_file

Seems with changing the ownership of the trigger file, postgres can now
delete the file. Not sure why I=E2=80=99m having to do this, as I haven=E2=
=80=99t seen
anyone else encounter this issue.

Anyway, with these changes, it appears to be working correctly.

Thanks for the response.

-Jim


--
View this message in context: http://postgresql.nabble.com/postgres-not-del=
eting-trigger-file-tp5860795p5860802.html
Sent from the PostgreSQL - admin mailing list archive at Nabble.com.


--=20
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin