Re: Postgres Logs question
| От | akp geek |
|---|---|
| Тема | Re: Postgres Logs question |
| Дата | |
| Msg-id | CACnhOfJG+WewsbWCMCA5w=Mtd4yLSoFL7tNoWcLBBe38NBSeGA@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: Postgres Logs question (Chris Travers <chris.travers@gmail.com>) |
| Список | pgsql-general |
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.
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.travers@gmail.com> wrote:
I don't know about redirecting based on a specific user. You can.On Tue, Dec 20, 2011 at 11:53 AM, akp geek <akpgeek@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
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
В списке pgsql-general по дате отправления: