[pgpool-general: 1350] Parallel problem when do select BID, COUNT(*), MIN(aid), MAX(AID) from pgbench_accounts GROUP BY BID

魏荣 wei6rong at hotmail.com
Tue Jan 29 16:46:00 JST 2013


Excuse me,

I'm new for pgpool-II, finally I was able to properly configure pgpool in order to perform a parallel query.

But, here comes a trouble for me, I build my cluster in parallel mode, following the tutorial
http://pgpool.projects.pgfoundry.org/pgpool-II/doc/tutorial-zh_cn.html

I using commend of
/usr/pgsql-9.1/bin/pgbench -i -s 3 -h 172.26.181.187 -p 9999 -U postgres bench_parallel
to insert test data to pgpool, and it looks 3 backend postgre node is having the right data inserted.

but when i running commend of 
[root at 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
ERROR:  could not establish connection
DETAIL:  could not translate host name "devserver3" to address: Name or service not known

my pgpool node ip is 
172.26.181.187
which hostmane is devserver3

what's the problem?

//*******************************************************
Detail Discription:
3 postgres node is
172.26.184.35:5462
172.26.184.42:5463
172.26.184.45:5464
and systemdb in 
172.26.184.45:5462

if runs pgpool in 172.26.184.45
[root at 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 
 bid | count  |  min   |  max   
-----+--------+--------+--------
   1 | 100000 |      1 | 100000
   3 |  99999 | 200001 | 300000
 435 |      1 | 283914 | 283914
   2 | 100000 | 100001 | 200000
(4 rows)
gets the right result.

but if run pgpool in 172.26.181.187
[root at 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
ERROR:  could not establish connection
DETAIL:  could not translate host name "devserver3" to address: Name or service not known

and 
[root at zhengpengfei ~]# psql -h 172.26.181.187 -p 9999 -c "select * from pgbench_accounts where bid=435" bench_parallel -U postgres
  aid   | bid | abalance |                                        filler                                        
--------+-----+----------+--------------------------------------------------------------------------------------
 283914 | 435 |        0 |                                                                                     
(1 row)
also gets right result.
//*******************************************************

thanks at first and best regards


ryanwei

 		 	   		   		 	   		  
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20130129/adf74a76/attachment-0001.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: pgpool.conf.62.63.64.parallel
Type: application/octet-stream
Size: 24713 bytes
Desc: not available
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20130129/adf74a76/attachment-0001.obj>


More information about the pgpool-general mailing list