Backup PostgreSQL database on Mac Os

Get answers to your questions about color grading, editing and finishing with DaVinci Resolve.
  • Author
  • Message
Offline

JJ Falsetta

  • Posts: 22
  • Joined: Tue Aug 28, 2018 3:12 pm
  • Location: Germany
  • Real Name: Jaco Falsetta

Backup PostgreSQL database on Mac Os

PostFri Mar 19, 2021 11:52 am

Hello. Our working group now hosts the DVR postgreSQL database on our local server, it's the CentOS7 version provided by Blackmagic. This means that we are not running the latest Resolve Project server app (on our Mac workstations) as we can directly connect the database from the Project manager in DVR and we don't export keys. For safety we would still like to do routine backups of the database from inside DVR but it fails, I guess because we don't run PostgreSQL on our workstations? Is there a workaround for that?
The only option I have now is copying a project each time on the local database and backup that, then copy it back to the shared database.

Would the Project Server app solve this thing?

Resolve version is 17.0 Build 39
Workstations OS: Mojave 14.6

Thank you
Resolve Studio 16.2 - MacOS Mojave 10.14.6 - iMac 27” late 2012 - 3,4 GHz Intel Core i7 - 32GB DDR3 1600 - AMD Radeon RX580 eGPU Core X
Offline

Misha Aranyshev

  • Posts: 117
  • Joined: Thu Jan 21, 2016 2:13 am

Re: Backup PostgreSQL database on Mac Os

PostFri Mar 19, 2021 4:53 pm

Over at LiftGammaGain forum, there is a thread with two solutions for this via shell scripts. Highly recommended.
Offline

JJ Falsetta

  • Posts: 22
  • Joined: Tue Aug 28, 2018 3:12 pm
  • Location: Germany
  • Real Name: Jaco Falsetta

Re: Backup PostgreSQL database on Mac Os

PostSat Mar 20, 2021 11:09 am

Misha Aranyshev wrote:Over at LiftGammaGain forum, there is a thread with two solutions for this via shell scripts. Highly recommended.


found it. Thank you!
Resolve Studio 16.2 - MacOS Mojave 10.14.6 - iMac 27” late 2012 - 3,4 GHz Intel Core i7 - 32GB DDR3 1600 - AMD Radeon RX580 eGPU Core X

Return to DaVinci Resolve

Who is online

Users browsing this forum: choukjj, Giles Sherwood, oliverfuchs, panos_mts and 394 guests