thanks for the help. The way I did it was I have log_statement=all in the postgresql.conf then I have alter user akp set log_statements='none';
Still it writes the log for akp. I am still missing some configuration to make sure I don't write log for the user akp Regards On Tue, Dec 20, 2011 at 5:35 PM, Chris Travers <chris.trav...@gmail.com>wrote: > On Tue, Dec 20, 2011 at 11:53 AM, akp geek <akpg...@gmail.com> 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 >
