[pgpool-general: 1613] PgPool-II 3.2.1 RAW mode

[ning chan]

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/a66f4976/attachment-0001.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: pgpool.conf
Type: application/octet-stream
Size: 25215 bytes
Desc: not available
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20130413/a66f4976/attachment-0001.obj>