Installing PostgreSQL 13 on QNAP for Davinci Resolve

0-postgres-qnap-install.md

Installing PostgreSQL 13 on QNAP for Davinci Resolve

This guide aims to provide an updated overview on installing PostgreSQL 13 within a QNAP NAS for use as a database inside Davinci Resolve.

The previous guide(s) created by QNAP are somewhat irrelevant as Davinci Resolve, Container Station and QTS/QuTS have since undergone major upgrades.

These original guides are linked below for reference:

https://www.qnap.com/en/how-to/tutorial/article/how-can-i-migrate-my-davinci-resolve-studio-database-to-a-newer-version-of-qts

https://www.qnap.com/en/how-to/tutorial/article/how-can-i-collaborate-davinci-resolve-studio-16-between-macos-and-windows-in-qts-4-4-3

In order to create a PostgreSQL Server container for Resolve, we must follow a few steps:

• Create shared folder and structure
• Set up Docker container in Container Station
• Configure database access
• Connect and use database in Resolve

1. Shared Folder

1. Under Storage and Disks, create a new Shared Folder:

   

Note

Example settings for sample shared folder:

2. Create a folder inside the share to use as the data folder. I've created postgres for ease of identification:

   

2. Container Station

1. Click on Explore, then search for postgres.

2. Click Deploy next to the official postgres Docker Hub container:

   

3. Select the latest version of Postgres 13. Personally, I've selected 13-alpine as that this uses a leaner image.

   

4. Set the the name of your docker container, add port 5432 under host then click Advanced

   

5. Under Environments tab, add the POSTGRES_PASSWORD variable and password parameter:

   

6. Under Storage, Select Bind Mount Host Path

   

7. Delete the first Volume entry.

8. Under the Host entry, enter/locate the respective Share and folder location created earlier.

9. Set the properties to RW (Read/Write) and add the relevant Container location: /var/lib/postgresql/data

   

10. Click Apply, then click Next on the subsequent window.

11. You will see a summary as below. Click Finish when done

    

Note

The container should download and start automatically:

3. Database Configuration

Next we need to allow access to the databse from remote hosts.

Edit the pg_hba.conf and postgresql.conf files in our postgres folder under the created share.

Edit using Text Editor

This can be done by editing the files through the Share folder or by using File Station directly on the NAS (provided Text Editor is installed).

Edit using SSH or shell

This can also be done via ssh to the NAS share folder or even thru the Docker Container itself.

Edit the respective configuration files accordingly using vi, or even a simple shell commmand such as:

echo "listen_addresses = '*' " >> /var/lib/postgresql/data/postgresql.conf

echo "host all all <IP ADDRESS>/<SUBNET> trust" >> /var/lib/postgresql/data/pg_hba.conf

Make sure to replace IP ADDRESS and SUBNET values with appropriate ones relevant to your network.

To edit using a shell prompt within the container itself, click on the container name, then Exceute.

With /bin/bash selected, click Execute in the popup.

This will bring the bash prompt for editing

4. Database Access

Add the database into Resolve as per the guide:

https://www.qnap.com/en/how-to/tutorial/article/how-can-i-collaborate-davinci-resolve-studio-16-between-macos-and-windows-in-qts-4-4-3

Great job, it worked for me, with a little modification.

Where says
echo "host all all / trust" >> /var/lib/postgresql/data/pg_hba.conf

It is correct without the "/" separator
echo "host all all trust" >> /var/lib/postgresql/data/pg_hba.conf

Thank you Asim - I just tried this, and it works great.
I am very grateful for your detailed explanation. I found it easiest to modify the pg_hba.conf and postgresql.conf files right in Container Station on the QNAP with the EXECUTE Console commands, in the bin/bash window, simply by using vi to modify the files. I am very very grateful to you. You are a wonderful person.

Bob Zelin

Absoulte novice and have no idea about code / terminal. I'm a videographer / content creater with a QNAP NAS who is trying to get this to work. I had this working untill I restarted my NAS, now it's in a never ending loop of re-starting the Docker container. Everything is easy to follow with the images untill you get to the "database re-configure" section, was totally lost and was above my head. I'm pretty sure thats where I've messed up. Could you please add some images there? as I have no clue on how to fix it or redo it

Hi - I have no idea of what you are trying to do. Setting up a PostgreSQL 13 database on QNAP for Resolve ? It is a complicated process to setup a PostgreSQL 13 Database for Resolve in a container in a QNAP. Professional IT people or video engineers are the ones that do it. Bob Zelin On Aug 26, 2024, at 12:44 PM, JLGarbutt ***@***.***> wrote: @JLGarbutt commented on this gist. Absoulte novice and have no idea about code / terminal. I'm a videographer / content creater with a QNAP NAS who is trying to get this to work. I had this working untill I restarted my NAS, now it's in a never ending loop of re-starting the Docker container. Everything is easy to follow with the images untill you get to the "database re-configure" section, was totally lost and was above my head. I'm pretty sure thats where I've messed up. Could you please add some images there? as I have no clue on how to fix it or redo it — Reply to this email directly, view it on GitHub or unsubscribe . You are receiving this email because you commented on the thread. Triage notifications on the go with GitHub Mobile for iOS or Android .

I have no idea of what you are trying to do. Setting up a PostgreSQL 13 database on QNAP for Resolve ? Yes I'm trying to do that. Would you suggest I just try a VM on the QNAP? I cant have another computer constantly connected to the NAS as it moves around alot

I am sorry Mr. Garbutt - this is not a simple process. It is for the experienced user with QNAP. The author has done an amazing job showing the exact menus of what to click on, and install. No one can teach you command line ssh stuff on a user forum. If all of this is just too complicated, just get a cheap Mac Mini, and run Resolve 18 Project Server, and you are done. Stick this on your network (you have to have a common network to have collaboration in Resolve), and you can connect right from Resolve . The cost of a low end Mac Mini is the same price that any IT professional would charge you to set this up for you. And if all of that is unacceptable, simply use the Blackmagic Cloud, where Blackmagic will charge your $5 a month to access your common PostgreSQL database - and that applies to ALL of your users.
Bob Zelin

Thanks for the help Bob! If its for an advanced user then I can let it be and go with finding a mac mini. I'm in South Africa and black magic cloud just doesnt cut it with the data travel. Appreciate the time and help!