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

2020-11-08 Thread Dhinakaran R
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 wrote: > Dhinakaran R wrote on 2020/11/07 02:03:22 > PM: > > > > > I had installed PostgreSQL 11.9 and pgaudit 1.3.

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

2020-11-07 Thread Brad Nicholson
Dhinakaran R 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 gett

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

2020-11-07 Thread Dhinakaran R
Hi Adrian There were no error messages from startup, even with debug level 1 I got only below. 2020-11-07 18:57:07.335 UTC [2290044]: LOG: database system was shut down at 2020-11-07 18:57:03 UTC 2020-11-07 18:57:07.335 UTC [2290044]: DEBUG: checkpoint record is at 0/1A3FE00 2020-11-07 18:5

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

2020-11-07 Thread Adrian Klaver
On 11/7/20 10:42 AM, Dhinakaran R wrote: Hello, 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 u