Mercurial > gemma

comparison 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
comparison
equal deleted inserted replaced
175:3f7053e53fa6 176:0c0826063561
4 Data within this directory is provided for the sole purpose of testing 4 Data within this directory is provided for the sole purpose of testing
5 and demonstration of the Gemma software. It is neither intended nor 5 and demonstration of the Gemma software. It is neither intended nor
6 suitable for any kind of production use. 6 suitable for any kind of production use.
7 7
8 THIS DATA CONTAINS UNSAFE AND PUBLICLY KNOWN PASSWORDS. DO NOT 8 THIS DATA CONTAINS UNSAFE AND PUBLICLY KNOWN PASSWORDS. DO NOT
9 INSTALL ON REMOTE ACCESSIBLE SYSTEMS! 9 INSTALL ON REMOTE ACCESSIBLE SYSTEMS!
10 ------------------------------------------------------------------------ 10 ------------------------------------------------------------------------
11 11
12 Defined Users: 12 Defined Users:
13 13
14 | Username | Password | Role | Country | 14 | Username | Password | Role | Country |
20 | vanja | va2Nja3 | Waterway User | BG | 20 | vanja | va2Nja3 | Waterway User | BG |
21 21
22 22
23 Installation: 23 Installation:
24 24
25 We assume, you already have a database "gemma" with the Genna schema 25 We assume, you already have a database "gemma" with the Gemma schema
26 in place. 26 in place.
27 27
28 As postgres super user ("postgres" on most default installations): 28 As postgres super user ("postgres" on most default installations):
29 29
30 psql -f roles.sql -d gemma
30 psql -f users.sql -d gemma 31 psql -f users.sql -d gemma
31 psql -f responsibility_areas.sql -d gemma 32 psql -f responsibility_areas.sql -d gemma
32 33
33 34
34 Acknowledgements: 35 Acknowledgements: