FAQ
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

Search Discussions

  • Chetan Suttraway at May 27, 2011 at 10:07 am

    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

Related Discussions

Discussion Navigation
viewthread | post
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