Da Vinci Questions

[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]

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

[Rohit Gupta]

Copying of the “data” directory is generally not a recommended way to moving over postgres databases. The only recommended way is to dump, and restore the database. Or alternatively, if you export individual projects, you can import them into a new database.

Of course in your case, since the older installation of postgres is no longer running, it is not possible to dump out the database, or export individual projects.

I suspect you are running into file permission issues, or something like that, but I can’t be sure.

Here’s a couple of threads I found:

https://fossplanet.com/f15/%5Bgeneral%5D-moving-postgresql-data-another-computer-35801/
https://www.postgresql.org/docs/8.4/interactive/backup-file.html

using google keywords – “postgres moving data directory”