From: | "Gnanakumar" <gnanam(at)zoniac(dot)com> |
---|---|
To: | <pgsql-admin(at)postgresql(dot)org> |
Subject: | Re: SQL statements not printed in pgpool log |
Date: | 2010-08-25 07:33:58 |
Message-ID: | 001f01cb4427$e2f4d2e0$a8de78a0$@com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Solution is here:
http://pgfoundry.org/pipermail/pgpool-general/2010-August/002910.html
-----Original Message-----
From: Gnanakumar [mailto:gnanam(at)zoniac(dot)com]
Sent: Tuesday, August 17, 2010 7:38 PM
To: pgsql-admin(at)postgresql(dot)org
Subject: RE: SQL statements not printed in pgpool log
Any ideas/suggestions?
-----Original Message-----
From: Gnanakumar [mailto:gnanam(at)zoniac(dot)com]
Sent: Friday, August 13, 2010 6:54 PM
To: pgsql-admin(at)postgresql(dot)org
Subject: SQL statements not printed in pgpool log
Hi,
Our production server is running PostgreSQL v8.2.3 on Red Hat Enterprise
Linux Server release 5 (Tikanga) and for database connection management
we're using pgpool-II v2.0.1.
I've been following with one of the issue I was facing with pgpool in its
forums and mailing list, but till now I've not any found any
response/solution there.
http://pgfoundry.org/pipermail/pgpool-general/2010-August/002861.html
Issue is:
Recently, we upgraded our JDBC driver 2 to JDBC driver 4. After changing to
JDBC driver 4, I'm not able to see none of the SQL statements printed in
pgpool log. What's going wrong?
Instead of SQL statements, I can see only the following lines:
2010-08-09 20:22:20 LOG: pid 20794: YYYYY
2010-08-09 20:22:20 LOG: pid 20794: YYYYY
2010-08-09 20:22:20 LOG: pid 20794: YYYYY
If I use JDBC driver 2, I don't have this problem. How do I fix this issue,
so that SQL statements are also printed in the pgpool log.
I know that this is not the right place to post, but I hope PostgreSQL
experts can assist me in the right direction to resolve this issue?
Regards,
Gnanam
From | Date | Subject | |
---|---|---|---|
Next Message | Gnanakumar | 2010-08-25 10:46:27 | Autovacuum daemon & TEMPORARY tables |
Previous Message | Gnanakumar | 2010-08-25 07:30:55 | last_autovacuum & last_autoanalyze showing NULL |