Mercurial > gemma

annotate schema/demo-data/README @ 176:0c0826063561

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Separate cluster and database specific commands This allows to setup more than one database with demo data on the same cluster by using only the script with database specific commands.
author Tom Gottfried <tom@intevation.de>
date Tue, 17 Jul 2018 12:01:14 +0200
parents 433a992befdb
children 5e38667f740c
Ignore whitespace changes - Everywhere: Within whitespace: At end of lines:
rev   line source
137
433a992befdb Added basic demo data.
Sascha Wilde <wilde@intevation.de>
parents:
diff changeset
1 ------------------------------------------------------------------------
433a992befdb Added basic demo data.
Sascha Wilde <wilde@intevation.de>
parents:
diff changeset
2 !!!!!! WARNING !!!!!!
433a992befdb Added basic demo data.
Sascha Wilde <wilde@intevation.de>
parents:
diff changeset
3
433a992befdb Added basic demo data.
Sascha Wilde <wilde@intevation.de>
parents:
diff changeset
4 Data within this directory is provided for the sole purpose of testing
433a992befdb Added basic demo data.
Sascha Wilde <wilde@intevation.de>
parents:
diff changeset
5 and demonstration of the Gemma software. It is neither intended nor
433a992befdb Added basic demo data.
Sascha Wilde <wilde@intevation.de>
parents:
diff changeset
6 suitable for any kind of production use.
433a992befdb Added basic demo data.
Sascha Wilde <wilde@intevation.de>
parents:
diff changeset
7
433a992befdb Added basic demo data.
Sascha Wilde <wilde@intevation.de>
parents:
diff changeset
8 THIS DATA CONTAINS UNSAFE AND PUBLICLY KNOWN PASSWORDS. DO NOT
176
0c0826063561 Separate cluster and database specific commands
Tom Gottfried <tom@intevation.de>
parents: 137
diff changeset
9 INSTALL ON REMOTE ACCESSIBLE SYSTEMS!
137
433a992befdb Added basic demo data.
Sascha Wilde <wilde@intevation.de>
parents:
diff changeset
10 ------------------------------------------------------------------------
433a992befdb Added basic demo data.
Sascha Wilde <wilde@intevation.de>
parents:
diff changeset
11
433a992befdb Added basic demo data.
Sascha Wilde <wilde@intevation.de>
parents:
diff changeset
12 Defined Users:
433a992befdb Added basic demo data.
Sascha Wilde <wilde@intevation.de>
parents:
diff changeset
13
433a992befdb Added basic demo data.
Sascha Wilde <wilde@intevation.de>
parents:
diff changeset
14 | Username | Password | Role | Country |
433a992befdb Added basic demo data.
Sascha Wilde <wilde@intevation.de>
parents:
diff changeset
15 |----------+----------+------------------------+---------|
433a992befdb Added basic demo data.
Sascha Wilde <wilde@intevation.de>
parents:
diff changeset
16 | sophie | so2Phie4 | System Administrator | AT |
433a992befdb Added basic demo data.
Sascha Wilde <wilde@intevation.de>
parents:
diff changeset
17 | lucian | lu2Cian4 | Waterway Administrator | RO |
433a992befdb Added basic demo data.
Sascha Wilde <wilde@intevation.de>
parents:
diff changeset
18 | oana | oa2Na2 | Waterway User | RO |
433a992befdb Added basic demo data.
Sascha Wilde <wilde@intevation.de>
parents:
diff changeset
19 | penka | pe2Nka3 | Waterway Administrator | BG |
433a992befdb Added basic demo data.
Sascha Wilde <wilde@intevation.de>
parents:
diff changeset
20 | vanja | va2Nja3 | Waterway User | BG |
433a992befdb Added basic demo data.
Sascha Wilde <wilde@intevation.de>
parents:
diff changeset
21
433a992befdb Added basic demo data.
Sascha Wilde <wilde@intevation.de>
parents:
diff changeset
22
433a992befdb Added basic demo data.
Sascha Wilde <wilde@intevation.de>
parents:
diff changeset
23 Installation:
433a992befdb Added basic demo data.
Sascha Wilde <wilde@intevation.de>
parents:
diff changeset
24
176
0c0826063561 Separate cluster and database specific commands
Tom Gottfried <tom@intevation.de>
parents: 137
diff changeset
25 We assume, you already have a database "gemma" with the Gemma schema
137
433a992befdb Added basic demo data.
Sascha Wilde <wilde@intevation.de>
parents:
diff changeset
26 in place.
433a992befdb Added basic demo data.
Sascha Wilde <wilde@intevation.de>
parents:
diff changeset
27
433a992befdb Added basic demo data.
Sascha Wilde <wilde@intevation.de>
parents:
diff changeset
28 As postgres super user ("postgres" on most default installations):
433a992befdb Added basic demo data.
Sascha Wilde <wilde@intevation.de>
parents:
diff changeset
29
176
0c0826063561 Separate cluster and database specific commands
Tom Gottfried <tom@intevation.de>
parents: 137
diff changeset
30 psql -f roles.sql -d gemma
137
433a992befdb Added basic demo data.
Sascha Wilde <wilde@intevation.de>
parents:
diff changeset
31 psql -f users.sql -d gemma
433a992befdb Added basic demo data.
Sascha Wilde <wilde@intevation.de>
parents:
diff changeset
32 psql -f responsibility_areas.sql -d gemma
433a992befdb Added basic demo data.
Sascha Wilde <wilde@intevation.de>
parents:
diff changeset
33
433a992befdb Added basic demo data.
Sascha Wilde <wilde@intevation.de>
parents:
diff changeset
34
433a992befdb Added basic demo data.
Sascha Wilde <wilde@intevation.de>
parents:
diff changeset
35 Acknowledgements:
433a992befdb Added basic demo data.
Sascha Wilde <wilde@intevation.de>
parents:
diff changeset
36
433a992befdb Added basic demo data.
Sascha Wilde <wilde@intevation.de>
parents:
diff changeset
37 The file `responsibility_areas.sql' contains information made with
433a992befdb Added basic demo data.
Sascha Wilde <wilde@intevation.de>
parents:
diff changeset
38 Natural Earth. Free vector and raster map data @ naturalearthdata.com.