Thread: per user logging

per user logging

From
snacktime
Date:
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

Re: per user logging

From
Peter Eisentraut
Date:
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/

Re: per user logging

From
Richard Huxton
Date:
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

Re: per user logging

From
Tom Lane
Date:
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

Re: per user logging

From
snacktime
Date:


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.