Da Vinci Questions

[Thomas Wong]

hey, been rocking the system for a few days now, and it’s running great. Wondering where it actually saves my projects/saved sessions? I wanna back those up in case my soft raid kicks the bucket. But I’m not sure which files are actually my saved session. Coming from Color, I don’t see a traditional “project” file to backup…

[Christopher Adams]

I think you can do this a few ways.. 1 is export..
2. is backing up the database.

On the Terminal:

Backup:

1. cd /Library/PostgreSQL/8.4/bin/

2. ./pg_dump -U postgres -Ft -b resolve > /tmp/resolvedb.tar

In the command #2 above, replace “resolve” with the database name, and /tmp/resovledb.tar with the file you want to save it to

3. Compress the backup file

gzip /tmp/resolvedb.tar

To Restore to a new DB:

1. gunzip /tmp/resolvedb.tar.gz

2. ./createdb -U postgres resolve1

3. ./pg_restore -U postgres -d resolve1 /tmp/resolvedb.tar

Can anyone elaborate here? If there is any other folders etc that need backing up
Maybe shoot out an edl and grab the original footage. Also i know many who right click and take still from middle of each shot one command does it all not each one manually thank god.. so they back up the grading trees.

[Vladimir Kucherov]

There is also an app that Resolve installs which has a graphical UI for backing up the database:

it’s called pgAdmin3.app, located inside Library/PostgreSQL/8.4/ folder

[Thomas Wong]

i found the app. but how do I use it? I tried playing around with it to no avail… how do I connect to the server I need to and run the backup? how do i reload the database if I end up having to reinstalling and reloading everything? or bring it to another da vinci elsewhere?

[Kevin Cannon]

This is my understanding (also see this thread):

It looks like you open pgadmin, then “add a connection to a server,” you’ll be prompted for a name (perhaps “resolve”) a host, port, username, password (case sensitive)…

Most of which can be found in the login screen>database manager>connect screen.

Then you’ll be connected to your resolve server and can select it and access the “backup” tool, which the documentation says is simply a GUI for the pgdump tool.

It generated a 1 GB file for me, I haven’t restored from that file to confirm that it worked.

KC

prehistoricdigital.com
hardworkingpixels.com

[Rohit Gupta]

Here are some screenshots of the tool:

1538_resolvedbbackup.pdf.zip

[Paul Nordin]

Hi Rohit,

Thanks so much for posting this. I have been trying to figure out what the process is for backing up the projects, and the manual really provides no love there. I will say that its a little odd to me that I have had to dig through message threads on the cow to find a link to your tech bulletin though. The only thing I’d been able to figure out before finding it is to do project exports at the end of the day.

This makes me wonder what other gems of wisdom you have in other tech bulletins or “best practice” PDFs that I have not thought to look for or known to even. I wonder if it might be possible for a library of such things could be posted in one place either here on the cow or somewhere on the BMD site? That would be a fantastic resource for the many like me who are working through the Resolve learning curve without the benefit of a mentor or formal training in the tool.

For now, thanks again for posting the pdf. I can rest a little easier knowing that the entire DB is backed up.

Cheers,
Paul

_______________________
El Mundo Bueno Studios
Film * Audio
http://www.EMBstudios.com
Emeryville, CA
_______________________

[Ryan Walsh]

Thanks for your very useful post, Rohit.

I have a bit of a problem in that our previous OS X installation died just recently, setup only, but files still intact. I’m running on a new OS X and DaVinci install in the same machine, different HDD, with access to the original files and data from my previous installation available on its original drive. On the new DaVinci install, obviously, all my user data is lost, including my lovely grade of a RED project ready-to-render & needing output.

What would be the method to retrieve my Resolve database if the data is stored on a drive other than the one currently running the OS? I have tried the 1538_resolvedbbackup walk-through which is great but it would only seem to restore that database which is already in use in your current installation setup, not a previous database already unavailable…

Thanks in advance and any guidance highly appreciated!

—
Ryan Walsh
Sim Video China
Beijing

[Rohit Gupta]

If you have access to the old files, you can try to move away the current database files, and copy over the old ones.

Remember to stop your database server before you replace the files.

The start and stop scripts are here:

/Library/PostgreSQL/8.4/scripts

The data files are here:

/Library/PostgreSQL/8.4/data

[Ryan Walsh]

Hi Rohit,

Thanks for this. I tried your steps and after stopping the server, which the script works fine for, I am able to copy over the data files and replaced the entire ‘data’ folder with that of my previous one, however am unable to restart the server again after stopping it. I am working with the ‘stop.applescript’ & ‘start.applescript’ scripts, and also tried the ‘restart.applescript’ & ‘reload.applescript’ as well. When executing any of the scripts now, I receive error message:

pg_ctl: could not open PID file “/Library/PostgreSQL/8.4/data/postmaster.pid”: Permission denied

It seems that it will no longer read the postmaster.pid file, even though it is there, and the access permissions for the whole ‘data’ folder had needed to be allowed before I could see them.

Of course, when I open Resolve, even after re-installing the software, it tells me “No Database connected!” and I am unable to re-connect nor create a new database. When attempting to create a new database, it tells me ‘Failed to open database connection: could not connect to server: Connection refused” and then tells me its confused about host & port numbers.

Seems the postmaster.pid file has become corrupt or inaccessible somehow and is preventing it from connecting. Re-installing doesn’t help clearly because it doesn’t rewrite the PostgresSQL files, they remain intact. What would be the logical steps from here – delete and re-write the PostgreSQL data via manual trashing & software re-install, then attempt to re-copy old ‘data’ folder files all except the postmaster.pid file? Or is there a more logical, straight-forward fix?

Thanks for your patience.

Ryan

—
RYAN J. WALSH
edit | design | image

Flow Creative Inc.
Sim Video China
Far Films Asia

Beijing, P.R. China
https://ryanwalsh.info