Re: Help with configuring pgAudit

Oh okay!  I wasn't aware of the pg_settings system view.  Thanks for all
the info!

On Thu, Nov 21, 2019 at 1:36 PM Joe Conway <[email protected]> wrote:

> On 11/21/19 1:27 PM, Dave Hughes wrote:
> > Thank you so much for all your help!  I found out my issue on accident
> > actually.  I backed up all my user accounts into a SQL scripts and after
> > reviewing it, I noticed there were some lines that said:
> > ALTER ROLE postgres SET "pgauid.log" to 'Role';
> > ALTER ROLE postgres SET "pgaudit.log_level" to 'notice';
> > ALTER ROLE postgres SET "pgaudit.log_client" to 'on';
> >
> > I think these commands were leftover from when I ran an integrity check
> > on the pgaudit install (it crashed for other reasons) so it never
> > cleaned up these settings.  Once I reset those settings back, it's
> > working perfectly now.
> >
> > Thanks again for helping me getting this thing setup and working!
>
> Ah, makes sense now.
>
> For future reference, you can inspect the pgaudit (and other) active
> settings using the pg_settings system view, e.g.:
>
> select name, setting, source
> from pg_settings where name like 'pgaudit.%';
>             name            |     setting     |       source
> ----------------------------+-----------------+--------------------
>  pgaudit.log                | ddl, role, read | configuration file
>  pgaudit.log_catalog        | on              | configuration file
>  pgaudit.log_client         | off             | default
>  pgaudit.log_level          | log             | configuration file
>  pgaudit.log_parameter      | on              | configuration file
>  pgaudit.log_relation       | off             | configuration file
>  pgaudit.log_statement_once | off             | configuration file
>  pgaudit.role               |                 | default
> (8 rows)
>
> HTH,
>
> Joe
>
> --
> Crunchy Data - http://crunchydata.com
> PostgreSQL Support for Secure Enterprises
> Consulting, Training, & Open Source Development
>
>