====== 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: \\ {{:it:pasted:resolveprojectserver-20220208-161149.png}} * danach in Resolve Disconnect * pgadmin installieren * neuen Benutzer anlegen * {{:it:pasted:resolveprojectserver-20220208-161430.png}} * {{:it:pasted:resolveprojectserver-20220208-161545.png}} * {{:it:pasted:resolveprojectserver-20220208-161659.png}} * {{:it:pasted:resolveprojectserver-20220208-161722.png}} * in Resolve neu mit haw50-User connecten