Auto/Cloud backup for database & remote grading

DaVinci Resolve

Auto/Cloud backup for database & remote grading

Posted by Toby Tomkins on November 17, 2011 at 6:43 pm

Hi,

Is there a way to host/have the Resolve database files in a Dropbox folder (on the host/colourist computer)?

This would be a nice way to automatically backup the database and provide free/cheap redundancy via ‘cloud’ storage (as Dropbox folders sync whenever there is a change to files)

Also can projects be extracted from the database (as individual tgz files)?

I’m hoping to use remote grading more and more (I have a suite at home and a suite in Soho), so it would be nice to share the database to avoing going project.tgz crazy with every exchange back and forth. Maybe I’ve missed something and there’s another way!? (-;

EDIT: I’ve just found this, is this the best method?;

‘by Jed Smith on Oct 11, 2011 at 2:01:35 am

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.’

Thanks!

Simon Blackledge replied 14 years, 6 months ago 3 Members · 3 Replies
3 Replies

Margus Voll
November 18, 2011 at 4:16 am

It seems really hi end stuff for common computer user. Probably this is why you not seeing it in manual.

—

Margus

https://iconstudios.eu
Margus Voll
November 19, 2011 at 10:46 am

I just wanted to add my database to my Back Blaze backup but it seems that applications folder is not
allowed. So if one could change the location database is located the we would have ton of automatic
backup plan options. Other option would be to have a script to copy database clone to some other location
what would be possible to back up separately not affecting the actual database ?

—

Margus

https://iconstudios.eu
Simon Blackledge
November 19, 2011 at 1:18 pm

I’d probably use something like Chronosync
I use this for FCP autosaves folder but its set to backup not sync.
FCP autosave > dropbox/fcp_autosave that way autosaves are offsite every 15 mins.

Create a sync on machine 1 from folder A (projects db etc..) to folder B – B being the /Volumes/Dropbox/Resolve/DB

Set it to sync every 15mins or hour etc

Do the same on machine 2

–

Things get complicated when you want some on one but not on the other.

then you just need to start doing separate syncs per project.

s

Reply to this Discussion! Login or Sign Up

Creative Communities of the World Forums