[postgis-tickets] [SCM] PostGIS branch stable-3.1 updated. 3.1.5-2-g1a90fe80e

[git at osgeo.org]

This is an automated email from the git hooks/post-receive script. It was
generated because a ref change was pushed to the repository containing
the project "PostGIS".

The branch, stable-3.1 has been updated
       via  1a90fe80e3887248d506ae2cabf9c9d84953213d (commit)
      from  cbbf3282a67587938e359d377632db3f34b529b5 (commit)

Those revisions listed above that are new to this repository have
not appeared on any other notification email; so we list those
revisions in full, below.

- Log -----------------------------------------------------------------
commit 1a90fe80e3887248d506ae2cabf9c9d84953213d
Author: Paul Ramsey <pramsey at cleverelephant.ca>
Date:   Wed Feb 2 13:01:10 2022 -0800

    Avoid log storm when installing with pgaudit enabled, references #5076

diff --git a/NEWS b/NEWS
index d3634184c..c8bccc0f8 100644
--- a/NEWS
+++ b/NEWS
@@ -1,6 +1,9 @@
 PostGIS 3.1.6
 2022/XX/XX
 
+* Bug Fixes
+  - #5076, Avoid log storm installed with pgaudit enabled (Paul Ramsey)
+
 
 PostGIS 3.1.5
 2022/02/01
@@ -16,7 +19,7 @@ PostGIS 3.1.5
   - #5046, Fix upgrades in absence of old library (Sandro Santilli)
   - #5069, search_path vulnerabilty during install/upgrade
            (Regina Obe)
-	- #5041, postgis_tiger_geocoder: loader_generate_script
+  - #5041, postgis_tiger_geocoder: loader_generate_script
            generates script with invalid syntax (Regna Obe)
 
 PostGIS 3.1.4
diff --git a/postgis/postgis.sql.in b/postgis/postgis.sql.in
index 181cbeae3..6032de066 100644
--- a/postgis/postgis.sql.in
+++ b/postgis/postgis.sql.in
@@ -61,6 +61,26 @@ BEGIN
 END
 $$ LANGUAGE 'plpgsql';
 
+-- Check that pgaudit is disabled or not installed
+-- Running extension creation with pgaudit enabled will result in a
+-- multi-gigabyte log storm for PgSQL <= 14
+DO $$
+DECLARE
+	pgalog text;
+BEGIN
+	SHOW pgaudit.log INTO pgalog;
+	RAISE DEBUG 'pgaudit is installed, pgaudit.log is set to ''%''', pgalog;
+	IF lower(pgalog) != 'none'
+	THEN
+		RAISE EXCEPTION 'PostGIS installation stopped: pgaudit.log is set to ''%''. Set pgaudit.log to ''none'' before installing PostGIS. You may re-enable pgaudit after installation is complete.', pgalog;
+	END IF;
+EXCEPTION
+	WHEN undefined_object THEN
+		RAISE DEBUG 'pgaudit is not installed';
+END;
+$$;
+
+
 -- Let the user know about a deprecated signature and its new name, if any
 CREATE OR REPLACE FUNCTION _postgis_deprecate(oldname text, newname text, version text)
 RETURNS void AS

-----------------------------------------------------------------------

Summary of changes:
 NEWS                   |  5 ++++-
 postgis/postgis.sql.in | 20 ++++++++++++++++++++
 2 files changed, 24 insertions(+), 1 deletion(-)


hooks/post-receive
-- 
PostGIS