diff db_schema/setup-db.sh @ 1174:2e59a51d914f pgaudit

Integrate Audit Log Analyzer. XXX: Startup of the Log Analyzer will only be successful when patched because of a bug that prevents it from recovering from errors (i.e. while postgres is starting).
author Tom Gottfried <tom@intevation.de>
date Fri, 11 Nov 2016 16:52:49 +0100
parents 5239306ee55e
children
line wrap: on
line diff
--- a/db_schema/setup-db.sh	Fri Nov 11 16:50:00 2016 +0100
+++ b/db_schema/setup-db.sh	Fri Nov 11 16:52:49 2016 +0100
@@ -65,8 +65,8 @@
 
 echo create extensions
 psql $DB_CONNECT_STRING -d $DB_NAME  --command  \
-     "CREATE EXTENSION IF NOT EXISTS postgis WITH SCHEMA public;
-      CREATE EXTENSION IF NOT EXISTS pgaudit;"
+     "CREATE EXTENSION IF NOT EXISTS postgis WITH SCHEMA public;"
+psql $DB_CONNECT_STRING -d $DB_NAME -f $DIR/pgaudit/analyze/sql/audit.sql
 
 echo create stammdaten schema
 psql -q $DB_CONNECT_STRING -d $DB_NAME -f $DIR/stammdaten_schema.sql
This site is hosted by Intevation GmbH (Datenschutzerklärung und Impressum | Privacy Policy and Imprint)