per user logging

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 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.