Re: Can I see the detailed log of query fired by particular Postgres client on Postgres server?

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 <
m(dot)tarkeshwar(dot)rao(at)ericsson(dot)com> wrote:

> Thanks for reply. We tried it but it is creating blank log file on
> pg_log.
>
>
>
> *From:* Soni M [mailto:diptatapa(at)gmail(dot)com]
> *Sent:* 13 August 2014 15:02
> *To:* M Tarkeshwar Rao
> *Cc:* pgsql-general(at)postgresql(dot)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(dot)tarkeshwar(dot)rao(at)ericsson(dot)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