<html><head><style type='text/css'>p { margin: 0; }</style></head><body><div style='font-family: Verdana; font-size: 12pt; color: #000000'><br><div style="color:#000;font-weight:normal;font-style:normal;text-decoration:none;font-family:Helvetica,Arial,sans-serif;font-size:12pt;"><style>p { margin: 0; }</style><div style="font-family: Verdana; font-size: 12pt; color: #000000">Hi again.<br><br>I have a cluster with 2 postgresql 8.4 backends and 1 pgpool2 3.0.3 version. They are running on Debian Squeeze using backports repository.<br><br>When I try to recovery one of the backends using pcp_recovery_node its fails to recover until all clients connected to pgpool are disconnected.<br><br>Also I tried streaming replication in other machines with PostgreSQL 9.1 but when recover a backend Pgpool drops all clients connected to it.<br><br>Is there ant way to Pgpool maintain clients connected when I recover a dead node?<br><br>This is my pgpool.conf for PostgreSQL 8.4 nodes.<br><br>listen_addresses = '*'<br>port = 5432<br>pcp_port = 9898<br>socket_dir = '/var/run/postgresql'<br>pcp_socket_dir = '/var/run/postgresql'<br>backend_socket_dir = '/var/run/postgresql'<br>pcp_timeout = 10<br>num_init_children = 32<br>max_pool = 4<br>child_life_time = 300<br>connection_life_time = 0<br>child_max_connections = 0<br>client_idle_limit = 0<br>authentication_timeout = 60<br>logdir = '/var/run/postgresql'<br>pid_file_name = '/var/run/postgresql/pgpool.pid'<br>replication_mode = true<br>load_balance_mode = true<br>replication_stop_on_mismatch = true<br>replicate_select = false<br>reset_query_list = 'ABORT; RESET ALL; SET SESSION AUTHORIZATION DEFAULT'<br>print_timestamp = true<br>master_slave_mode = false<br>connection_cache = true<br>health_check_timeout = 3<br>health_check_period = 5<br>health_check_user = 'pgpool2'<br>failover_command = 'pgpool-failover %d %h %p %D %m %M'<br>failback_command = 'pgpool-failback %d %h %p %D %m %M'<br>insert_lock = true<br>ignore_leading_white_space = true<br>log_statement = false<br>log_connections = false<br>log_hostname = false<br>parallel_mode = false<br>enable_query_cache = false<br>pgpool2_hostname = 'ppsqlft1'<br>system_db_hostname = 'localhost'<br>system_db_port = 5432<br>system_db_dbname = 'pgpool'<br>system_db_schema = 'pgpool_catalog'<br>system_db_user = 'pgpool'<br>system_db_password = ''<br>backend_hostname0 = 'PPSQLBK1'<br>backend_port0 = 5432<br>backend_weight0 = 1<br>backend_data_directory0 = '/var/lib/postgresql/8.4/main'<br>backend_hostname1 = 'PPSQLBK2'<br>backend_port1 = 5432<br>backend_weight1 = 1<br>backend_data_directory1 = '/var/lib/postgresql/8.4/main'<br>enable_pool_hba = true<br>recovery_user = 'pgpool2'<br>recovery_password = ''<br>recovery_1st_stage_command = 'base-backup'<br>recovery_2nd_stage_command = 'pgpool-recovery-pitr'<br>recovery_timeout = 90<br>client_idle_limit_in_recovery = 10<br><br><br>Thanks for your help<br><br>-- <br><div><span></span><span><font color="#585858"><font size="2"><font face="Arial"><span style="font-size: 10pt;">Joaquín Manuel Llano Montero<br>
<br>
</span></font></font></font><font face="Arial"><font color="#ff0000"><font size="1"><span style="font-size: 9pt;">________________________________________ <br>
</span></font></font><font size="1"><span style="font-size: 9pt;"><font color="#7e7e7e"><b> </b> <br>
</font><font color="#585858"><b>C<span style="color: rgb(255, 0, 0);">O</span>MPAREX España S.A.<br>
</b></font><font color="#595959">C/ Severo Ochoa, 20 <br>
06800 Mérida (Badajoz) España <br>
</font></span></font></font><font size="1"><span style="font-size: 9pt;"><font color="#595959"><font face="Arial Bold">phone:</font><font face="Arial"> +34 924 373 573<br>
</font><font face="Arial Bold">fax: </font><font face="Arial"> +34 924 374 518<br>
</font></font><font face="Arial"><font color="#585858"><b>mobile:</b>+34 615 848 019<br>
<b>email</b></font><b><font color="#7e7e7e">:</font></b><font color="#7e7e7e"> </font><font color="#ff0000"><u><a target="_blank">joaquin.llano@comparex.es</a></u> <br>
</font><font color="#585858"><b>web:</b></font><b><font color="#7e7e7e"> </font></b><font color="#7e7e7e"> </font><font color="#ff0000"><span class="Object" id="OBJ_PREFIX_DWT206_com_zimbra_url"><a target="_blank" href="http://www.comparex.es/">www.comparex.es</a></span></font></font></span></font></span><span></span><br></div></div></div><br></div></body></html>