Urgent please: PGPOOL II 2.3.3 hang in ssl mode
От | AI Rumman |
---|---|
Тема | Urgent please: PGPOOL II 2.3.3 hang in ssl mode |
Дата | |
Msg-id | m2l2a7905441005082358z90667411p13e29552204b9ac6@mail.gmail.com обсуждение исходный текст |
Ответы |
Re: Urgent please: PGPOOL II 2.3.3 hang in ssl mode
|
Список | pgsql-general |
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.
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.
В списке pgsql-general по дате отправления: