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

Re: Log user creation and deletion

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: (view raw, whole thread or download thread mbox)
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:

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;


EnterpriseDB Corporation
The Enterprise PostgreSQL Company

EnterpriseDB Blog :
Follow us on Twitter :

In response to

pgsql-novice by date

Next:From: Chetan SuttrawayDate: 2011-05-27 09:40:12
Subject: Re: Password problem
Previous:From: Robert WestDate: 2011-05-27 04:01:05
Subject: Password problem

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