Virtualizing Your Networked Resolve Database Server on Linux

April 12, 2022

Learn how to install and configure Postrgres database servers in a Linux virtual machine across an internal network for DaVinci Resolve.


What is Virtualization?

Unless you’ve lived under a rock for the past decade – it’s pretty likely you’ve at least heard of the term virtualization. Even if you don’t use it directly – you’ve certainly used it indirectly while using almost any online service.

Virtualization is the the process of running a virtual computer inside a physical one. Multiple virtual machines can run on a single host machine. This makes it possible to maximize the hardware of a single computer, running multiple operating systems and services at the same time. It is also how almost all datacenter and cloud applications are hosted today.

Virtual machines let you run more than one operating system on a single physical computer. They are great for maximizing the hardware you have.

Virtualized Database Servers For Resolve

Resolve’s project database runs on a industry standard Postgres database platform. This means it can be hosted on just about any computer, and it barely uses any resources. This also makes it a perfect use-case for virtualization. Many colorists already have NAS machines that support running virtual machines. If you don’t have a NAS that supports virtualization, you may have a spare computer that is doing something else that does.

Hosting your Resolve Database in a virtual machine is a great way to maximize hardware that you may already have! In my home studio, I run my database in VMWare. At our office at DC Color, we run it on our big TrueNAS server, and at Pat’s facility, he runs it on his TrueNAS Mini XL+.

The Process

First, you will need a hypervisor. This is the software that runs and manages virtual machines. In this Insight – i’ll be using Oracle Virtualbox – an opensource hypervisor that runs on desktop operating systems. Other options include the built-in hypervisors in TrueNAS, Synology, QNAP and other NAS servers. You can also use dedicated, bare-metal hypervisors like VMWare or ProxMox.

Every hypervisor is a little different – but the general options for configuring a virtual machine are the same. In this Insight, I’ll show you how to:

  • Set up and configure virtual machine options
  • Download and install CentOS Linux
  • Install and configure Postgres server on CentOS for use with Resolve
  • Use Resovle to create and connect to databases on the new virtual server

Command Reference

This Insight features a lot of command-line interaction – so a general understanding of Linux is recommended. Don’t worry – since the server is virtual, you won’t break anything. If you get it wrong – you can just delete it and start fresh. This makes virtual machines a great way to dip your feet into Linux without a lot of risk.

To make it easier to follow along – I’ve also included all the commands I used as a reference. Just know that these may be different in other linux distributions or versions.

CommandExplanation

su


switch user. With no argument, this defaults to the superuser

yum install postgresql postgresql-server open-vm-tools emacs


Install postgres client and server, open vm tools, and emacs text editor

service postgresql initdb


Initialize the postgres database

systemctl enable postgresql


Enable the postgres server

systemctl start postgresql


Start the postgres server

su – postgres


Switch to a shell as the postgres user

ALTER USER postgres WITH PASSWORD ‘DaVinci’;


Update the postgres database user password (run in the postgres shell)

systemctl restart postgresql


Restart the postgres server

systemctl stop firewalls


Stop the builtin firewall

systemctl disable firewall


Disable the builtin firewall

Links and resources from this Insight

  • VirtualBox.org – “VirtualBox is a powerful x86 and AMD64/Intel64 virtualization product for enterprise as well as home use. Not only is VirtualBox an extremely feature rich, high performance product for enterprise customers, it is also the only professional solution that is freely available as Open Source Software under the terms of the GNU General Public License (GPL) version 2”
  • CentOS Stream – “Community-driven free software effort focused around the goal of providing a rich base platform for open source communities to build upon.”

Related Insights

As always, leave your comments or ask questions below!

– Joey

Member Content

Sorry... the rest of this content is for members only. You'll need to login or sign up to continue (we hope you do!).

Membership options
Member Login

Comments

Homepage Forums Virtualizing Your Networked Resolve Database Server on Linux

Viewing 0 reply threads

    • Remco Hekker
      Participant

      Hi Joey,
      This is great! I just setup a Postgres database in a docker container but I found it wasn’t as stable as I wanted it to be. I was a little hesitant to put a VM on my proxmox server just for the Resolve database but it looks light enough to keep it running all the time.

      Two questions: Will the vm and database restart automatically when my server reboots? And can you show us how you would setup creating automatic backups of this database?

      Finding my way through this stuff doesn’t come natural to me, so your help, and this insight, is greatly appreciated!!


      • Joey D’Anna
        Participant

        Thanks! yea i think your proxmox server is likely more than enough. Unless you are really hammering the database with a lot of active users simultaneously – the load is extremely low.

         

        It does restart automatically – thats what the systemctl enable postgresql command turns on. The only thing you would need to do is make sure the VM is also set to automatically start in proxmox.

         

        As for automatic backups – Seth Goldin (who is also a ML member so he may chime in here as well!) has a really nice script for that:

        https://github.com/sethgoldin/davinci-resolve-postgresql-workflow-tools


        • Remco Hekker
          Participant

          Thanks Joey, That’s exactly what I needed.

Viewing 0 reply threads
  • You must be logged in to reply to this topic.

Hundreds of Free Tutorials

Get full access to our entire library of 900+ color tutorials for an entire week!


Start Your Free Trial
Loading...