[pgpool-general: 1618] Re: PgPool-II 3.2.1 RAW mode

[Tatsuo Ishii]

Hi Ning,

Glad to hear that you solved the problem. Thanks for the report!
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese: http://www.sraoss.co.jp

> Hi Tatsuo,
> I figured out the problem is that I did not have the postgresql.conf set
> correctly.
> 
> #listen_addresses = '*'
> 
> As soon as I set to * and restart both postgresql and pgpool, problem
> resolve.
> 
> Thanks
> Ning
> 
> 
> On Sun, Apr 14, 2013 at 3:22 AM, Tatsuo Ishii <ishii at postgresql.org> wrote:
> 
>> > Hi Tatsuo,
>> > I will try your latest pkg on Monday.
>> > Meanwhile, I try on my other machine which I cannot reproduce the
>> problem.
>> > 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.
>> > I obtained the spec file from you previously, and I see that your
>> > ./configure command has the following:
>> >
>> > %configure --with-pgsql-includedir=%{_includedir}/pgsql \
>> >            --with-pgsql-lib=%{_libdir}/pgsql \
>> >            --disable-static --with-pam --disable-rpath \
>> >            --sysconfdir=%{_sysconfdir}/%{name}/
>> >
>> > 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?
>>
>> Yes. Building pgpool-II requires PostgreSQL header files and library.
>> --
>> Tatsuo Ishii
>> SRA OSS, Inc. Japan
>> English: http://www.sraoss.co.jp/index_en.php
>> Japanese: http://www.sraoss.co.jp
>>
>> > Thanks~
>> > Ning
>> >
>> >
>> > On Sat, Apr 13, 2013 at 6:34 PM, Tatsuo Ishii <ishii at postgresql.org>
>> wrote:
>> >
>> >> Souds like a pgpool-II 3.2.1's connection problem. Can you please try
>> >> 3.2-stable head?
>> >>
>> >>
>> >>
>> http://git.postgresql.org/gitweb/?p=pgpool2.git;a=shortlog;h=refs/heads/V3_2_STABLE
>> >> --
>> >> Tatsuo Ishii
>> >> SRA OSS, Inc. Japan
>> >> English: http://www.sraoss.co.jp/index_en.php
>> >> Japanese: http://www.sraoss.co.jp
>> >>
>> >> > Hi,
>> >> > I have a server load with PostgreSQL 9.2.4 and PgPool-II 3.2.1
>> configure
>> >> to
>> >> > RAW mode by renaming pgpool.conf.sample to pgpool.conf and update the
>> >> > followings:
>> >> > backend_hostname0
>> >> > backend_port0
>> >> > backend_weight0
>> >> > backend_data_directory0
>> >> >
>> >> > log_destination
>> >> > sr_check_user
>> >> > sr_check_password
>> >> >
>> >> > health_check_user
>> >> > health_check_password
>> >> >
>> >> > PgPool was able to start, however, node info return the server to be
>> in
>> >> > State 1
>> >> > [root at se032c-94-30 etc]# /usr/bin/pcp_node_info 10 localhost 9898
>> pgpool
>> >> > cisco 0
>> >> > se032c-94-30 5432 1 1.000000
>> >> >
>> >> > When try query as psql -c "select 1" -U postgres -p 9999, pgpool
>> trigger
>> >> > the failover.
>> >> >
>> >> > In my current configuration, I only have 1 pgpool and 1 database, and
>> >> both
>> >> > applications are on the same box.
>> >> >
>> >> > Please kindly let me know if I miss anything.
>> >> >
>> >> > Attached pgpool.conf for your reference.
>> >> >
>> >> > Thanks~
>> >> > Ning
>> >>
>>