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.tarkeshwar....@ericsson.com> wrote: > Thanks for reply. We tried it but it is creating blank log file on > pg_log. > > > > *From:* Soni M [mailto:diptat...@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....@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
