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

魏荣 wei6rong at hotmail.com
Tue Jan 29 11:58:06 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?

thanks at first and best regards


ryanwei
 		 	   		  
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20130129/92ec2349/attachment-0001.html>


More information about the pgpool-general mailing list