Database initialization
You can use pgAdmin to access and manage the database server.
Note
By clicking the link you can learn how to Install pgAdmin
Process
In pgAdmin4
Connect to the database server
Create a new database with UTF8 encoding
E.g. tww_demo, avoid spaces, dots, uppercases and special characters As proposed in https://stackoverflow.com/questions/2878248/postgresql-naming-conventions
Create minimal roles and access
TWW can be installed per database cluster using the new TEKSI Module Management Tool. They only have to be installed once!
See the current TMMT Documentation for a step by step help
It is highly recommended to use these when using TWW in a production environment.
Install data model with or without demodata
See the current TMMT Documentation for a step by step help
After you have setup successfully the database with or without demodata, you can check the schemata via pgAdmin
There will be 6 schemas in the database
public
tww_app
tww_od
tww_sys
tww_vl
pg2ili_abwasser