Database server and 2 Macs?

[Christopher Tay]

You can share the Resolve database over a Resolve Database Server between two Resolve Macs, or combo of Resolve Linux and Mac.

The Resolve Database Server is Linux based and the installer is only available as part of the Resolve Linux installer DVD.

-chrispy

[Peter Chamberlain]

Hi, Chris is correct that there is a Database server installer on the Linux DVD but it is possible to set one up on a Mac. I have been thinking of documenting this for a Mac db Server so if you PM Adam me we can run a test and go from there.
Peter

[Mikhail Puzyrev]

Would You please also pm the “howto db on mac” to me. I would like to try moving the db to separate machine.

[Jay Friesen]

Peter, I’ve been wanting to do this on my system as well for a while (Mac). I’ve been bugging Dan about it but finally gave up 🙂 So anything you can do to make it happen would be awesome.

[Margus Voll]

Whoa. This is one thing that would really expand mac setups if one has 2 machines or more.

Maybe this will become public information after some time ?

—

Margus

https://iconstudios.eu

[Adam Hendershot]

So is it silly to ask how to PM someone from this board? 🙂

[Peter Chamberlain]

peterc at blackmagic-design dot com

[Elan Dassani]

I;ve gotten the Resolve Database Server working on a Macintosh. Its a bit of a pain in the ass to set up, but now that its operational its a thing of beauty. I;ve got 2 Mac Resolves sharing one database.

I’ll post how to do it in a day or two.

_______
Elan Dassani
Master Key Post
mkvfx.com

[Severin Schultze]

Hi Elan,

how did you manage to get this working? I have two Resolve workstations and am trying to setup a database on a server that the two workstations are able to share the server based database.

Thanks a lot!

Cheers,
Severin

DIT @ WeFadeToGrey

[Jed Smith]

DaVinci Resolve installs the PostgreSQL database server. By default the permissions of the server settings disable access by any non local loopback ip addresses. That is, anything that’s not 127.0.0.1.

To enable a range of IP addresses to connect to the database server, you have to explicitly enable them in the configuration file, which for Macs is located here:
/Library/PostgreSQL/8.4/data/pg_hba.conf

Note that this folder is not readable by normal users. You will have to use Terminal and sudo into the folder, and edit the pg_hba.conf file, and then restart the server using the utilities in this folder:
/Applications/PostgreSQL 8.4/

For example, this line will enable all IP addresses in the range 192.168.1.0-255:
host all all 192.168.1.0/24 md5

Not sure why this isn’t mentioned anywhere in the Documentation! Hope this helps.