[Ryan Walsh]

Any updates on this? Was anyone able to advise a way of reconnecting DaVinci to a previous installation’s database files effectively?

This issue is becoming quite a difficulty as the effort of re-grading my entire RED project at this stage is very daunting. Meanwhile our client is getting more & more impatient!

Seems there should be some kind of work-around, at least, this system is far from convenient with such issues. Any reason DaVinci couldn’t use a simpler way of saving, and in turn, restoring project files that allows for easier transferal and sharing of user data? The process seems a little too troublesome and time-consuming for any colorist’s liking, no?

—
RYAN J. WALSH
edit | design | image

Flow Creative Inc.
Sim Video China
Far Films Asia

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

[Ryan Walsh]

Just an update – I tried trashing the PostgresSQL folder and re-installing Resolve in several configs. I was able to initialize the start scripts via not replacing the postmaster.pid file (leaving the old the one intact) and also only copying over those files/folders which had been modified since original installation.

The script seems to initialize re-starting itself however after replacing the other data files, DaVinci still does not read the database and reports ‘No Database found’ when opening. I am not sure any extra specific settings to reconnect the database from within DaVinci if I should need to do that.

How do I copy or replace the database’ data without messing with DaVinci’s file structure hierarchy and accessibility, is there a workable way??

Thoughts and advice much appreciated!

—
RYAN J. WALSH
edit | design | image

Flow Creative Inc.
Sim Video China
Far Films Asia

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

[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

[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