FAQ

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

Website: www.enterprisedb.com
EnterpriseDB Blog : http://blogs.enterprisedb.com
Follow us on Twitter : http://www.twitter.com/enterprisedb

Search Discussions

Discussion Posts

Previous

Related Discussions

Discussion Navigation
viewthread | post
posts ‹ prev | 2 of 2 | next ›
Discussion Overview
grouppgsql-novice @
categoriespostgresql
postedMay 20, '11 at 5:05p
activeMay 27, '11 at 10:07a
posts2
users2
websitepostgresql.org
irc#postgresql

2 users in discussion

Chetan Suttraway: 1 post Mike Thomsen: 1 post

People

Translate

site design / logo © 2022 Grokbase