DaVinci Resolve network project library PostgreSQL

updated: 

this guide assumes you can log in to your linux machine

install PostgreSQL

as Proxmox LXC using community scripts

var_os='debian' bash -c "$(curl -fsSL https://raw.githubusercontent.com/community-scripts/ProxmoxVE/main/ct/postgresql.sh)"

start the container and log in

OR from Debian repository

apt update && apt install postgresql postgresql-contrib

verify PostgreSQL is running

service postgresql status
ssh root@192.168.0.xxx

PostgreSQL is managed using terminal utility called ‘psql’

use linux user ‘postgres’ to login as superuser ‘postgres’

sudo -u postgres psql postgres

now you are logged in PostgreSQL shell

postgres=#

create new user

CREATE USER username WITH PASSWORD 'pass';

allow user to create databases

ALTER USER username WITH CREATEDB;

list users and their permissions

\du

to exit psql terminal

\q

open DaVinci Resolve, go to Network, Add Project Library, Create

choose your ‘newlibraryname’

use static IP address of your PostgreSQL instance

and the username and password of your new PostgreSQL user with database creation allowance

to see the recently created database
ssh root@192.168.0.xxx

log in to PostgreSQL shell

sudo -u postgres psql postgres

list databases

\l

exit

\q
to remove unused database
ssh root@192.168.0.xxx

backup important data, there is no going back

all users must be disconnected

log in to PostgreSQL shell

sudo -u postgres psql postgres

list databases

\l

remove database, quotes are only needed, if the database name starts with a number

DROP DATABASE "unused-database-name";

exit

\q