Обсуждение: Logs

Hi All,

Where can i find more information on "user actions", i.e. say a user
logins in and does some querying via sql and then uses perl/c/c++
language to do some more querying. So how does postgresql keep track
of "user actions" in a sequential order?

Thanks,
Hrishi

Hrishikesh Deshmukh wrote:
> Hi All,
>
> Where can i find more information on "user actions", i.e. say a user
> logins in and does some querying via sql and then uses perl/c/c++
> language to do some more querying. So how does postgresql keep track
> of "user actions" in a sequential order?

PostgreSQL doesn't really distinguish between querying from psql and via
Perl/C/etc. It's all just SQL coming in from the client.

You can control what information is logged with the various settings in
postgresql.conf

http://www.postgresql.org/docs/8.0/static/runtime-config.html#RUNTIME-CONFIG-LOGGING

--
   Richard Huxton
   Archonet Ltd