Re: Log user creation and deletion

Поиск
Список
Период
Сортировка
От Chetan Suttraway
Тема Re: Log user creation and deletion
Дата
Msg-id BANLkTikJ5z5=scBbL-gaPFpkY1KfbHf+Dw@mail.gmail.com
обсуждение исходный текст
Ответ на Log user creation and deletion  (Mike Thomsen <mikerthomsen@gmail.com>)
Список pgsql-novice
Дерево обсуждения


On Fri, May 20, 2011 at 10:35 PM, Mike Thomsen <mikerthomsen@gmail.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@postgresql.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

EnterpriseDB Blog : http://blogs.enterprisedb.com




В списке pgsql-novice по дате отправления: