Thread: per user logging

I'm pretty sure the answer to this is no, but just in case I've missed something.  Is there a way to configure the server so it only logs for specific users? 

Chris

snacktime wrote:
> I'm pretty sure the answer to this is no, but just in case I've
> missed something. Is there a way to configure the server so it only
> logs for specific users?

No, but you can configure PostgreSQL to insert the user name into each
log message, and then you could configure your syslog daemon to
redirect (or delete) messages according to that user name.

--
Peter Eisentraut
http://developer.postgresql.org/~petere/

snacktime wrote:
> I'm pretty sure the answer to this is no, but just in case I've missed
> something. Is there a way to configure the server so it only logs for
> specific users?

Look into "ALTER USER" - that lets you set (some) configuration options
on a per-user level. Don't know if the logging is one of the things you
can change though. Be interested in finding out though (hint, hint).

--
   Richard Huxton
   Archonet Ltd

Peter Eisentraut <peter_e@gmx.net> writes:
> snacktime wrote:
>> I'm pretty sure the answer to this is no, but just in case I've
>> missed something. Is there a way to configure the server so it only
>> logs for specific users?

> No, but you can configure PostgreSQL to insert the user name into each
> log message, and then you could configure your syslog daemon to
> redirect (or delete) messages according to that user name.

I believe it is possible for a superuser to do something like
"ALTER USER victim SET log_min_messages = whatever", so that the
log verbosity is different for different users.

            regards, tom lane

I'll try that and see how it works.