From: | Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com> |
---|---|
To: | Stephen Frost <sfrost(at)snowman(dot)net> |
Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, "pgsql-committers(at)postgresql(dot)org" <pgsql-committers(at)postgresql(dot)org> |
Subject: | Re: pgsql: Add pg_audit, an auditing extension |
Date: | 2015-05-15 09:56:24 |
Message-ID: | CAFj8pRDr4oUGjxevhy2UWneofuXxxPq-uekrY6jsHtgsUhZh_w@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-committers pgsql-hackers |
Hi
I am testing it, and output is strange
2015-05-15 11:49:25.046 CEST pavel postgres: LOG: AUDIT:
SESSION,1,1,DDL,DROP TABLE,,,drop table foo;,<not logged>
2015-05-15 11:49:25.046 CEST pavel postgres: STATEMENT: drop table foo;
2015-05-15 11:49:28.291 CEST pavel postgres: LOG: AUDIT:
SESSION,2,1,DDL,CREATE TABLE,,,"CREATE TABLE foo(a int, b int);",<not
logged>
2015-05-15 11:49:28.291 CEST pavel postgres: STATEMENT: CREATE TABLE foo(a
int, b int);
2015-05-15 11:49:31.486 CEST pavel postgres: LOG: AUDIT:
SESSION,3,1,WRITE,INSERT,,,"INSERT INTO foo VALUES(10,20);",<not logged>
2015-05-15 11:49:31.486 CEST pavel postgres: STATEMENT: INSERT INTO foo
VALUES(10,20);
2015-05-15 11:49:33.446 CEST pavel postgres: LOG: AUDIT:
SESSION,4,1,READ,SELECT,,,SELECT * FROM foo WHERE a = 10;,<not logged>
2015-05-15 11:49:33.446 CEST pavel postgres: STATEMENT: SELECT * FROM foo
WHERE a = 10;
I am missing object name, unexpected string <not logged>
configuration:
pg_audit.log = 'read, write, ddl'
2015-05-14 21:30 GMT+02:00 Stephen Frost <sfrost(at)snowman(dot)net>:
> * Stephen Frost (sfrost(at)snowman(dot)net) wrote:
> > I'll continue to think about it though, perhaps there's a way I can
> > disable logging as the superuser without it logging the role involved.
>
> Of course, it occured to me how to address this immediately after, even
> though it hadn't in the hour or so prior. I can just bump
> client_min_messages up to warning and then reset the role attributes...
>
> That appears to be working. Will push an update to fix this shortly.
>
> Thanks!
>
> Stephen
>
From | Date | Subject | |
---|---|---|---|
Next Message | Simon Riggs | 2015-05-15 10:04:40 | Re: pgsql: Separate block sampling functions |
Previous Message | Amit Kapila | 2015-05-15 06:21:00 | Re: Re: [COMMITTERS] pgsql: Map basebackup tablespaces using a tablespace_map file |
From | Date | Subject | |
---|---|---|---|
Next Message | Thom Brown | 2015-05-15 10:14:40 | Re: pgsql: Add pg_audit, an auditing extension |
Previous Message | Alexander Korotkov | 2015-05-15 08:31:35 | Re: KNN-GiST with recheck |