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

[ning chan]

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