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

[Tatsuo Ishii]

> 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
>>