[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.pgpool.net/pipermail/pgpool-general/attachments/20130129/92ec2349/attachment.htm>
    
    
More information about the pgpool-general
mailing list