Thread: Can I see the detailed log of query fired by particular Postgres client on Postgres server?
Can I see the detailed log of query fired by particular Postgres client on Postgres server?
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
Re: Can I see the detailed log of query fired by particular Postgres client on Postgres server?
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
Re: Can I see the detailed log of query fired by particular Postgres client on Postgres server?
Thanks for reply. We tried it but it is creating blank log file on pg_log.
From: Soni M [mailto:diptatapa@gmail.com]
Sent: 13 August 2014 15:02
To: M Tarkeshwar Rao
Cc: pgsql-general@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 <m.tarkeshwar.rao@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
Re: Can I see the detailed log of query fired by particular Postgres client on Postgres server?
Thanks for reply. We tried it but it is creating blank log file on pg_log.
From: Soni M [mailto:diptatapa@gmail.com]
Sent: 13 August 2014 15:02
To: M Tarkeshwar Rao
Cc: pgsql-general@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 <m.tarkeshwar.rao@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