[Pgpool-general] PgAdmin and pgpool-II

[Tatsuo Ishii]

Can you run pgpool with debug option (-d) and show an output so that I
could figure out what causes the problem?
--
Tatsuo Ishii
SRA OSS, Inc. Japan

> 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.
>  
>