<div dir="ltr"><div>Hi Nozomi,<br>Thanks for the Hint. I have talked with our build team it turns out that it is a build server configuration problem. <br>Both prefix and sysconfdif are working now.<br><br></div><div>Thanks~<br>
Ning<br></div></div><div class="gmail_extra"><br><br><div class="gmail_quote">On Wed, Apr 17, 2013 at 9:17 PM, Nozomi Anzai <span dir="ltr"><<a href="mailto:anzai@sraoss.co.jp" target="_blank">anzai@sraoss.co.jp</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">Hi,<br>
<div class="im"><br>
> I know it is referencing to the /etc/pgpool.conf because if i delete the<br>
> file, pgpool will complain:<br>
> [root@se032c-94-30 ~]# mv /etc/pgpool.conf /etc/pgpool.conf.bkp<br>
> mv: overwrite `/etc/pgpool.conf.bkp'? y<br>
> [root@se032c-94-30 ~]# pgpool<br>
> pool_config: could not open configuration file (pgpool.conf)<br>
> pool_config: using default values...<br>
><br>
> I have the same sysconfdir and prefix as my configure argument.<br>
<br>
</div>I see.<br>
Could you show me the result of "pgpool --help"? It shows you the default<br>
location of conf files to which pgpool refers.<br>
<br>
----<br>
ex.) I installed pgpool with "./configure --prefix=/usr".<br>
$ bin/pgpool --help<br>
:<br>
-f, --config-file=CONFIG_FILE<br>
Sets the path to the pgpool.conf configuration file<br>
(default: /usr/etc/pgpool.conf)<br>
:<br>
<br>
*) /usr/etc/pgpool.conf doesn' t exist, but /usr/etc/pgpool.conf.sample does.<br>
----<br>
<div class="im"><br>
> Side question, do i need to have the postgresql lib and include folder<br>
> available in order to 'make' pgpool?<br>
><br>
> Here is my configure cmd:<br>
> --with-pgsql-libdir=/usr/pgsql-9.2/lib --prefix=/usr<br>
><br>
> while /usr/pgsql-9.2/lib is not available during the compile time. Will<br>
> that be an issue?<br>
<br>
</div>Yes, it will be becouse pgpool needs PostgreSQL's libralies whichever by<br>
RPM or by souce codes. If not, compaile will fail.<br>
And, you might have to install not only postgresql92 but also<br>
postgresql92-libs and postgresql92-devel, and you can use "./configure<br>
--with-pgsql=/usr/pgsql-9.2" simply.<br>
<br>
BTW, didn't you use "--sysconfdir" option?<br>
I installed with "./configure --prefix=/usr --sysconfdir=/etc/pgpool_test",<br>
and pgpool.con.sample was in /etc/pgpool_test.<br>
<br>
# cp /etc/pgpool_test/pgpool.conf.sample /etc/pgpool_test/pgpool.conf<br>
# /usr/bin/pgpool -nD<br>
2013-04-18 11:15:43 LOG: pid 28005: Backend status file /var/log/pgpool/pgpool_status discarded<br>
2013-04-18 11:15:43 LOG: pid 28005: pgpool-II successfully started. version 3.2.3 (namameboshi)<br>
:<br>
<div class="HOEnZb"><div class="h5"><br>
> Thanks~<br>
> Ning<br>
><br>
><br>
> On Tue, Apr 16, 2013 at 11:59 PM, Nozomi Anzai <<a href="mailto:anzai@sraoss.co.jp">anzai@sraoss.co.jp</a>> wrote:<br>
><br>
> > Hi,<br>
> ><br>
> > # I resend because I didn't reply to ML.<br>
> ><br>
> > > Hi Nozomi,<br>
> > > Sorry for the late reply.<br>
> > > I did not use your spec file directly but I referenced to it and it is<br>
> > > working perfectly.<br>
> > > One thing I would like to mention is that, i use the --prefix and<br>
> > > --sysconfdir, the prefix works, without problem but the syscondir does<br>
> > not.<br>
> > > I set --sysconfdir=/etc/pgpool, but it still reference to<br>
> > /etc/pgpool.conf<br>
> > > and I guess that is the default location?<br>
> > > I also verify that it did not reference to /usr/bin/etc which my<br>
> > > prefix=/usr/<br>
> ><br>
> > Is configure in your spec file like this?<br>
> ><br>
> > %configure --with-pgsql-includedir=%{_includedir}/pgsql \<br>
> > --with-pgsql-lib=%{_libdir}/pgsql \<br>
> > --disable-static --with-pam --disable-rpath \<br>
> > --sysconfdir=/etc/pgpool/ \<br>
> > --prefix=/usr/<br>
> ><br>
> > I tried rpmbuild with this, and confirmed that /etc/pgpool was created and<br>
> > that pgpool.conf was as /etc/pgpool/pgpool.conf. It seems fine.<br>
> > So, could you tell me in detail about that "it still reference<br>
> > to /etc/pgpool.conf"? How did you see it?<br>
> > # The default is /etc/pgpool-II/pgpool.conf in my spec file.<br>
> ><br>
> > > Is this expected?<br>
> > ><br>
> > > Thanks~<br>
> > > Ning<br>
> > ><br>
> > ><br>
> > > On Sun, Apr 7, 2013 at 8:19 PM, Nozomi Anzai <<a href="mailto:anzai@sraoss.co.jp">anzai@sraoss.co.jp</a>> wrote:<br>
> > ><br>
> > > > Hi,<br>
> > > ><br>
> > > > > Hi all,<br>
> > > > > Does anyone has a good rpm build process and spec file for pgpool to<br>
> > > > share?<br>
> > > ><br>
> > > > Recently I'm updating pgpool.spec for 3.2.<br>
> > > > Could you try this attached spec file?<br>
> > > ><br>
> > > ><br>
> > > > > Thanks~<br>
> > > > > Ning<br>
> > > ><br>
> > > ><br>
> > > > --<br>
> > > > Nozomi Anzai<br>
> > > > SRA OSS, Inc. Japan<br>
> > > ><br>
> > > > _______________________________________________<br>
> > > > pgpool-general mailing list<br>
> > > > <a href="mailto:pgpool-general@pgpool.net">pgpool-general@pgpool.net</a><br>
> > > > <a href="http://www.pgpool.net/mailman/listinfo/pgpool-general" target="_blank">http://www.pgpool.net/mailman/listinfo/pgpool-general</a><br>
> > > ><br>
> > > ><br>
> ><br>
> ><br>
> > --<br>
> > Nozomi Anzai<br>
> > SRA OSS, Inc. Japan<br>
> > _______________________________________________<br>
> > pgpool-general mailing list<br>
> > <a href="mailto:pgpool-general@pgpool.net">pgpool-general@pgpool.net</a><br>
> > <a href="http://www.pgpool.net/mailman/listinfo/pgpool-general" target="_blank">http://www.pgpool.net/mailman/listinfo/pgpool-general</a><br>
> ><br>
<br>
<br>
--<br>
Nozomi Anzai<br>
SRA OSS, Inc. Japan<br>
_______________________________________________<br>
pgpool-general mailing list<br>
<a href="mailto:pgpool-general@pgpool.net">pgpool-general@pgpool.net</a><br>
<a href="http://www.pgpool.net/mailman/listinfo/pgpool-general" target="_blank">http://www.pgpool.net/mailman/listinfo/pgpool-general</a><br>
</div></div></blockquote></div><br></div>