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

[Tatsuo Ishii]

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