diff db_schema/setup-db.sh @ 1170:74e5b9630064 pgaudit

Log parameters in statements. This will allow later on to fetch parameters that changed and show them to the client.
author Tom Gottfried <tom@intevation.de>
date Wed, 09 Nov 2016 20:01:00 +0100
parents ea6b062e5305
children 5239306ee55e
line wrap: on
line diff
--- a/db_schema/setup-db.sh	Wed Nov 09 17:33:16 2016 +0100
+++ b/db_schema/setup-db.sh	Wed Nov 09 20:01:00 2016 +0100
@@ -85,6 +85,7 @@
 echo configure audit trail
 psql $DB_CONNECT_STRING -d $DB_NAME --command \
      "ALTER DATABASE $DB_NAME SET pgaudit.role TO '$AUDITOR_ROLE';
+      ALTER DATABASE $DB_NAME SET pgaudit.log_parameter TO on;
       GRANT UPDATE, DELETE ON
           land.probe,
           land.kommentar_p,
This site is hosted by Intevation GmbH (Datenschutzerklärung und Impressum | Privacy Policy and Imprint)