Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1Zd2Wq-0002Sy-W4 for pgsql-pkg-yum@arkaria.postgresql.org; Fri, 18 Sep 2015 20:45:09 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84) (envelope-from ) id 1Zd2Wq-0006za-Ht for pgsql-pkg-yum@arkaria.postgresql.org; Fri, 18 Sep 2015 20:45:08 +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) (envelope-from ) id 1Zd2Wn-0006o4-1E for pgsql-pkg-yum@postgresql.org; Fri, 18 Sep 2015 20:45:05 +0000 Received: from smtp104.ord1c.emailsrvr.com ([108.166.43.104]) by magus.postgresql.org with esmtps (TLS1.0:DHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.84) (envelope-from ) id 1Zd2Wi-0002wz-Py for pgsql-pkg-yum@postgresql.org; Fri, 18 Sep 2015 20:45:04 +0000 Received: from smtp14.relay.ord1c.emailsrvr.com (localhost.localdomain [127.0.0.1]) by smtp14.relay.ord1c.emailsrvr.com (SMTP Server) with ESMTP id 98B0E3802CF; Fri, 18 Sep 2015 16:44:58 -0400 (EDT) Received: by smtp14.relay.ord1c.emailsrvr.com (Authenticated sender: jeff.frost-AT-pgexperts.com) with ESMTPSA id 50B56380286; Fri, 18 Sep 2015 16:44:58 -0400 (EDT) X-Sender-Id: jeff.frost@pgexperts.com Received: from [10.10.10.15] (8.202-62-69.ftth.swbr.surewest.net [69.62.202.8]) (using TLSv1 with cipher DHE-RSA-AES256-SHA) by 0.0.0.0:587 (trex/5.4.2); Fri, 18 Sep 2015 20:44:58 GMT Content-Type: text/plain; charset=utf-8 Mime-Version: 1.0 (Mac OS X Mail 8.2 \(2104\)) Subject: Re: init script for pgpool From: Jeff Frost In-Reply-To: <1964951442604225@web16j.yandex.ru> Date: Fri, 18 Sep 2015 13:44:57 -0700 Cc: "pgsql-pkg-yum@postgresql.org" Content-Transfer-Encoding: quoted-printable Message-Id: References: <306581442235608@web6m.yandex.ru> <280191442580051@web12h.yandex.ru> <89FABBBA-D585-4AA9-889F-962595C2DE1A@pgexperts.com> <1964951442604225@web16j.yandex.ru> To: Andrew N Golovkov X-Mailer: Apple Mail (2.2104) X-Pg-Spam-Score: -1.9 (-) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-pkg-yum Precedence: bulk Sender: pgsql-pkg-yum-owner@postgresql.org http://git.postgresql.org/gitweb/?p=3Dpgrpms.git;a=3Dblob_plain;f=3Drpm/red= hat/9.2/pgpool-II/EL-6/pgpool.init;hb=3Djf/pgpool_fixes_3 > On Sep 18, 2015, at 12:23 PM, Andrew N Golovkov wrote: >=20 > You load /etc/sysconfig/pgpool file _before_ you set variables like PGPOO= LUSER and other. > Also you set PGPOOLUSER but run commands with hardcoded `postgres' user: >> $SU -l postgres -c "$PGPOOLDAEMON -f $PGPOOLCONF $OPTS & " >> "$PGPOOLLO= G" 2>&1 < /dev/null >=20 > Please, look at my script i'v posted today. >=20 > 18.09.2015, 20:17, "Jeff Frost" : >> Nice catch! I found a couple other things as well, so here=E2=80=99s an = updated version: >>=20 >> http://git.postgresql.org/gitweb/?p=3Dpgrpms.git;a=3Dblob_plain;f=3Drpm/= redhat/9.2/pgpool-II/EL-6/pgpool.init;hb=3Djf/pgpool_fixes_3 >>=20 >> It seems to work in my vagrant, so let me know if it works for you and I= =E2=80=99ll get it merged, then the next time we build, we=E2=80=99ll have = it in the repo. >>=20 >>> On Sep 18, 2015, at 5:40 AM, Andrew N Golovkov wrote: >>>=20 >>> You forget $pidfile and $PGPOOLUSER and some more comments. >>>=20 >>> Check script in attach. I'm tested in my centos-6 and pgpool-II-92. >>> -- >>> Sent via pgsql-pkg-yum mailing list (pgsql-pkg-yum@postgresql.org) >>> To make changes to your subscription: >>> http://www.postgresql.org/mailpref/pgsql-pkg-yum >>=20 >> --- >> Jeff Frost >> CTO, PostgreSQL Experts, Inc. >> Phone: 1-888-PG-EXPRT x506 >> FAX: 415-762-5122 >> http://www.pgexperts.com/ --- Jeff Frost CTO, PostgreSQL Experts, Inc. Phone: 1-888-PG-EXPRT x506 FAX: 415-762-5122 http://www.pgexperts.com/=20 --=20 Sent via pgsql-pkg-yum mailing list (pgsql-pkg-yum@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-pkg-yum