On Tue, Dec 20, 2011 at 11:53 AM, akp geek <[email protected]> wrote: > Hi All - > > Is there way that we write the logs specific to only one user > in postgres? What I want to do is, Write the log files that are coming from > one user or block the log entry for a pariticular user. Can you please > help? We have postgres 9.0.4
I don't know about redirecting based on a specific user. You can. however, set which statements to log per user (alter user akp set log_statements='all') Not sure if that helps. Also if youlog to a syslog facility, it might be possible to get some additional capabilities that way. Chris Travers -- Sent via pgsql-general mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
