<div dir="ltr"><div><div><div><div><div><div>Hi,<br></div>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:<br>backend_hostname0<br>
backend_port0<br>backend_weight0<br>backend_data_directory0<br><br>log_destination<br>sr_check_user<br>sr_check_password<br><br>health_check_user<br>health_check_password<br><br></div>PgPool was able to start, however, node info return the server to be in State 1<br>
[root@se032c-94-30 etc]# /usr/bin/pcp_node_info 10 localhost 9898 pgpool cisco 0<br>se032c-94-30 5432 1 1.000000<br><br></div>When try query as psql -c "select 1" -U postgres -p 9999, pgpool trigger the failover.<br>
<br></div>In my current configuration, I only have 1 pgpool and 1 database, and both applications are on the same box.<br><br></div>Please kindly let me know if I miss anything.<br><br></div><div>Attached pgpool.conf for your reference.<br>
</div><div><br></div>Thanks~<br>Ning<br><div><div><div><div><div><br><br></div></div></div></div></div></div>