Re: postgres not deleting trigger file - Mailing list pgsql-admin

From John Scalia
Subject Re: postgres not deleting trigger file
Date
Msg-id CABzCKRDPo+po-Rdj+vVd4GcZPwvDX6e22bQTBFEUuMgk=p0vHw@mail.gmail.com
Whole thread Raw
In response to Re: postgres not deleting trigger file  (jkilborn <jim.kilborn@swri.org>)
List pgsql-admin
Well, in the past I've always had pgpool-II running as the postgres user, not root. That's probably why I didn't see any issues at the time. Good luck with this.

On Tue, Aug 4, 2015 at 8:28 AM, jkilborn <jim.kilborn@swri.org> wrote:
Thanks for the reply.

I think the problem is permissions. The fact that the pgpool runs as root
user, its likely that postgres can’t remove the created trigger file.

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’m having to do this, as I haven’t 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-deleting-trigger-file-tp5860795p5860802.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

pgsql-admin by date:

Previous
From: jkilborn
Date:
Subject: Re: postgres not deleting trigger file
Next
From: Jerry Sievers
Date:
Subject: Re: postgres not deleting trigger file