Blackmagic Forum

My studio is considering the move from Adobe to Resolve in the new year. We will definitely be utilizing the network operated Davinci Resolve Project Server. I am looking for a automated way to backup all the databases within it and on a schedule but can't seem to find a way to do so.

I have debated running the third parry docker version (Studio Server) just to get these features but am uncomfortable committing the company to a third party bit of code. If it can be done from a Windows server I would prefer to go that route. Have tried various scripts and even PGadmin 4 with little to no luck.

Having been utilizing Resolve for a long time I know the project database can get sluggish at scale so we are thinking of immplenting a database/project library per client. But backing up each one manually would be a chore with three to four clicks per library times 183 clients.

Any help would be greatly appreciated. I had hoped this would just be a feature within the official app but it is not.

Anyone?

Take a look at the video here...

You for sure don’t want to run that many databases.

I would split based on year, half year or quarter depending on how busy you guys are.

By client only makes sense if you have a small handful on clients on one server.

Less databases makes all the power bins and grades easier.


Sent from my iPhone using Tapatalk

CUBuffskier wrote:You for sure don’t want to run that many databases. I would split based on year, half year or quarter depending on how busy you guys are. By client only makes sense if you have a small handful on clients on one server. Less databases makes all the power bins and grades easier.

Actually... you can copy all the PowerGrade bins using the Gallery, dragging them in from other projects:

https://www.steakunderwater.com/VFXPedi ... rt2906.htm

I think this is something I learned 5-6 years ago from @Robbie Carman from MixingLight, so a shout-out to him for that one.

The Power Bins and setups and so on I believe are retained in each DRP, so you could create empty DRP template files for that. It takes a little bit of time and thought to set up.

I gotta say, I would love a way to right-click a Library and say "inherit all the PowerGrade bins from this other Library," which for now you have to do by hand or in the Gallery.

Ah didn't know about copying powergrade bins across databases - I need to try that today, that will be huge!

powerbins can be right-click exported now, just like a regular project bin and then imported into another database

But still, for most use cases, it's best not to use too many project libraries. Your sanity in finding projects will thank you as long as you name projects appropriately.

Sadly he says the script is now outdated for windows.

Thx Rohit. I will check that out.

Interesting. I'm concerned about splitting up Databases by time of year....might get hairy tracking down client numbers.

There are countless PostgreSQL database backup utilities on the web. Most of them are Windows or Linux only. So you will need to run your project server on Windows unless you want to run the backup utility on a separate machine from the project server.

Here is a quick one:
https://sqlbackupandftp.com/

You can run this in the background. It will run an entire database backup while the PostgreSQL service is running and it can also do incremental backup.

We have this running a complete backup 3 times a day.
There are MacOS tools also, but may require command lines and/or scripts.

It can also restore the database. That allowed us to quickly revert to an older database in minutes (and parallel to the actual project server).

HTH

mpetech wrote:There are countless PostgreSQL database backup utilities on the web. Most of them are Windows or Linux only. So you will need to run your project server on Windows unless you want to run the backup utility on a separate machine from the project server.

Here is a quick one:
https://sqlbackupandftp.com/

You can run this in the background. It will run an entire database backup while the PostgreSQL service is running and it can also do incremental backup.

We have this running a complete backup 3 times a day.
There are MacOS tools also, but may require command lines and/or scripts.

It can also restore the database. That allowed us to quickly revert to an older database in minutes (and parallel to the actual project server).

HTH

Hey mpetech,

I've downloaded SQLbackupandFTP on our windows server that hosts our project server. I've created 1 Job that essentially backsup all databases, so I've select the 5 databases we have (1 for each editor) . This backup then creates a zipped SQL file on our NAS. However, when trying to restore it manually, I unzip it , change the SQL to .backup it restores an empty database. No projects shown in the database but the name is populated and generated.

I did try the restore job within SQLbackupandFTP and because I select all databases it would then restore and overwrite all databases.

I was wondering what the ideal way is for restoring specific databases. I suppose i could create 1 separate Job for each editors database.

But the fact that the project server app comes with a backup and restore button i was hoping there can be some manual restoring with the automated backups.

Any tips appreciated

You do not need to unzip. The restore function will take the zip'd file.

https://sqlbackupandftp.com/restore

FYI - we typically restore to a different computer. Restoring does not need to be on the same computer as the original database.

The great @Igor Ridanovic has a script that will automatically backup Resolve PosgreSQL databases:

https://www.hdhead.com/?p=857

I don't know for a fact that it's been updated for Windows 11 and Resolve 19, but you could contact Igor at the address on the website and see what he says.

Very helpful thread there.
I hope the DR team adds some features for this built into the DR Project Server. Seems like a pretty essential feature.