Re: init script for pgpool

From: Jeff Frost <jeff(at)pgexperts(dot)com>
To: Andrew N Golovkov <andor000(at)ya(dot)ru>
Cc: "pgsql-pkg-yum(at)postgresql(dot)org" <pgsql-pkg-yum(at)postgresql(dot)org>
Subject: Re: init script for pgpool
Date: 2015-09-18 20:44:57
Message-ID: FD559878-19B3-4E6C-B944-FC8069FBDE27@pgexperts.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-pkg-yum

http://git.postgresql.org/gitweb/?p=pgrpms.git;a=blob_plain;f=rpm/redhat/9.2/pgpool-II/EL-6/pgpool.init;hb=jf/pgpool_fixes_3

> On Sep 18, 2015, at 12:23 PM, Andrew N Golovkov <andor000(at)ya(dot)ru> wrote:
>
> You load /etc/sysconfig/pgpool file _before_ you set variables like PGPOOLUSER and other.
> Also you set PGPOOLUSER but run commands with hardcoded `postgres' user:
>> $SU -l postgres -c "$PGPOOLDAEMON -f $PGPOOLCONF $OPTS & " >> "$PGPOOLLOG" 2>&1 < /dev/null
>
> Please, look at my script i'v posted today.
>
> 18.09.2015, 20:17, "Jeff Frost" <jeff(at)pgexperts(dot)com>:
>> Nice catch! I found a couple other things as well, so here’s an updated version:
>>
>> http://git.postgresql.org/gitweb/?p=pgrpms.git;a=blob_plain;f=rpm/redhat/9.2/pgpool-II/EL-6/pgpool.init;hb=jf/pgpool_fixes_3
>>
>> It seems to work in my vagrant, so let me know if it works for you and I’ll get it merged, then the next time we build, we’ll have it in the repo.
>>
>>> On Sep 18, 2015, at 5:40 AM, Andrew N Golovkov <andor000(at)ya(dot)ru> wrote:
>>>
>>> You forget $pidfile and $PGPOOLUSER and some more comments.
>>>
>>> Check script in attach. I'm tested in my centos-6 and pgpool-II-92.<pgpool.init>
>>> --
>>> Sent via pgsql-pkg-yum mailing list (pgsql-pkg-yum(at)postgresql(dot)org)
>>> To make changes to your subscription:
>>> http://www.postgresql.org/mailpref/pgsql-pkg-yum
>>
>> ---
>> Jeff Frost <jeff(at)pgexperts(dot)com>
>> CTO, PostgreSQL Experts, Inc.
>> Phone: 1-888-PG-EXPRT x506
>> FAX: 415-762-5122
>> http://www.pgexperts.com/

---
Jeff Frost <jeff(at)pgexperts(dot)com>
CTO, PostgreSQL Experts, Inc.
Phone: 1-888-PG-EXPRT x506
FAX: 415-762-5122
http://www.pgexperts.com/

In response to

Responses

Browse pgsql-pkg-yum by date

  From Date Subject
Next Message Andrew N Golovkov 2015-09-18 21:46:06 Re: init script for pgpool
Previous Message Andrew N Golovkov 2015-09-18 19:23:45 Re: init script for pgpool