[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