Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1Zd2Hi-0001ZM-RT for pgsql-pkg-yum@arkaria.postgresql.org; Fri, 18 Sep 2015 20:29:31 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84) (envelope-from ) id 1Zd2Hi-0003wG-95 for pgsql-pkg-yum@arkaria.postgresql.org; Fri, 18 Sep 2015 20:29:30 +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 1Zd1GG-0002kB-Tg for pgsql-pkg-yum@postgresql.org; Fri, 18 Sep 2015 19:23:57 +0000 Received: from forward17j.cmail.yandex.net ([5.255.227.236]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84) (envelope-from ) id 1Zd1GC-0002iE-A2 for pgsql-pkg-yum@postgresql.org; Fri, 18 Sep 2015 19:23:55 +0000 Received: from web16j.yandex.ru (web16j.yandex.ru [5.45.198.57]) by forward17j.cmail.yandex.net (Yandex) with ESMTP id 1ADA6216B8; Fri, 18 Sep 2015 22:23:47 +0300 (MSK) Received: from 127.0.0.1 (localhost [127.0.0.1]) by web16j.yandex.ru (Yandex) with ESMTP id 758D13FC1C18; Fri, 18 Sep 2015 22:23:47 +0300 (MSK) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yandex.ru; s=mail; t=1442604227; bh=UpTZE8IX7vZ0p4qKhpddcHkh+OoUFmrnNSakdTLZmAw=; h=From:To:Cc:In-Reply-To:References:Subject:Date; b=JjOmxs2TvMDZsjcJIMhta4SiucFoA2yXIRjjSl6NvXAUakBL54zzajSnDZ70CMJq7 uKlZzBSK/Rol2Pvo//51qFbdckiNgQqp5itdJ1FRaQ+DAvDaZLHb+F5mVvyPJqhIeE Vy6+/RQttDx2B//ICI33lgY/WxJPhKBmsMPDXGgY= Received: by web16j.yandex.ru with HTTP; Fri, 18 Sep 2015 22:23:45 +0300 From: Andrew N Golovkov Envelope-From: andor000@yandex.ru To: Jeff Frost Cc: "pgsql-pkg-yum@postgresql.org" In-Reply-To: <89FABBBA-D585-4AA9-889F-962595C2DE1A@pgexperts.com> References: <306581442235608@web6m.yandex.ru> <280191442580051@web12h.yandex.ru> <89FABBBA-D585-4AA9-889F-962595C2DE1A@pgexperts.com> Subject: Re: init script for pgpool MIME-Version: 1.0 Message-Id: <1964951442604225@web16j.yandex.ru> X-Mailer: Yamail [ http://yandex.ru ] 5.0 Date: Fri, 18 Sep 2015 22:23:45 +0300 Content-Transfer-Encoding: 8bit Content-Type: text/plain; charset=utf-8 X-Pg-Spam-Score: -2.3 (--) 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 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" : > 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 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. >>  -- >>  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 > > --- > Jeff Frost > CTO, PostgreSQL Experts, Inc. > Phone: 1-888-PG-EXPRT x506 > FAX: 415-762-5122 > http://www.pgexperts.com/ -- 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