...
| Code Block |
|---|
# access the database via psql psql --port=5432 postgres # create superuser for IT/admins and pipeline TDs CREATE ROLE postgres LOGIN password 'postgres'; ALTER USER root CREATEDB; ALTER USER root CREATEROLE; ALTER USER root SUPERUSER; # create user that is allowed to create new databases CREATE ROLE dbuser LOGIN password 'dbuser'; ALTER USER root CREATEDB; # exit the database from psql \q |
Move to a supervisor/lead artists workstation.
Now create a new library inside the software. Use the dbuser to connect to the databas.
...
We have the main library for facility Munich running.
Configure subscriber server
Now let’s setup a database in a different facility
| Code Block |
|---|
# create database cluster initdb -D /var/lib/postgresql/daselement-munich_subscription # start the database cluster pg_ctl -D /var/lib/postgresql/daselement-munich_subscription start |
...