Blackmagic Forum

Hello. For a single user workstation running Resolve 9, what are the pros and cons of Postgres vs a project-based "disk database"?
Speed? Data integrity and backups? Features?
Thank you.

We added the disk database specifically for facilities that don't need, or want, the complexity of PostGres. PostGres needs a server app to run and is ideal for facilities with multiple systems that need to share projects all the time.

Disk database saves the project metadata in a simple folder structure that easy to backup with normal IT procedures, even TimeMachine or a disk copy.

The disk database files are located in logical paths, details in the manual and you can still export whole projects to import to a other system if you wish to share.

I recommend using disk database unless u have a specific need for live sharing of projects
Peter

Does using disk based affect browsing stills libraries of previous projects? I use that a lot.
Can I convert an existing v9 database install to disk based?
Should I just RTFM?

If you are now using a Disk Database you can still import and open your old v8 projects and then save them, one at a time, to the new v9 disk database.
The database does not store the stills or clips.. just pointers to where they are.
Peter

Sorry I was mixing terms. And I have no v8 projects I need to access.
I am in ver 9 Postgres. All my current projects are in that database. How do I switch over to disk database?
Do I need to uninstall resolve and Postgres?
And then reinstall v9 and select disk database?
I had a v8 lite Postgres on my system when I installed v9 full and I think it automatically updated to the old Postgres.

My mistake, sorry, I didn't read your post correctly. No need to uninstall or reinstall. And yes, if you had a PostGres DB before v9 would not automatically change you to the disk DB.

In the database manager you can make a new Disk Database. Then make that the active DB. In the Project Manager you can select the global list of databases and select your v9 projects to import to your new Disk DB.
Your PostGres DB will remain on the computer unless you delete it and Resolve will keep using the Disk DB until you select the other.

Peter

Ok thanks Peter
That sounds safe. Time to say goodbye to the old database style. (Once I finish the last couple episodes of the season)

Hello. Wow it's been 5 years. So I'm wondering that is Postgres sql database working in another local network computer?

I mean, my scenario is one Postgres sql database and and three separated but locally connected computer (all are mac and have studio dongle)

Is it possible?

Yes, that's one of the major benefits of using a SQL database instead of the file-based database.

roger.magnusson wrote:Yes, that's one of the major benefits of using a SQL database instead of the file-based database.

Thanks

Peter Chamberlain wrote:I recommend using disk database unless u have a specific need for live sharing of projects

Is this still the case? I could have sworn I read a while back either Rohit or Dwaine say that Resolve is more stable when using a Postgres database (or it might have been that the database itself is more stable?), but maybe I misunderstood or something.

I've never had a problem with my disk databases.