Mercurial > lada > lada-server
comparison 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 |
comparison
equal
deleted
inserted
replaced
| 1173:5239306ee55e | 1174:2e59a51d914f |
|---|---|
| 63 psql $DB_CONNECT_STRING --command \ | 63 psql $DB_CONNECT_STRING --command \ |
| 64 "CREATE DATABASE $DB_NAME WITH OWNER = $ROLE_NAME ENCODING = 'UTF8'" | 64 "CREATE DATABASE $DB_NAME WITH OWNER = $ROLE_NAME ENCODING = 'UTF8'" |
| 65 | 65 |
| 66 echo create extensions | 66 echo create extensions |
| 67 psql $DB_CONNECT_STRING -d $DB_NAME --command \ | 67 psql $DB_CONNECT_STRING -d $DB_NAME --command \ |
| 68 "CREATE EXTENSION IF NOT EXISTS postgis WITH SCHEMA public; | 68 "CREATE EXTENSION IF NOT EXISTS postgis WITH SCHEMA public;" |
| 69 CREATE EXTENSION IF NOT EXISTS pgaudit;" | 69 psql $DB_CONNECT_STRING -d $DB_NAME -f $DIR/pgaudit/analyze/sql/audit.sql |
| 70 | 70 |
| 71 echo create stammdaten schema | 71 echo create stammdaten schema |
| 72 psql -q $DB_CONNECT_STRING -d $DB_NAME -f $DIR/stammdaten_schema.sql | 72 psql -q $DB_CONNECT_STRING -d $DB_NAME -f $DIR/stammdaten_schema.sql |
| 73 | 73 |
| 74 echo create lada schema | 74 echo create lada schema |