What is the best way to set up a database for Resolve Studio?

[Dean Baker]

Hi John,

Set up one of your machines in your local network with a fixed IP address to host the database. Install Davinci Resolve Project Server software on this machine PLUS the PostgresSQL database via the DaVinci Resolve software installer.

Launch Resolve Project Server and create a database, then on any other machine connected to the same network as your host computer, you can connect to this database using the PostgreSQL option and the fixed IP address of your host machine. That’s it. Then you can create projects on this database, turn on collaboration in the project and others can open it at the same time.

Do you have mixed machines or all macOS or Windows?

[Paul Carlin]

What Dean said.

It might be intimidating at first, but setting up a Resolve PostgreSQL server is definitely the way to go. You may not need Collaboration as you are only one person, but all the other benefits are worth it. And have a backup plan to backup the database (i.e. Backblaze).

[John Randall]

Hi Dean, Thank you for you help. Yes, all my computers are Windows 10 some home and Pro.

Can I setup the data base on one of my NAS drive and have just have one computer on, which happens to be the one with Windows home and actually works real well with Resolve even though its only low specs but it is always on! By the way I also bought one of their beaut keyboards with all the goodies and love it, expensive but after all the improvements from my Avid setup it is well worth it! I only wish the letters on the keyboard were a bit bigger as I am only a finger type typist. Once again thank you…john R

[John Randall]

Thank you Paul, intimidating is a good word for me, I grew from installing and setting up U-Matic to 1″ machines for Sony and one day I saw a little Chinese woman in the Chinese embassy in Australia, off all places, when installing their Satellite setup doing some NLE editing on a Mac and that changed my entire world. I went from Hardware to Avid software overnight and I have been doing it for nearly 30 years. Thank you …. john R

[Dean Baker]

It is possible to install a postgreSQL database on a NAS and connect it to Resolve – a quick google search will yield some results for you. The only drawback with this is you have to manage the postgreSQL database yourself as I don’t believe you can run the DaVinci Resolve Project Server software on a NAS. We initially tried managing our own postgreSQL database but made the smart move to use the default Resolve database and software on a local machine.