<div dir="ltr"><div><div><div><div>Hi Tatsuo,<br></div>I figured out the problem is that I did not have the postgresql.conf set correctly.<br><br>#listen_addresses = '*'<br><br></div>As soon as I set to * and restart both postgresql and pgpool, problem resolve.<br>
<br></div>Thanks<br></div>Ning<br></div><div class="gmail_extra"><br><br><div class="gmail_quote">On Sun, Apr 14, 2013 at 3:22 AM, 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"><div class="im">> 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>
> The difference is that, one the working machine, I compile, make, and make<br>
> install pgpool on the system; while on the non working server, I create the<br>
> rpm from a build machine.<br>
> I obtained the spec file from you previously, and I see that your<br>
> ./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>
> While in my build environment, the pgsql include folder and pgsql lib<br>
> folder are not available, do I really need the folder for the ./configure<br>
> command?<br>
<br>
</div>Yes. Building pgpool-II requires PostgreSQL header files and library.<br>
<div class="HOEnZb"><div class="h5">--<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>
<br>
> Thanks~<br>
> Ning<br>
><br>
><br>
> On Sat, Apr 13, 2013 at 6:34 PM, Tatsuo Ishii <<a href="mailto:ishii@postgresql.org">ishii@postgresql.org</a>> wrote:<br>
><br>
>> Souds like a pgpool-II 3.2.1's connection problem. Can you please try<br>
>> 3.2-stable head?<br>
>><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>
>><br>
>> > Hi,<br>
>> > I have a server load with PostgreSQL 9.2.4 and PgPool-II 3.2.1 configure<br>
>> 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<br>
>> 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>
>><br>
</div></div></blockquote></div><br></div>