Postgres Pro
Downloads
Home   >   mailing lists

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

From Joe Conway
Subject Re: pgaudit and create postgis extension logs a lot inserts
Date
Msg-id 514a9172-df28-56ab-ee65-2c01e5cbeb6a@joeconway.com
Whole thread Raw
In response to pgaudit and create postgis extension logs a lot inserts  (Svensson Peter <peter.svensson@smhi.se>)
Responses SV: pgaudit and create postgis extension logs a lot inserts
Re: pgaudit and create postgis extension logs a lot inserts
List pgsql-performance
Tree view 
On 01/18/2018 04:12 AM, Svensson Peter wrote:
> When I then install  postgis extension in a database it writes a huge
> amount of logs which slow down the server a lot.
> Not only table creation and functions are logged,  even  all inserts in 
> spatial_ref_sys are written to the audit-log.
>
> LOG:  AUDIT: SESSION,1,1,DDL,CREATE FUNCTION,,,"
> ......
> INSERT INTO ""spatial_ref_sys"" (""srid"",""auth_name"
> ....
>
> This behaviour make pgaudit useless in our environment due to the
> overhead in log-file write.

How often do you intend to install PostGIS? Disable pgaudit, install
PostGIS, enable pgaudit?

Joe

--
Crunchy Data - http://crunchydata.com
PostgreSQL Support for Secure Enterprises
Consulting, Training, & Open Source Development
Attachment

pgsql-performance by date:

Previous
From: Rambabu V
Date:
Subject: need help on memory allocation
Next
From: Laurenz Albe
Date:
Subject: Re: need help on memory allocation