Shared PostgreSQL server

Good day all
I've just purchased DR Studio. I'd like to setup a PostgreSQL database to be shared, without having to always keep a workstation running or attached to the network. Desktops and laptops connect as needed per project.

We already have a headless Ubuntu Server 20.10 on the network, and would like to use this for the DB. I assume this would need to be version 9.5? Are there detailed instructions on how to go about this? Everything I have found so far has been either old, or lacking in any sort of detail, or on systems such as QNAS.

Any assistance would be greatly appreciated

The server documentation in the user guide should help you with the setup. I don't think it's OS specific. If you want something more Linux oriented Google Seth Goldin's article on PostgreSQL server setup on Linux.

It should be simple:

Code: Select all

apt update
apt install postgres-9.5


Check the manual for the configuration file settings. Make sure port 5432 is open.
Don't go any lower PSQL version that Resolve needs. You can generally go higher, but it's untested territory.

Thank you! I shall try that, and post findings.

My first attempt might have been with the wrong PostgreSQL version. I used the one that is listed in the current Ubuntu repository. I shall add the PostgreSQL repository directly, and it looks like 9.5 is the oldest supported version, so hopefully DR supports something newer some day.

For those landing here looking for the same.

I am currently running Davinci Resolve 17 beta 5 on Windows 10 as workstation
The server is Ubuntu 20.10, with PostgreSQL 9.5

In order to set this up, you install resolve on the workstations, as per normal (you can skip installing PostgreSQL here).

On the server, go to the PostgreSQL site, and add their repository (adjusting to your version / server as needed). Install 9.5 (this is the version DR requires, as the version that comes in the Ubuntu repository is far newer, and will not work).

I would suggest creating a new user specifically for DR or yourself, with only the permissions you need. Also, configure PostgreSQL to accept connections from your network.

I would recommend Webmin for a headless server, as this saves you hunting down settings. Just be sure to configure the PostgreSQL module for the 9.5 version.

Once this is setup, open resolve, and via the project manager and create a new PostgreSQL database, adding user credentials as set up earlier.

You can copy any existing projects to this new database, if you have a disk based on already, using ctrl-c to copy and then ctrl-v to paste in the new destination

You can now set a cron job to backup this database. Again I recommend Webmin to save time and complexity.

As a side note I'd like to mention that I've run successfully Davinci Resolve with PostgreSQL 12 in the past but I was not able to make it work with v13 as the authentication mechanism was changed and I was not able to make it work...

Perhaps when I get a moment I can try version 12 on a VM. I'm sure that would be a lot better than 9, which is nearing EOL.

It shouldn't be hard to get DR to connect to an additional one.

I didn't check versions the first time I tried, and actually did install the latest in the Ubuntu repository, but once the actual database was created, DR wouldn't create tables, and then would crash on all future starts (so I had to do a complete reinstall).