<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; ">Thanks for reply. Here [1] I found such information:<div><br><div><span style="font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 12px; background-color: rgb(255, 255, 255); ">"Failover can be performed in raw mode if multiple servers are defined. pgpool-II usually accesses the backend specified by </span><code style="font-size: 12px; background-color: rgb(255, 255, 255); ">backend_hostname0</code><span style="font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 12px; background-color: rgb(255, 255, 255); "> during normal operation. If the backend_hostname0 fails for some reason, pgpool-II tries to access the backend specified by backend_hostname1. If that fails, pgpool-II tries the backend_hostname2, 3 and so on."</span></div><div><span style="font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 12px; background-color: rgb(255, 255, 255); "><br></span></div><div><font face="Verdana, Arial, Helvetica, sans-serif">And I want to see the described above behavior. Could you give an example of what should I write to failover_command in that case?</font></div><div><br></div><div>[1] <a href="http://pgpool.projects.pgfoundry.org/pgpool-II/doc/pgpool-en.html">http://pgpool.projects.pgfoundry.org/pgpool-II/doc/pgpool-en.html</a></div><div><br><div><div>11.04.2013, в 17:51, Tatsuo Ishii <<a href="mailto:ishii@postgresql.org">ishii@postgresql.org</a>> написал(а):</div><br class="Apple-interchange-newline"><blockquote type="cite">You need to set failover_command. Yours is empty, so nothing will<br>happen.<br>--<br>Tatsuo Ishii<br>SRA OSS, Inc. Japan<br>English: <a href="http://www.sraoss.co.jp/index_en.php">http://www.sraoss.co.jp/index_en.php</a><br>Japanese: <a href="http://www.sraoss.co.jp">http://www.sraoss.co.jp</a><br><br><blockquote type="cite">ping. Can anybody help?<br><br>09.04.2013, в 15:24, Бородин Владимир <<a href="mailto:root@simply.name">root@simply.name</a>> написал(а):<br><br><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><br><br>--<br>Vladimir<br><br><br><br><br></blockquote></blockquote></div><br><div apple-content-edited="true">
<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></div></div></div></body></html>