Log user creation and deletion

From: Mike Thomsen <mikerthomsen(at)gmail(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Log user creation and deletion
Date: 2011-05-20 17:05:09
Message-ID: BANLkTimzsdo_Aavru5q2XANPOtnozWsqZg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

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

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message e-letter 2011-05-22 07:57:08 how to select rows for a sum function
Previous Message Oliveiros d'Azevedo Cristina 2011-05-19 12:24:38 Re: error in server connection