| From: | Chris Travers <chris(dot)travers(at)gmail(dot)com> |
|---|---|
| To: | akp geek <akpgeek(at)gmail(dot)com> |
| Cc: | pgsql-general <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Postgres Logs question |
| Date: | 2011-12-20 22:35:23 |
| Message-ID: | CAKt_Zfv=YOnN8fvX2snXsxrdp41Ura7pa0fZAuZTb0K1EB5i=Q@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Josh Kupershmidt | 2011-12-20 23:56:14 | Re: Escaping input from COPY |
| Previous Message | David Johnston | 2011-12-20 22:01:08 | Re: General coding question |