Re: Not able to set pgaudit.log with pgaudit 1.3.2 in PostgreSQL 11.9

Hi Brad

Thank you for pointing this out, my bad I was looking at the wrong version
readme file. It's working after removing misc_set.

On Sun, 8 Nov 2020 at 01:38, Brad Nicholson <bradn(at)ca(dot)ibm(dot)com> wrote:

> Dhinakaran R <dhiraam(dot)postgresql(at)gmail(dot)com> wrote on 2020/11/07 02:03:22
> PM:
>
>
> > > I had installed PostgreSQL 11.9 and pgaudit 1.3.2. updated
> > > shared_preload_libraries, restarted PostgreSQL, created an extension
> for
> > > pgaudit and set parameters for pgaudit in postgresql.conf. But
> > > surprisingly pgaudit.log is not getting picked up and neither able to
> > > set it manually.
>
>
> > > pgaudit.log = 'write, role, ddl, misc_set'
>
> misc_set was added in pgAudit 1.4, if you remove that it will likely work.
>
> pgAudit should probably log when it has an invalid parameter.
>
> Brad.
>
>