Обсуждение: Urgent please: PGPOOL II 2.3.3 hang in ssl mode

I am using Pgpool II 2.3.3 with Postgresql 8.3.8.

When I use command \l at postgresql client the query is working perfectly.

But if I used the command from pgpool II client which is connected with postgresql in ssl mode, it gets hang.

Again if I use the command from pgpool II client in non-ssl mode, it works fine.

Any help please.


When I use the following query it works :

SELECT d.datname as "Name",
       r.rolname as "Owner",
       d.encoding as "Encoding"
FROM pg_catalog.pg_database d
  JOIN pg_catalog.pg_roles r ON d.datdba = r.oid
ORDER BY 1

But the following query does not work:

SELECT d.datname as "Name",
       r.rolname as "Owner",
       pg_catalog.pg_encoding_to_char(d.encoding) as "Encoding"
FROM pg_catalog.pg_database d
  JOIN pg_catalog.pg_roles r ON d.datdba = r.oid
ORDER BY 1

The function call "pg_catalog.pg_encoding_to_char(d.encoding)" somehow makes the Pgpool hang in SSL mode.

I found that the following works fine:

postgres=# create table mytab  as select relname from pg_class limit 37;
SELECT
postgres=# select pg_relation_size('mytab');
 pg_relation_size
------------------
             8192
(1 row)

But, the folllowing hangs:

postgres=# select relname from pg_class limit 38;

Any help please. Its urgent.

AI Rumman <rummandba@gmail.com> writes:
> The function call "pg_catalog.pg_encoding_to_char(d.encoding)" somehow makes
> the Pgpool hang in SSL mode.

pg_encoding_to_char returns type "name", maybe that's somehow confusing
pgpool?  Although I seriously doubt there's any connection to SSL mode.

            regards, tom lane