| From: | Joe Conway <mail(at)joeconway(dot)com> |
|---|---|
| To: | Svensson Peter <peter(dot)svensson(at)smhi(dot)se>, "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org> |
| Subject: | Re: pgaudit and create postgis extension logs a lot inserts |
| Date: | 2018-01-18 16:54:21 |
| Message-ID: | 514a9172-df28-56ab-ee65-2c01e5cbeb6a@joeconway.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Laurenz Albe | 2018-01-19 10:07:35 | Re: need help on memory allocation |
| Previous Message | Rambabu V | 2018-01-18 15:25:31 | need help on memory allocation |