<html>
<head>
<style><!--
.hmmessage P
{
margin:0px;
padding:0px
}
body.hmmessage
{
font-size: 10pt;
font-family:΢ÈíÑźÚ
}
--></style></head>
<body class='hmmessage'><div dir='ltr'>
Excuse me,<br><div><div dir="ltr"><pre><br>I'm new for pgpool-II, finally I was able to properly configure pgpool in order to perform a parallel query.<br><br>But, here comes a trouble for me, I build my cluster in parallel mode, following the tutorial<br>http://pgpool.projects.pgfoundry.org/pgpool-II/doc/tutorial-zh_cn.html<br><br>I using commend of<br>/usr/pgsql-9.1/bin/pgbench -i -s 3 -h 172.26.181.187 -p 9999 -U postgres bench_parallel<br>to insert test data to pgpool, and it looks 3 backend postgre node is having the right data inserted.<br><br>but when i running commend of <br>[root@zhengpengfei ~]# psql -h 172.26.181.187 -p 9999 -c "select BID,COUNT(*),MIN(aid),MAX(AID) from pgbench_accounts GROUP BY BID" bench_parallel -U postgres<br>ERROR: could not establish connection<br>DETAIL: could not translate host name "devserver3" to address: Name or service not known<br><br>my pgpool node ip is <br>172.26.181.187<br>which hostmane is devserver3<br><br>what's the problem?<br><br>//*******************************************************<br>Detail Discription:<br>3 postgres node is<br>172.26.184.35:5462<br>172.26.184.42:5463<br>172.26.184.45:5464<br>and systemdb in <br>172.26.184.45:5462<br><br>if runs pgpool in 172.26.184.45<br>[root@zhengpengfei ~]# psql -h 172.26.184.45 -p 9999 -c "select BID,COUNT(*),MIN(aid),MAX(AID) from pgbench_accounts GROUP BY BID" bench_parallel -U postgres <br> bid | count | min | max <br>-----+--------+--------+--------<br> 1 | 100000 | 1 | 100000<br> 3 | 99999 | 200001 | 300000<br> 435 | 1 | 283914 | 283914<br> 2 | 100000 | 100001 | 200000<br>(4 rows)<br>gets the right result.<br><br>but if run pgpool in 172.26.181.187<br>[root@zhengpengfei ~]# psql -h 172.26.181.187 -p 9999 -c "select BID,COUNT(*),MIN(aid),MAX(AID) from pgbench_accounts GROUP BY BID" bench_parallel -U postgres<br>ERROR: could not establish connection<br>DETAIL: could not translate host name "devserver3" to address: Name or service not known<br><br>and <br>[root@zhengpengfei ~]# psql -h 172.26.181.187 -p 9999 -c "select * from pgbench_accounts where bid=435" bench_parallel -U postgres<br> aid | bid | abalance | filler <br>--------+-----+----------+--------------------------------------------------------------------------------------<br> 283914 | 435 | 0 | <br>(1 row)<br>also gets right result.<br>//*******************************************************<br><br>thanks at first and best regards<br><br><br>ryanwei<br><br></pre> </div></div> </div></body>
</html>