<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40"><head><meta http-equiv=Content-Type content="text/html; charset=us-ascii"><meta name=Generator content="Microsoft Word 14 (filtered medium)"><style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
@font-face
{font-family:Verdana;
panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
p
{mso-style-priority:99;
mso-margin-top-alt:auto;
margin-right:0in;
mso-margin-bottom-alt:auto;
margin-left:0in;
font-size:12.0pt;
font-family:"Times New Roman","serif";}
p.MsoAcetate, li.MsoAcetate, div.MsoAcetate
{mso-style-priority:99;
mso-style-link:"Balloon Text Char";
margin:0in;
margin-bottom:.0001pt;
font-size:8.0pt;
font-family:"Tahoma","sans-serif";}
span.BalloonTextChar
{mso-style-name:"Balloon Text Char";
mso-style-priority:99;
mso-style-link:"Balloon Text";
font-family:"Tahoma","sans-serif";}
span.EmailStyle19
{mso-style-type:personal-compose;
font-family:"Calibri","sans-serif";
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;
font-family:"Calibri","sans-serif";}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]--></head><body lang=EN-US link=blue vlink=purple style='word-wrap: break-word;-webkit-nbsp-mode: space;-webkit-line-break: after-white-space'><div class=WordSection1><p class=MsoNormal>Hello List,<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>I am having some difficulty with heath check in pgpool. It appears that it can not make a persistent connection so it fails health check.<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>The servers are listed as up <o:p></o:p></p><div><p class=MsoNormal><span style='font-size:12.0pt;font-family:"Times New Roman","serif"'>prod1.db.power-soft.net5433Up[Detail]<o:p></o:p></span></p></div><div><p class=MsoNormal><span style='font-size:12.0pt;font-family:"Times New Roman","serif"'>prod2.db.power-soft.net5434Up[Detail]<o:p></o:p></span></p></div><div><p class=MsoNormal><span style='font-size:12.0pt;font-family:"Times New Roman","serif"'><o:p> </o:p></span></p></div><div><table class=MsoNormalTable border=1 cellspacing=0 cellpadding=0 style='background:white;border-collapse:collapse;border:none;z-index:auto'><thead><tr><td style='border-top:solid lightsteelblue 1.0pt;border-left:none;border-bottom:solid lightsteelblue 1.0pt;border-right:none;background:ghostwhite;padding:3.0pt 6.0pt 3.0pt 6.0pt'><p class=MsoNormal align=center style='text-align:center'><b><span style='font-size:10.0pt;font-family:"Verdana","sans-serif";color:black'>IP Address<o:p></o:p></span></b></p></td><td style='border-top:solid lightsteelblue 1.0pt;border-left:none;border-bottom:solid lightsteelblue 1.0pt;border-right:none;background:ghostwhite;padding:3.0pt 6.0pt 3.0pt 6.0pt'><p class=MsoNormal align=center style='text-align:center'><b><span style='font-size:10.0pt;font-family:"Verdana","sans-serif";color:black'>Port<o:p></o:p></span></b></p></td><td style='border-top:solid lightsteelblue 1.0pt;border-left:none;border-bottom:solid lightsteelblue 1.0pt;border-right:none;background:ghostwhite;padding:3.0pt 6.0pt 3.0pt 6.0pt'><p class=MsoNormal align=center style='text-align:center'><b><span style='font-size:10.0pt;font-family:"Verdana","sans-serif";color:black'>Status<o:p></o:p></span></b></p></td><td style='border-top:solid lightsteelblue 1.0pt;border-left:none;border-bottom:solid lightsteelblue 1.0pt;border-right:none;background:ghostwhite;padding:3.0pt 6.0pt 3.0pt 6.0pt'><p class=MsoNormal align=center style='text-align:center'><b><span style='font-size:10.0pt;font-family:"Verdana","sans-serif";color:black'>Weight<o:p></o:p></span></b></p></td><td style='border-top:solid lightsteelblue 1.0pt;border-left:none;border-bottom:solid lightsteelblue 1.0pt;border-right:none;background:ghostwhite;padding:3.0pt 6.0pt 3.0pt 6.0pt'></td></tr></thead><tr><td style='border:none;border-bottom:solid lightsteelblue 1.0pt;padding:3.0pt 6.0pt 3.0pt 6.0pt'><p class=MsoNormal><span style='font-size:10.0pt;font-family:"Verdana","sans-serif";color:black'><a href="http://prod1.db.power-soft.net">prod1.db.power-soft.net</a><o:p></o:p></span></p></td><td style='border:none;border-bottom:solid lightsteelblue 1.0pt;padding:3.0pt 6.0pt 3.0pt 6.0pt'><p class=MsoNormal><span style='font-size:10.0pt;font-family:"Verdana","sans-serif";color:black'>5433<o:p></o:p></span></p></td><td style='border:none;border-bottom:solid lightsteelblue 1.0pt;padding:3.0pt 6.0pt 3.0pt 6.0pt'><p class=MsoNormal><span style='font-size:10.0pt;font-family:"Verdana","sans-serif";color:black'>Up. Disconnect. Running as primary server<o:p></o:p></span></p></td><td style='border:none;border-bottom:solid lightsteelblue 1.0pt;padding:3.0pt 6.0pt 3.0pt 6.0pt'><p class=MsoNormal><span style='font-size:10.0pt;font-family:"Verdana","sans-serif";color:black'>0.500<o:p></o:p></span></p></td><td style='border:none;border-bottom:solid lightsteelblue 1.0pt;padding:3.0pt 6.0pt 3.0pt 6.0pt'><p class=MsoNormal><span style='font-size:10.0pt;font-family:"Verdana","sans-serif";color:black'>[Disconnect]<o:p></o:p></span></p></td></tr><tr style='background-position:initial initial;background-repeat:initial initial'><td style='border:none;border-bottom:solid lightsteelblue 1.0pt;background:azure;padding:3.0pt 6.0pt 3.0pt 6.0pt'><p class=MsoNormal><span style='font-size:10.0pt;font-family:"Verdana","sans-serif";color:black'><a href="http://prod2.db.power-soft.net">prod2.db.power-soft.net</a><o:p></o:p></span></p></td><td style='border:none;border-bottom:solid lightsteelblue 1.0pt;background:azure;padding:3.0pt 6.0pt 3.0pt 6.0pt'><p class=MsoNormal><span style='font-size:10.0pt;font-family:"Verdana","sans-serif";color:black'>5434<o:p></o:p></span></p></td><td style='border:none;border-bottom:solid lightsteelblue 1.0pt;background:azure;padding:3.0pt 6.0pt 3.0pt 6.0pt'><p class=MsoNormal><span style='font-size:10.0pt;font-family:"Verdana","sans-serif";color:black'>Up. Disconnect. Running as standby server<o:p></o:p></span></p></td><td style='border:none;border-bottom:solid lightsteelblue 1.0pt;background:azure;padding:3.0pt 6.0pt 3.0pt 6.0pt'><p class=MsoNormal><span style='font-size:10.0pt;font-family:"Verdana","sans-serif";color:black'>0.500<o:p></o:p></span></p></td><td style='border:none;border-bottom:solid lightsteelblue 1.0pt;background:azure;padding:3.0pt 6.0pt 3.0pt 6.0pt'><p class=MsoNormal><span style='font-size:10.0pt;font-family:"Verdana","sans-serif";color:black'>[Disconnect] [Promote]<o:p></o:p></span></p></td></tr><tr><td style='border:none;border-bottom:solid lightsteelblue 1.0pt;background:ghostwhite;padding:3.0pt 6.0pt 3.0pt 6.0pt'></td><td style='border:none;border-bottom:solid lightsteelblue 1.0pt;background:ghostwhite;padding:3.0pt 6.0pt 3.0pt 6.0pt'></td><td style='border:none;border-bottom:solid lightsteelblue 1.0pt;background:ghostwhite;padding:3.0pt 6.0pt 3.0pt 6.0pt'></td><td style='border:none;border-bottom:solid lightsteelblue 1.0pt;background:ghostwhite;padding:3.0pt 6.0pt 3.0pt 6.0pt'></td><td style='border:none;border-bottom:solid lightsteelblue 1.0pt;background:ghostwhite;padding:3.0pt 6.0pt 3.0pt 6.0pt'></td></tr></table></div><p class=MsoNormal><o:p> </o:p></p><div><div><p class=MsoNormal><span style='font-size:12.0pt;font-family:"Times New Roman","serif"'>Dec 4 11:49:47 pgpool1 pgpool[67018]: make_persistent_db_connection: connection to <a href="http://prod1.db.power-soft.net">prod1.db.power-soft.net</a>(5433) failed<o:p></o:p></span></p></div><div><p class=MsoNormal><span style='font-size:12.0pt;font-family:"Times New Roman","serif"'>Dec 4 11:49:47 pgpool1 pgpool[67018]: health check failed. 0 th host <a href="http://prod1.db.power-soft.net">prod1.db.power-soft.net</a> at port 5433 is down<o:p></o:p></span></p></div></div><div><p class=MsoNormal><span style='font-size:12.0pt;font-family:"Times New Roman","serif"'>Dec 4 11:49:56 pgpool1 pgpool[67030]: check_replication_time_lag: could not connect to DB node 0, check sr_check_user and sr_check_password<o:p></o:p></span></p></div><div><p class=MsoNormal><span style='font-size:12.0pt;font-family:"Times New Roman","serif"'><o:p> </o:p></span></p></div><div><p class=MsoNormal><span style='font-size:12.0pt;font-family:"Times New Roman","serif"'>I am using postgres/postgres for health_check_user/password which I can connect with manually to both the databases.<o:p></o:p></span></p></div><div><p class=MsoNormal><span style='font-size:12.0pt;font-family:"Times New Roman","serif"'>sr_check_user/password are using postgres/postgres as well.<o:p></o:p></span></p></div><div><p class=MsoNormal><span style='font-size:12.0pt;font-family:"Times New Roman","serif"'><o:p> </o:p></span></p></div><div><p class=MsoNormal><span style='font-size:12.0pt;font-family:"Times New Roman","serif"'><o:p> </o:p></span></p></div><div><p class=MsoNormal><span style='font-size:12.0pt;font-family:"Times New Roman","serif"'>Any suggestions out there? The only thing I can find in the FAQ that is related to this is if the user does not exist that its trying to connect with and the return error is completely different.<o:p></o:p></span></p></div><div><p class=MsoNormal><span style='font-size:12.0pt;font-family:"Times New Roman","serif"'><o:p> </o:p></span></p></div><div><p class=MsoNormal><span style='font-size:12.0pt;font-family:"Times New Roman","serif"'>Both databases are postgresql 9.0.10<o:p></o:p></span></p></div><div><p class=MsoNormal><span style='font-size:12.0pt;font-family:"Times New Roman","serif"'><o:p> </o:p></span></p></div><div><p class=MsoNormal><span style='font-size:12.0pt;font-family:"Times New Roman","serif"'>pgpool is on a separate machine <a href="http://pgpool1.db.power-soft.net">pgpool1.db.power-soft.net</a> there is no firewall blocking connections...<o:p></o:p></span></p></div><div><p class=MsoNormal><span style='font-size:12.0pt;font-family:"Times New Roman","serif"'><o:p> </o:p></span></p></div><div><p class=MsoNormal><span style='font-size:12.0pt;font-family:"Times New Roman","serif"'>If I enable failover it will make both prod1 and 2 down.<o:p></o:p></span></p></div><div><p class=MsoNormal><span style='font-size:12.0pt;font-family:"Times New Roman","serif"'><o:p> </o:p></span></p></div><div><p class=MsoNormal><span style='font-size:12.0pt;font-family:"Times New Roman","serif"'>here is the debug from a restart, if this helps any<o:p></o:p></span></p></div><div><p class=MsoNormal><span style='font-size:12.0pt;font-family:"Times New Roman","serif"'><o:p> </o:p></span></p></div><div><p class=MsoNormal><span style='font-size:12.0pt;font-family:"Times New Roman","serif"'><o:p> </o:p></span></p></div><div><p class=MsoNormal><span style='font-size:12.0pt;font-family:"Times New Roman","serif"'>Any help would be greatly appreciated!<o:p></o:p></span></p></div><div><p class=MsoNormal><span style='font-size:12.0pt;font-family:"Times New Roman","serif"'><o:p> </o:p></span></p></div><div><p class=MsoNormal><span style='font-size:12.0pt;font-family:"Times New Roman","serif"'><o:p> </o:p></span></p></div><div><div style='mso-element:para-border-div;border:none;border-bottom:dotted #CCCCCC 1.0pt;padding:0in 0in 0in 0in;margin-left:3.75pt;margin-right:3.75pt'><p style='mso-margin-top-alt:3.75pt;margin-right:0in;margin-bottom:3.75pt;margin-left:0in;border:none;padding:0in'><span style='font-size:10.0pt;font-family:"Courier New"'>pgpool restart succeed<o:p></o:p></span></p><p style='mso-margin-top-alt:3.75pt;margin-right:0in;margin-bottom:3.75pt;margin-left:0in;border:none;padding:0in;z-index:auto'><span style='font-size:10.0pt;font-family:"Courier New"'>2012-12-04 12:08:24 DEBUG: pid 70605: key: listen_addresses<br>2012-12-04 12:08:24 DEBUG: pid 70605: value: '*' kind: 4<br>2012-12-04 12:08:24 DEBUG: pid 70605: key: port<br>2012-12-04 12:08:24 DEBUG: pid 70605: value: 5432 kind: 2<br>2012-12-04 12:08:24 DEBUG: pid 70605: key: socket_dir<br>2012-12-04 12:08:24 DEBUG: pid 70605: value: '/tmp' kind: 4<br>2012-12-04 12:08:24 DEBUG: pid 70605: key: pcp_port<br>2012-12-04 12:08:24 DEBUG: pid 70605: value: 9898 kind: 2<br>2012-12-04 12:08:24 DEBUG: pid 70605: key: pcp_socket_dir<br>2012-12-04 12:08:24 DEBUG: pid 70605: value: '/tmp' kind: 4<br>2012-12-04 12:08:24 DEBUG: pid 70605: key: enable_pool_hba<br>2012-12-04 12:08:24 DEBUG: pid 70605: value: on kind: 1<br>2012-12-04 12:08:24 DEBUG: pid 70605: key: authentication_timeout<br>2012-12-04 12:08:24 DEBUG: pid 70605: value: 60 kind: 2<br>2012-12-04 12:08:24 DEBUG: pid 70605: key: ssl<br>2012-12-04 12:08:24 DEBUG: pid 70605: value: off kind: 1<br>2012-12-04 12:08:24 DEBUG: pid 70605: key: num_init_children<br>2012-12-04 12:08:24 DEBUG: pid 70605: value: 10 kind: 2<br>2012-12-04 12:08:24 DEBUG: pid 70605: key: max_pool<br>2012-12-04 12:08:24 DEBUG: pid 70605: value: 4 kind: 2<br>2012-12-04 12:08:24 DEBUG: pid 70605: key: child_life_time<br>2012-12-04 12:08:24 DEBUG: pid 70605: value: 300 kind: 2<br>2012-12-04 12:08:24 DEBUG: pid 70605: key: child_max_connections<br>2012-12-04 12:08:24 DEBUG: pid 70605: value: 0 kind: 2<br>2012-12-04 12:08:24 DEBUG: pid 70605: key: connection_life_time<br>2012-12-04 12:08:24 DEBUG: pid 70605: value: 0 kind: 2<br>2012-12-04 12:08:24 DEBUG: pid 70605: key: client_idle_limit<br>2012-12-04 12:08:24 DEBUG: pid 70605: value: 0 kind: 2<br>2012-12-04 12:08:24 DEBUG: pid 70605: key: log_destination<br>2012-12-04 12:08:24 DEBUG: pid 70605: value: 'syslog' kind: 4<br>2012-12-04 12:08:24 DEBUG: pid 70605: key: print_timestamp<br>2012-12-04 12:08:24 DEBUG: pid 70605: value: on kind: 1<br>2012-12-04 12:08:24 DEBUG: pid 70605: key: log_connections<br>2012-12-04 12:08:24 DEBUG: pid 70605: value: on kind: 1<br>2012-12-04 12:08:24 DEBUG: pid 70605: key: log_hostname<br>2012-12-04 12:08:24 DEBUG: pid 70605: value: off kind: 1<br>2012-12-04 12:08:24 DEBUG: pid 70605: key: log_statement<br>2012-12-04 12:08:24 DEBUG: pid 70605: value: off kind: 1<br>2012-12-04 12:08:24 DEBUG: pid 70605: key: log_per_node_statement<br>2012-12-04 12:08:24 DEBUG: pid 70605: value: off kind: 1<br>2012-12-04 12:08:24 DEBUG: pid 70605: key: log_standby_delay<br>2012-12-04 12:08:24 DEBUG: pid 70605: value: 'if_over_threshold' kind: 4<br>2012-12-04 12:08:24 DEBUG: pid 70605: key: syslog_facility<br>2012-12-04 12:08:24 DEBUG: pid 70605: value: 'LOCAL0' kind: 4<br>2012-12-04 12:08:24 DEBUG: pid 70605: key: syslog_ident<br>2012-12-04 12:08:24 DEBUG: pid 70605: value: 'pgpool' kind: 4<br>2012-12-04 12:08:24 DEBUG: pid 70605: key: debug_level<br>2012-12-04 12:08:24 DEBUG: pid 70605: value: 10 kind: 2<br>2012-12-04 12:08:24 DEBUG: pid 70605: key: pid_file_name<br>2012-12-04 12:08:24 DEBUG: pid 70605: value: '/var/run/pgpool/pgpool.pid' kind: 4<br>2012-12-04 12:08:24 DEBUG: pid 70605: key: logdir<br>2012-12-04 12:08:24 DEBUG: pid 70605: value: '/tmp' kind: 4<br>2012-12-04 12:08:24 DEBUG: pid 70605: key: connection_cache<br>2012-12-04 12:08:24 DEBUG: pid 70605: value: on kind: 1<br>2012-12-04 12:08:24 DEBUG: pid 70605: key: reset_query_list<br>2012-12-04 12:08:24 DEBUG: pid 70605: value: 'ABORT; DISCARD ALL' kind: 4<br>2012-12-04 12:08:24 DEBUG: pid 70605: extract_string_tokens: token: ABORT<br>2012-12-04 12:08:24 DEBUG: pid 70605: extract_string_tokens: token: DISCARD ALL<br>2012-12-04 12:08:24 DEBUG: pid 70605: key: replication_mode<br>2012-12-04 12:08:24 DEBUG: pid 70605: value: off kind: 1<br>2012-12-04 12:08:24 DEBUG: pid 70605: key: replicate_select<br>2012-12-04 12:08:24 DEBUG: pid 70605: value: off kind: 1<br>2012-12-04 12:08:24 DEBUG: pid 70605: replicate_select: 0<br>2012-12-04 12:08:24 DEBUG: pid 70605: key: insert_lock<br>2012-12-04 12:08:24 DEBUG: pid 70605: value: off kind: 1<br>2012-12-04 12:08:24 DEBUG: pid 70605: key: lobj_lock_table<br>2012-12-04 12:08:24 DEBUG: pid 70605: value: '' kind: 4<br>2012-12-04 12:08:24 DEBUG: pid 70605: key: replication_stop_on_mismatch<br>2012-12-04 12:08:24 DEBUG: pid 70605: value: off kind: 1<br>2012-12-04 12:08:24 DEBUG: pid 70605: replication_stop_on_mismatch: 0<br>2012-12-04 12:08:24 DEBUG: pid 70605: key: failover_if_affected_tuples_mismatch<br>2012-12-04 12:08:24 DEBUG: pid 70605: value: off kind: 1<br>2012-12-04 12:08:24 DEBUG: pid 70605: failover_if_affected_tuples_mismatch: 0<br>2012-12-04 12:08:24 DEBUG: pid 70605: key: load_balance_mode<br>2012-12-04 12:08:24 DEBUG: pid 70605: value: on kind: 1<br>2012-12-04 12:08:24 DEBUG: pid 70605: key: ignore_leading_white_space<br>2012-12-04 12:08:24 DEBUG: pid 70605: value: on kind: 1<br>2012-12-04 12:08:24 DEBUG: pid 70605: key: white_function_list<br>2012-12-04 12:08:24 DEBUG: pid 70605: value: '' kind: 4<br>2012-12-04 12:08:24 DEBUG: pid 70605: key: black_function_list<br>2012-12-04 12:08:24 DEBUG: pid 70605: value: 'currval,lastval,nextval,setval' kind: 4<br>2012-12-04 12:08:24 DEBUG: pid 70605: extract_string_tokens: token: currval<br>2012-12-04 12:08:24 DEBUG: pid 70605: extract_string_tokens: token: lastval<br>2012-12-04 12:08:24 DEBUG: pid 70605: extract_string_tokens: token: nextval<br>2012-12-04 12:08:24 DEBUG: pid 70605: extract_string_tokens: token: setval<br>2012-12-04 12:08:24 DEBUG: pid 70605: add_to_patterns: regex pattern: ^currval$<br>2012-12-04 12:08:24 DEBUG: pid 70605: add_to_patterns: regex pattern: ^lastval$<br>2012-12-04 12:08:24 DEBUG: pid 70605: add_to_patterns: regex pattern: ^nextval$<br>2012-12-04 12:08:24 DEBUG: pid 70605: add_to_patterns: regex pattern: ^setval$<br>2012-12-04 12:08:24 DEBUG: pid 70605: key: master_slave_mode<br>2012-12-04 12:08:24 DEBUG: pid 70605: value: on kind: 1<br>2012-12-04 12:08:24 DEBUG: pid 70605: key: master_slave_sub_mode<br>2012-12-04 12:08:24 DEBUG: pid 70605: value: 'stream' kind: 4<br>2012-12-04 12:08:24 DEBUG: pid 70605: key: sr_check_period<br>2012-12-04 12:08:24 DEBUG: pid 70605: value: 5 kind: 2<br>2012-12-04 12:08:24 DEBUG: pid 70605: key: sr_check_user<br>2012-12-04 12:08:24 DEBUG: pid 70605: value: 'postgres' kind: 4<br>2012-12-04 12:08:24 DEBUG: pid 70605: key: sr_check_password<br>2012-12-04 12:08:24 DEBUG: pid 70605: value: 'postgres' kind: 4<br>2012-12-04 12:08:24 DEBUG: pid 70605: key: delay_threshold<br>2012-12-04 12:08:24 DEBUG: pid 70605: value: 0 kind: 2<br>2012-12-04 12:08:24 DEBUG: pid 70605: key: follow_master_command<br>2012-12-04 12:08:24 DEBUG: pid 70605: value: '' kind: 4<br>2012-12-04 12:08:24 DEBUG: pid 70605: key: parallel_mode<br>2012-12-04 12:08:24 DEBUG: pid 70605: value: off kind: 1<br>2012-12-04 12:08:24 DEBUG: pid 70605: key: pgpool2_hostname<br>2012-12-04 12:08:24 DEBUG: pid 70605: value: '' kind: 4<br>2012-12-04 12:08:24 DEBUG: pid 70605: key: health_check_period<br>2012-12-04 12:08:24 DEBUG: pid 70605: value: 1 kind: 2<br>2012-12-04 12:08:24 DEBUG: pid 70605: key: health_check_timeout<br>2012-12-04 12:08:24 DEBUG: pid 70605: value: 1 kind: 2<br>2012-12-04 12:08:24 DEBUG: pid 70605: key: health_check_user<br>2012-12-04 12:08:24 DEBUG: pid 70605: value: 'postgres' kind: 4<br>2012-12-04 12:08:24 DEBUG: pid 70605: key: health_check_password<br>2012-12-04 12:08:24 DEBUG: pid 70605: value: 'postgres' kind: 4<br>2012-12-04 12:08:24 DEBUG: pid 70605: key: health_check_max_retries<br>2012-12-04 12:08:24 DEBUG: pid 70605: value: 3 kind: 2<br>2012-12-04 12:08:24 DEBUG: pid 70605: key: health_check_retry_delay<br>2012-12-04 12:08:24 DEBUG: pid 70605: value: 5 kind: 2<br>2012-12-04 12:08:24 DEBUG: pid 70605: key: failover_command<br>2012-12-04 12:08:24 DEBUG: pid 70605: value: '/usr/local/pgsql/bin/failover_stream.sh %d %H /db-array/db_repo/tmp/trigger_file0' kind: 4<br>2012-12-04 12:08:24 DEBUG: pid 70605: key: failback_command<br>2012-12-04 12:08:24 DEBUG: pid 70605: value: '' kind: 4<br>2012-12-04 12:08:24 DEBUG: pid 70605: key: fail_over_on_backend_error<br>2012-12-04 12:08:24 DEBUG: pid 70605: value: off kind: 1<br>2012-12-04 12:08:24 DEBUG: pid 70605: key: recovery_user<br>2012-12-04 12:08:24 DEBUG: pid 70605: value: 'postgres' kind: 4<br>2012-12-04 12:08:24 DEBUG: pid 70605: key: recovery_password<br>2012-12-04 12:08:24 DEBUG: pid 70605: value: 'postgres' kind: 4<br>2012-12-04 12:08:24 DEBUG: pid 70605: key: recovery_1st_stage_command<br>2012-12-04 12:08:24 DEBUG: pid 70605: value: '' kind: 4<br>2012-12-04 12:08:24 DEBUG: pid 70605: key: recovery_2nd_stage_command<br>2012-12-04 12:08:24 DEBUG: pid 70605: value: '' kind: 4<br>2012-12-04 12:08:24 DEBUG: pid 70605: key: recovery_timeout<br>2012-12-04 12:08:24 DEBUG: pid 70605: value: 90 kind: 2<br>2012-12-04 12:08:24 DEBUG: pid 70605: key: client_idle_limit_in_recovery<br>2012-12-04 12:08:24 DEBUG: pid 70605: value: 0 kind: 2<br>2012-12-04 12:08:24 DEBUG: pid 70605: key: use_watchdog<br>2012-12-04 12:08:24 DEBUG: pid 70605: value: off kind: 1<br>2012-12-04 12:08:24 DEBUG: pid 70605: key: trusted_servers<br>2012-12-04 12:08:24 DEBUG: pid 70605: value: '' kind: 4<br>2012-12-04 12:08:24 DEBUG: pid 70605: key: delegate_IP<br>2012-12-04 12:08:24 DEBUG: pid 70605: value: '' kind: 4<br>2012-12-04 12:08:24 DEBUG: pid 70605: key: wd_hostname<br>2012-12-04 12:08:24 DEBUG: pid 70605: value: '' kind: 4<br>2012-12-04 12:08:24 DEBUG: pid 70605: key: wd_port<br>2012-12-04 12:08:24 DEBUG: pid 70605: value: 9000 kind: 2<br>2012-12-04 12:08:24 DEBUG: pid 70605: key: wd_interval<br>2012-12-04 12:08:24 DEBUG: pid 70605: value: 10 kind: 2<br>2012-12-04 12:08:24 DEBUG: pid 70605: key: ping_path<br>2012-12-04 12:08:24 DEBUG: pid 70605: value: '/bin' kind: 4<br>2012-12-04 12:08:24 DEBUG: pid 70605: key: ifconfig_path<br>2012-12-04 12:08:24 DEBUG: pid 70605: value: '/sbin' kind: 4<br>2012-12-04 12:08:24 DEBUG: pid 70605: key: if_up_cmd<br>2012-12-04 12:08:24 DEBUG: pid 70605: value: 'ifconfig eth0:0 inet $_IP_$ netmask 255.255.255.0' kind: 4<br>2012-12-04 12:08:24 DEBUG: pid 70605: key: if_down_cmd<br>2012-12-04 12:08:24 DEBUG: pid 70605: value: 'ifconfig eth0:0 down' kind: 4<br>2012-12-04 12:08:24 DEBUG: pid 70605: key: arping_path<br>2012-12-04 12:08:24 DEBUG: pid 70605: value: '/usr/sbin # arping command path' kind: 4<br>2012-12-04 12:08:24 DEBUG: pid 70605: key: arping_cmd<br>2012-12-04 12:08:24 DEBUG: pid 70605: value: 'arping -U $_IP_$ -w 1' kind: 4<br>2012-12-04 12:08:24 DEBUG: pid 70605: key: wd_life_point<br>2012-12-04 12:08:24 DEBUG: pid 70605: value: 3 kind: 2<br>2012-12-04 12:08:24 DEBUG: pid 70605: key: wd_lifecheck_query<br>2012-12-04 12:08:24 DEBUG: pid 70605: value: 'SELECT 1' kind: 4<br>2012-12-04 12:08:24 DEBUG: pid 70605: key: relcache_expire<br>2012-12-04 12:08:24 DEBUG: pid 70605: value: 0 kind: 2<br>2012-12-04 12:08:24 DEBUG: pid 70605: key: relcache_size<br>2012-12-04 12:08:24 DEBUG: pid 70605: value: 256 kind: 2<br>2012-12-04 12:08:24 DEBUG: pid 70605: key: check_temp_table<br>2012-12-04 12:08:24 DEBUG: pid 70605: value: on kind: 1<br>2012-12-04 12:08:24 DEBUG: pid 70605: key: memory_cache_enabled<br>2012-12-04 12:08:24 DEBUG: pid 70605: value: off kind: 1<br>2012-12-04 12:08:24 DEBUG: pid 70605: key: memqcache_method<br>2012-12-04 12:08:24 DEBUG: pid 70605: value: 'shmem' kind: 4<br>2012-12-04 12:08:24 DEBUG: pid 70605: key: memqcache_memcached_host<br>2012-12-04 12:08:24 DEBUG: pid 70605: value: 'localhost' kind: 4<br>2012-12-04 12:08:24 DEBUG: pid 70605: key: memqcache_memcached_port<br>2012-12-04 12:08:24 DEBUG: pid 70605: value: 11211 kind: 2<br>2012-12-04 12:08:24 DEBUG: pid 70605: key: memqcache_total_size<br>2012-12-04 12:08:24 DEBUG: pid 70605: value: 67108864 kind: 2<br>2012-12-04 12:08:24 DEBUG: pid 70605: key: memqcache_max_num_cache<br>2012-12-04 12:08:24 DEBUG: pid 70605: value: 1000000 kind: 2<br>2012-12-04 12:08:24 DEBUG: pid 70605: key: memqcache_expire<br>2012-12-04 12:08:24 DEBUG: pid 70605: value: 0 kind: 2<br>2012-12-04 12:08:24 DEBUG: pid 70605: key: memqcache_auto_cache_invalidation<br>2012-12-04 12:08:24 DEBUG: pid 70605: value: on kind: 1<br>2012-12-04 12:08:24 DEBUG: pid 70605: key: memqcache_maxcache<br>2012-12-04 12:08:24 DEBUG: pid 70605: value: 409600 kind: 2<br>2012-12-04 12:08:24 DEBUG: pid 70605: key: memqcache_cache_block_size<br>2012-12-04 12:08:24 DEBUG: pid 70605: value: 1048576 kind: 2<br>2012-12-04 12:08:24 DEBUG: pid 70605: key: memqcache_oiddir<br>2012-12-04 12:08:24 DEBUG: pid 70605: value: '/var/log/pgpool/oiddir' kind: 4<br>2012-12-04 12:08:24 DEBUG: pid 70605: key: white_memqcache_table_list<br>2012-12-04 12:08:24 DEBUG: pid 70605: value: '' kind: 4<br>2012-12-04 12:08:24 DEBUG: pid 70605: key: black_memqcache_table_list<br>2012-12-04 12:08:24 DEBUG: pid 70605: value: '' kind: 4<br>2012-12-04 12:08:24 DEBUG: pid 70605: key: ssl_key<br>2012-12-04 12:08:24 DEBUG: pid 70605: value: '' kind: 4<br>2012-12-04 12:08:24 DEBUG: pid 70605: key: ssl_cert<br>2012-12-04 12:08:24 DEBUG: pid 70605: value: '' kind: 4<br>2012-12-04 12:08:24 DEBUG: pid 70605: key: ssl_ca_cert<br>2012-12-04 12:08:24 DEBUG: pid 70605: value: '' kind: 4<br>2012-12-04 12:08:24 DEBUG: pid 70605: key: ssl_ca_cert_dir<br>2012-12-04 12:08:24 DEBUG: pid 70605: value: '' kind: 4<br>2012-12-04 12:08:24 DEBUG: pid 70605: key: enable_query_cache<br>2012-12-04 12:08:24 DEBUG: pid 70605: value: off kind: 1<br>2012-12-04 12:08:24 DEBUG: pid 70605: key: system_db_hostname<br>2012-12-04 12:08:24 DEBUG: pid 70605: value: 'system_db_hostname' kind: 4<br>2012-12-04 12:08:24 DEBUG: pid 70605: key: system_db_port<br>2012-12-04 12:08:24 DEBUG: pid 70605: value: 5432 kind: 2<br>2012-12-04 12:08:24 DEBUG: pid 70605: key: system_db_dbname<br>2012-12-04 12:08:24 DEBUG: pid 70605: value: 'pgpool' kind: 4<br>2012-12-04 12:08:24 DEBUG: pid 70605: key: system_db_schema<br>2012-12-04 12:08:24 DEBUG: pid 70605: value: 'pgpool_catalog' kind: 4<br>2012-12-04 12:08:24 DEBUG: pid 70605: key: system_db_user<br>2012-12-04 12:08:24 DEBUG: pid 70605: value: 'pgpool' kind: 4<br>2012-12-04 12:08:24 DEBUG: pid 70605: key: system_db_password<br>2012-12-04 12:08:24 DEBUG: pid 70605: value: '' kind: 4<br>2012-12-04 12:08:24 DEBUG: pid 70605: key: backend_socket_dir<br>2012-12-04 12:08:24 DEBUG: pid 70605: value: '/tmp' kind: 4<br>2012-12-04 12:08:24 LOG: pid 70605: pool_config: backend_socket_dir is deprecated, please use backend_hostname<br>2012-12-04 12:08:24 DEBUG: pid 70605: key: backend_hostname0<br>2012-12-04 12:08:24 DEBUG: pid 70605: value: '<a href="http://prod1.db.power-soft.net">prod1.db.power-soft.net</a>' kind: 4<br>2012-12-04 12:08:24 DEBUG: pid 70605: key: backend_port0<br>2012-12-04 12:08:24 DEBUG: pid 70605: value: 5433 kind: 2<br>2012-12-04 12:08:24 DEBUG: pid 70605: pool_config: port slot number 0<br>2012-12-04 12:08:24 DEBUG: pid 70605: key: backend_weight0<br>2012-12-04 12:08:24 DEBUG: pid 70605: value: 1 kind: 2<br>2012-12-04 12:08:24 DEBUG: pid 70605: pool_config: weight slot number 0 weight: 1.000000<br>2012-12-04 12:08:24 DEBUG: pid 70605: key: backend_data_directory0<br>2012-12-04 12:08:24 DEBUG: pid 70605: value: '/db-array/db_repo/prod1/data' kind: 4<br>2012-12-04 12:08:24 DEBUG: pid 70605: key: backend_flag0<br>2012-12-04 12:08:24 DEBUG: pid 70605: value: 'DISALLOW_TO_FAILOVER' kind: 4<br>2012-12-04 12:08:24 DEBUG: pid 70605: extract_string_tokens: token: DISALLOW_TO_FAILOVER<br>2012-12-04 12:08:24 DEBUG: pid 70605: pool_config: disallow_to_failover on<br>2012-12-04 12:08:24 DEBUG: pid 70605: pool_config: slot number 0 flag: 0001<br>2012-12-04 12:08:24 DEBUG: pid 70605: key: backend_hostname1<br>2012-12-04 12:08:24 DEBUG: pid 70605: value: '<a href="http://prod2.db.power-soft.net">prod2.db.power-soft.net</a>' kind: 4<br>2012-12-04 12:08:24 DEBUG: pid 70605: key: backend_port1<br>2012-12-04 12:08:24 DEBUG: pid 70605: value: 5434 kind: 2<br>2012-12-04 12:08:24 DEBUG: pid 70605: pool_config: port slot number 1<br>2012-12-04 12:08:24 DEBUG: pid 70605: key: backend_weight1<br>2012-12-04 12:08:24 DEBUG: pid 70605: value: 1 kind: 2<br>2012-12-04 12:08:24 DEBUG: pid 70605: pool_config: weight slot number 1 weight: 1.000000<br>2012-12-04 12:08:24 DEBUG: pid 70605: key: backend_data_directory1<br>2012-12-04 12:08:24 DEBUG: pid 70605: value: '/db-array/db_repo/prod2/data' kind: 4<br>2012-12-04 12:08:24 DEBUG: pid 70605: key: backend_flag1<br>2012-12-04 12:08:24 DEBUG: pid 70605: value: 'DISALLOW_TO_FAILOVER' kind: 4<br>2012-12-04 12:08:24 DEBUG: pid 70605: extract_string_tokens: token: DISALLOW_TO_FAILOVER<br>2012-12-04 12:08:24 DEBUG: pid 70605: pool_config: disallow_to_failover on<br>2012-12-04 12:08:24 DEBUG: pid 70605: pool_config: slot number 1 flag: 0001<o:p></o:p></span></p></div></div><div><p class=MsoNormal><span style='font-size:12.0pt;font-family:"Times New Roman","serif"'><o:p> </o:p></span></p></div><p class=MsoNormal><o:p> </o:p></p></div></body></html>