From: Joe Conway <mail@joeconway.com>
To: Svensson Peter <peter.svensson@smhi.se>
To: pgsql-performance@postgresql.org <pgsql-performance@postgresql.org>
Subject: Re: pgaudit and create postgis extension logs a lot inserts
Date: Thu, 18 Jan 2018 08:54:21 -0800
Message-ID: <514a9172-df28-56ab-ee65-2c01e5cbeb6a@joeconway.com> (raw)
In-Reply-To: <1CC6B04B8F153C4CBE486B1C7FD897430269E49962@WINVMSERV463.ad.smhi.se>
References: <1CC6B04B8F153C4CBE486B1C7FD897430269E49962@WINVMSERV463.ad.smhi.se>
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
Attachments:
[application/pgp-signature] signature.asc (818B, ../514a9172-df28-56ab-ee65-2c01e5cbeb6a@joeconway.com/2-signature.asc)
download
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: mail@joeconway.com, peter.svensson@smhi.se
Subject: Re: pgaudit and create postgis extension logs a lot inserts
In-Reply-To: <514a9172-df28-56ab-ee65-2c01e5cbeb6a@joeconway.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox