Mercurial > lada > lada-server
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,