Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-novice by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group