Failed to open database

DaVinci Resolve

Failed to open database

Posted by Perry Trest on February 28, 2013 at 1:02 am

Did a search and followed a few recommended procedures with no success.

I just restored a Time Machine backup of my Resolve 9.1.1 system to a new SSD boot drive.
When I launch Resolve my database and users don’t appear and when I try to connect I get the following error:

ERROR
Failed to open database connection: could not connect to server: connection refused
Is the server running on host “127.0.0.1” and accepting

I’ve tried uninstalling and re-installing Resolve, and I’ve tried renaming the PostgreSQL folder and re-installing. When I put the original boot drive back in the system, everything works as it should. Can anyone suggest how I can get my original database and user settings restored? Thanks in advance!

Perry Trest
POSTDIGITAL, Inc.

MacPro 12core 2.66Ghz
24GB RAM
Slot 1 = ATI 5770
Slot 2 = Quadro 4000
Slot 3 = DeckLink SDI
Slot 4 = Nitris DX HIC
Internal 6TB software RAID-0
Tangent Wave
HP DreamColor

Sascha Haber replied 13 years, 2 months ago 5 Members · 8 Replies
8 Replies

Juan Salvo
February 28, 2013 at 2:42 am

You need to reinstall the PostGRES server. You can do it by downloading and rerunning the installer.

Colorist | Online Editor | Post Super | VFX Artist | BD Author

https://JuanSalvo.com
Perry Trest
February 28, 2013 at 3:21 pm

Juan, thanks for the quick response.
Is there a separate installer for the PostGRES server?
I tried a uninstall and re-install of the Resolve software with no success.

Perry Trest
POSTDIGITAL, Inc.

MacPro 12core 2.66Ghz
24GB RAM
Slot 1 = ATI 5770
Slot 2 = Quadro 4000
Slot 3 = DeckLink SDI
Slot 4 = Nitris DX HIC
Internal 6TB software RAID-0
Tangent Wave
HP DreamColor
Perry Trest
February 28, 2013 at 6:56 pm

Problem solved.

I ended up restoring a slightly older backup of the Resolve system and boom, everything is back to normal.
I suspect that the most current backup was incomplete in some way.

The new SSD drive is quite a bit zippier on boot up and application launch.

Perry Trest
POSTDIGITAL, Inc.

MacPro 12core 2.66Ghz
24GB RAM
Slot 1 = ATI 5770
Slot 2 = Quadro 4000
Slot 3 = DeckLink SDI
Slot 4 = Nitris DX HIC
Internal 6TB software RAID-0
Tangent Wave
HP DreamColor
Eric Johnson
February 28, 2013 at 7:19 pm

Which SSD is it? Is it in the 2nd optical bay or HDD 1?
Perry Trest
February 28, 2013 at 7:26 pm

OWC
240GB
Mercury Electra™ 3G SSD
2.5″ Serial-ATA 9.5mm Solid State Drive

It’s mounted in the second optical drive bay.

Perry Trest
POSTDIGITAL, Inc.

MacPro 12core 2.66Ghz
24GB RAM
Slot 1 = ATI 5770
Slot 2 = Quadro 4000
Slot 3 = DeckLink SDI
Slot 4 = Nitris DX HIC
Internal 6TB software RAID-0
Tangent Wave
HP DreamColor
Perry Trest
February 28, 2013 at 7:30 pm

Correction:

240GB Mercury Electra 6G SSD 2.5″ Serial-ATA 9.5mm

Perry Trest
POSTDIGITAL, Inc.

MacPro 12core 2.66Ghz
24GB RAM
Slot 1 = ATI 5770
Slot 2 = Quadro 4000
Slot 3 = DeckLink SDI
Slot 4 = Nitris DX HIC
Internal 6TB software RAID-0
Tangent Wave
HP DreamColor
Dan Moran
February 28, 2013 at 11:56 pm

Just a word of warning to anyone that is using Time Machine as a backup. If Time Machine is backing up while your running resolve there is a strong chance of it not working when you try and restore it as resolve is constantly reading and writing to the postgres database.

To be safe I’d do some dedicated backups when moving systems like this. I wrote a article about all your options if your interested

https://www.mixinglight.com/007-R9-ResolveBackups-DM.html

—

Dan Moran
Colourist
Smoke & Mirrors: London
http://www.danmorancolor.com/blog
Sascha Haber
March 1, 2013 at 9:37 pm

Thanks for bringing that up…

A slice of color…

Resolve 9.1.1 OSX 10.8.2

Colorist / Aerial footage producer
https://vimeo.com/saschahaber

Reply to this Discussion! Login or Sign Up

Creative Communities of the World Forums