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

[ning chan]

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?

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
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20130413/6e3523c9/attachment.html>