Re: Postgres Logs question

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(dot)travers(at)gmail(dot)com>wrote:

> On Tue, Dec 20, 2011 at 11:53 AM, akp geek <akpgeek(at)gmail(dot)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
>