Re: pgaudit and create postgis extension logs a lot inserts - Mailing list pgsql-performance

From David Steele
Subject Re: pgaudit and create postgis extension logs a lot inserts
Date
Msg-id 551c26e7-c683-68b3-bd66-6285e859b7ae@pgmasters.net
Whole thread Raw
In response to pgaudit and create postgis extension logs a lot inserts  (Svensson Peter <peter.svensson@smhi.se>)
List pgsql-performance
Hi Peter,

On 1/18/18 7:12 AM, Svensson Peter wrote:
> 
> Also noticed that setting a session log to none (set
> pgaudit.log='none';)  overrides parameter from postgresql.conf,  but
> does not get logged, and then you can do whatever you want without any
> audit.
> I supposed this changing of  audit session log parameter should be
> logged to file?

pgaudit is not intended to audit the superuser and only a superuser can
set pgaudit.log.

However, you can limit superuser access with the setuser extension:
https://github.com/pgaudit/set_user

Regards,
-- 
-David
david@pgmasters.net


pgsql-performance by date:

Previous
From: David Steele
Date:
Subject: Re: pgaudit and create postgis extension logs a lot inserts
Next
From: Thomas Kellerer
Date:
Subject: Performance impact of lowering max_files_per_process