<html><head><meta http-equiv="Content-Type" content="text/html charset=koi8-r"></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; ">ping. Can anybody help?<div><br><div><div>09.04.2013, в 15:24, Бородин Владимир <<a href="mailto:root@simply.name">root@simply.name</a>> написал(а):</div><br class="Apple-interchange-newline"><blockquote type="cite">Hi all.<br><br>I've read much information about failover in raw mode but I haven't found the solution yet.<br><br>I have 3 PostgreSQL nodes running in streaming replication mode - <a href="http://loadtest01g.domain.com">loadtest01g.domain.com</a> (master), <a href="http://loadtest02g.domain.com">loadtest02g.domain.com</a> <a href="http://andloadtest04g.domain.com">andloadtest04g.domain.com</a> (two replicas in hot_standby mode). All of them are listening 0.0.0.0:5432. All of them have the line below in pg_hba.conf (that is a disgusting idea but these hosts are for testing):<br>host all all 0.0.0.0/0 trust<br>I can connect to any of them with psql and issue select queries.<br><br>On loadtest01g I have installed pgpool-II-3.2 and taken the sample config with some modifications (backend addresses, debug_level and timeouts). Config - <a href="http://simply.name/tmp/pgpool.conf">http://simply.name/tmp/pgpool.conf</a> and log - <a href="http://simply.name/tmp/pgpool.log">http://simply.name/tmp/pgpool.log</a>.<br><br>I get the following problem: <br>pgpool does not failover to backend1 (loadtest02g) if backend0 (loadtest01g) fails down. According to log it catches the primary failure but doesn't send queries to one of the replicas.<br><br>The question is what do I do wrong?<br><br>--<br>Vladimir<br>_______________________________________________<br>pgpool-general mailing list<br><a href="mailto:pgpool-general@pgpool.net">pgpool-general@pgpool.net</a><br>http://www.pgpool.net/mailman/listinfo/pgpool-general<br></blockquote></div><br><div>
<div style="color: rgb(0, 0, 0); font-family: Helvetica; font-size: medium; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-align: -webkit-auto; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; "><div><br class="Apple-interchange-newline">--</div><div>Vladimir</div><div><br></div></div><br class="Apple-interchange-newline" style="color: rgb(0, 0, 0); font-family: Helvetica; font-size: medium; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-align: -webkit-auto; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; "><br class="Apple-interchange-newline">
</div>
<br></div></body></html>