Page 1 of 1

Backup PostgreSQL database on Mac Os

PostPosted: Fri Mar 19, 2021 11:52 am
by JJ Falsetta
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

Re: Backup PostgreSQL database on Mac Os

PostPosted: Fri Mar 19, 2021 4:53 pm
by Misha Aranyshev
Over at LiftGammaGain forum, there is a thread with two solutions for this via shell scripts. Highly recommended.

Re: Backup PostgreSQL database on Mac Os

PostPosted: Sat Mar 20, 2021 11:09 am
by JJ Falsetta
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!