<div dir="ltr"><div><div><div><div>Hi Tatsuo,<br>I will try your latest pkg on Monday.<br>Meanwhile, I try on my other machine which I cannot reproduce the problem.<br></div>The difference is that, one the working machine, I compile, make, and make install pgpool on the system; while on the non working server, I create the rpm from a build machine.<br>
</div>I obtained the spec file from you previously, and I see that your ./configure command has the following:<br><br>%configure --with-pgsql-includedir=%{_includedir}/pgsql \<br> --with-pgsql-lib=%{_libdir}/pgsql \<br>
--disable-static --with-pam --disable-rpath \<br> --sysconfdir=%{_sysconfdir}/%{name}/<br><br></div>While in my build environment, the pgsql include folder and pgsql lib folder are not available, do I really need the folder for the ./configure command?<br>
<br>Thanks~<br></div>Ning<br></div><div class="gmail_extra"><br><br><div class="gmail_quote">On Sat, Apr 13, 2013 at 6:34 PM, Tatsuo Ishii <span dir="ltr"><<a href="mailto:ishii@postgresql.org" target="_blank">ishii@postgresql.org</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">Souds like a pgpool-II 3.2.1's connection problem. Can you please try<br>
3.2-stable head?<br>
<br>
<a href="http://git.postgresql.org/gitweb/?p=pgpool2.git;a=shortlog;h=refs/heads/V3_2_STABLE" target="_blank">http://git.postgresql.org/gitweb/?p=pgpool2.git;a=shortlog;h=refs/heads/V3_2_STABLE</a><br>
--<br>
Tatsuo Ishii<br>
SRA OSS, Inc. Japan<br>
English: <a href="http://www.sraoss.co.jp/index_en.php" target="_blank">http://www.sraoss.co.jp/index_en.php</a><br>
Japanese: <a href="http://www.sraoss.co.jp" target="_blank">http://www.sraoss.co.jp</a><br>
<div class="HOEnZb"><div class="h5"><br>
> Hi,<br>
> I have a server load with PostgreSQL 9.2.4 and PgPool-II 3.2.1 configure to<br>
> RAW mode by renaming pgpool.conf.sample to pgpool.conf and update the<br>
> followings:<br>
> backend_hostname0<br>
> backend_port0<br>
> backend_weight0<br>
> backend_data_directory0<br>
><br>
> log_destination<br>
> sr_check_user<br>
> sr_check_password<br>
><br>
> health_check_user<br>
> health_check_password<br>
><br>
> PgPool was able to start, however, node info return the server to be in<br>
> State 1<br>
> [root@se032c-94-30 etc]# /usr/bin/pcp_node_info 10 localhost 9898 pgpool<br>
> cisco 0<br>
> se032c-94-30 5432 1 1.000000<br>
><br>
> When try query as psql -c "select 1" -U postgres -p 9999, pgpool trigger<br>
> the failover.<br>
><br>
> In my current configuration, I only have 1 pgpool and 1 database, and both<br>
> applications are on the same box.<br>
><br>
> Please kindly let me know if I miss anything.<br>
><br>
> Attached pgpool.conf for your reference.<br>
><br>
> Thanks~<br>
> Ning<br>
</div></div></blockquote></div><br></div>