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)