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

From: "Brad Nicholson" <bradn(at)ca(dot)ibm(dot)com>
To: Dhinakaran R <dhiraam(dot)postgresql(at)gmail(dot)com>
Cc: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>, pgsql-general(at)lists(dot)postgresql(dot)org
Subject: RE: Not able to set pgaudit.log with pgaudit 1.3.2 in PostgreSQL 11.9
Date: 2020-11-07 20:08:36
Message-ID: OF9E98DED8.ED7E22F7-ON85258619.006E70B1-85258619.006EA694@notes.na.collabserv.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


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.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Susan Hurst 2020-11-07 20:44:52 Foreign Data Wrapper Handler
Previous Message Dhinakaran R 2020-11-07 19:03:22 Re: Not able to set pgaudit.log with pgaudit 1.3.2 in PostgreSQL 11.9