Installation DaVinci Resolve Project Server

Debian 11 Container
apt-get install postgresql
apt-get install sudo
sudo -u postgres psql
- ALTER USER postgres PASSWORD 'meinpasswort';
- update pg_database set datallowconn = TRUE where datname = 'template0';
- \c template0
- update pg_database set datistemplate = FALSE where datname = 'template1';
- drop database template1;
- create database template1 with template = template0 encoding = 'UTF8';
- update pg_database set datistemplate = TRUE where datname = 'template1';
- \c template1
- update pg_database set datallowconn = FALSE where datname = 'template0';
nano /etc/postgresql/13/main/postgresql.conf
- listen_addresses = '*'
nano /etc/postgresql/13/main/pg_hba.conf
- host all all 141.62.111.89/32 md5
- host haw50 haw50 0.0.0.0/0 md5
pg_ctlcluster 13 main restart
apt-get install ufw
sudo ufw allow 5432/tcp
in Resolve:
danach in Resolve Disconnect
pgadmin installieren
neuen Benutzer anlegen
in Resolve neu mit haw50-User connecten