From: Scott Marlowe <scott.marlowe@gmail.com>
To: Kasia Tuszynska <ktuszynska@esri.com>
Cc: pgsql-admin@postgresql.org <pgsql-admin@postgresql.org>
Subject: Re: logging a single user session
Date: Tue, 24 Mar 2009 16:53:26 -0600
Message-ID: <dcc563d10903241553o7a7004e1x1c08abdd6dd5292f@mail.gmail.com> (raw)
In-Reply-To: <232B5217AD58584C87019E8933556D11011EE37A03@redmx2.esri.com>
References: <7844.217.117.29.29.1237475481.squirrel@fmf.vgtu.lt>
<49C267D1.5040909@gmail.com>
<232B5217AD58584C87019E8933556D11011EE37A03@redmx2.esri.com>
On Tue, Mar 24, 2009 at 11:43 AM, Kasia Tuszynska <ktuszynska@esri.com> wrote:
> Hi Everybody,
> I am convinced that this question has been posted on either the novice or admin forum but I can not find the answer - so sorry for the repeat.
>
> I would like to log (or trace) the output from a single user session, what parameters in the postgresql.conf do I set to what to achieve that?
I think you can do it from a psql prompt:
alter user smarlowe set log_statement='ddl';
where you could replace ddl with none, ddl, mod, all if I remember correctly.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: scott.marlowe@gmail.com, ktuszynska@esri.com
Subject: Re: logging a single user session
In-Reply-To: <dcc563d10903241553o7a7004e1x1c08abdd6dd5292f@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox