Discussion:
Can I see the detailed log of query fired by particular Postgres client on Postgres server?
M Tarkeshwar Rao
2014-08-13 09:21:23 UTC
Permalink
Hi all,

Can I see the detailed log of query fired by particular Postgres client on Postgres server?
This client might be any java application or any console Postgres client.
I want this for our debugging purpose.

Regards
Tarkeshwar
Soni M
2014-08-13 09:32:11 UTC
Permalink
On each session created by the client, run set log_statement to 'all'
before firing your query


On Wed, Aug 13, 2014 at 4:21 PM, M Tarkeshwar Rao <
Post by M Tarkeshwar Rao
Hi all,
Can I see the detailed log of query fired by particular Postgres client
on Postgres server?
This client might be any java application or any console Postgres client.
I want this for our debugging purpose.
Regards
Tarkeshwar
--
Regards,

Soni Maula Harriz
M Tarkeshwar Rao
2014-08-13 09:37:01 UTC
Permalink
Thanks for reply. We tried it but it is creating blank log file on pg_log.

From: Soni M [mailto:***@gmail.com]
Sent: 13 August 2014 15:02
To: M Tarkeshwar Rao
Cc: pgsql-***@postgresql.org
Subject: Re: [GENERAL] Can I see the detailed log of query fired by particular Postgres client on Postgres server?

On each session created by the client, run set log_statement to 'all' before firing your query

On Wed, Aug 13, 2014 at 4:21 PM, M Tarkeshwar Rao <***@ericsson.com<mailto:***@ericsson.com>> wrote:
Hi all,

Can I see the detailed log of query fired by particular Postgres client on Postgres server?
This client might be any java application or any console Postgres client.
I want this for our debugging purpose.

Regards
Tarkeshwar
--
Regards,

Soni Maula Harriz
Soni M
2014-08-13 09:41:55 UTC
Permalink
check you postgresql.conf, where you're heading your log, log_destination,
etc.
http://www.postgresql.org/docs/9.1/static/runtime-config-logging.html




On Wed, Aug 13, 2014 at 4:37 PM, M Tarkeshwar Rao <
Post by M Tarkeshwar Rao
Thanks for reply. We tried it but it is creating blank log file on pg_log.
*Sent:* 13 August 2014 15:02
*To:* M Tarkeshwar Rao
*Subject:* Re: [GENERAL] Can I see the detailed log of query fired by
particular Postgres client on Postgres server?
On each session created by the client, run set log_statement to 'all'
before firing your query
On Wed, Aug 13, 2014 at 4:21 PM, M Tarkeshwar Rao <
Hi all,
Can I see the detailed log of query fired by particular Postgres client
on Postgres server?
This client might be any java application or any console Postgres client.
I want this for our debugging purpose.
Regards
Tarkeshwar
--
Regards,
Soni Maula Harriz
--
Regards,

Soni Maula Harriz
Loading...