Postgres Pro
Downloads
Home   >   mailing lists

Re: Can I see the detailed log of query fired by particular Postgres client on Postgres server? - Mailing list pgsql-general

From Soni M
Subject Re: Can I see the detailed log of query fired by particular Postgres client on Postgres server?
Date
Msg-id CAAMgDX=A_cFyyqdf0tU6DagoTd2vTkve0sFPjbJti0mQwDzZPg@mail.gmail.com
Whole thread Raw
In response to Re: Can I see the detailed log of query fired by particular Postgres client on Postgres server?  (M Tarkeshwar Rao <m.tarkeshwar.rao@ericsson.com>)
List pgsql-general
Tree view
check you postgresql.conf, where you're heading your log, log_destination, etc.


On Wed, Aug 13, 2014 at 4:37 PM, M Tarkeshwar Rao <m.tarkeshwar.rao@ericsson.com> wrote:

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




--
Regards,

Soni Maula Harriz

pgsql-general by date:

Previous
From: M Tarkeshwar Rao
Date:
Subject: Re: Can I see the detailed log of query fired by particular Postgres client on Postgres server?
Next
From: Marti Raudsepp
Date:
Subject: Re: Postgres 9.3 tuning advice