[Pgpool-general] PgAdmin and pgpool-II

Iñigo Martinez Lasala imartinez at vectorsf.com
Wed Jan 14 14:17:38 UTC 2009


Hi everybody.
 
We are testing pgpool-II 2.1 with postgres 8.2.11 in order to increase our
database server capacity for an on-line store. Most of database load are
read-only SELECTs.
 
Our preliminary tests show that pgpool-II is working fine. However we have
detected a problem when using PgAdmin-III as admin/query tool. When we
open PgAdmin-III, it shows a "mismatch" database error and secondary node
disconnects from pgpool. 
 
This problem does not happen if we access via psql command line, SQL
Manager, dbvisualizer or other SQL editor.
The problem happens when opening postgres database, so we dropped this
database and created it again via pgpool-II. However, problem reamains.
 
Is there any way to deal with this problem? Will be enough if we forbid
our users the use of pgAdmin-II?
 
Thanks in advance.
 
 
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://pgfoundry.org/pipermail/pgpool-general/attachments/20090114/7463b477/attachment.html 


More information about the Pgpool-general mailing list