From: | Chetan Suttraway <chetan(dot)suttraway(at)enterprisedb(dot)com> |
---|---|
To: | Mike Thomsen <mikerthomsen(at)gmail(dot)com> |
Cc: | pgsql-novice(at)postgresql(dot)org |
Subject: | Re: Log user creation and deletion |
Date: | 2011-05-27 09:36:58 |
Message-ID: | BANLkTikJ5z5=scBbL-gaPFpkY1KfbHf+Dw@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
On Fri, May 20, 2011 at 10:35 PM, Mike Thomsen <mikerthomsen(at)gmail(dot)com>wrote:
> Is it possible to log the creation and deletion of PostgreSQL users?
> I'm on PostgreSQL 8.4 and am trying to log using this approach:
>
> log_connections = true
> log_disconnections = true
> log_statement = ddl
> log_directory = /var/log/pgsql
> logging_collector = true
> log_rotation_age = 1440
>
> However, I didn't see anything about user creation/deletion in the
> logging documentation. Is it covered under "ddl" or something else?
>
> Thanks,
>
> Mike
>
> --
> Sent via pgsql-novice mailing list (pgsql-novice(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-novice
>
I tried the above values, and was able to see the log message related to
create user as:
LOG: autovacuum launcher started
LOG: database system is ready to accept connections
LOG: connection received: host=[local]
LOG: connection authorized: user=pg database=pg
LOG: statement: create user c3 identified by c3;
Regards,
Chetan
--
EnterpriseDB Corporation
The Enterprise PostgreSQL Company
Website: www.enterprisedb.com
EnterpriseDB Blog : http://blogs.enterprisedb.com
Follow us on Twitter : http://www.twitter.com/enterprisedb
From | Date | Subject | |
---|---|---|---|
Next Message | Chetan Suttraway | 2011-05-27 09:40:12 | Re: Password problem |
Previous Message | Robert West | 2011-05-27 04:01:05 | Password problem |