Creative COW SIGN IN :: SPONSORS :: ADVERTISING :: ABOUT US :: CONTACT US :: FAQ
Creative COW's LinkedIn GroupCreative COW's Facebook PageCreative COW on TwitterCreative COW's Google+ PageCreative COW on YouTube
FORUMS:listlist (w/ descriptions)archivetagssearchhall of famerecent posts

Failed to open database

COW Forums : DaVinci Resolve

<< PREVIOUS   •   VIEW ALL   •   PRINT   •   NEXT >>
Share on Facebook
Perry TrestFailed to open database
by on Feb 28, 2013 at 1:02:42 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


Return to posts index
Reply   Like  

Juan SalvoRe: Failed to open database
by on Feb 28, 2013 at 2:42:58 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

http://JuanSalvo.com


Return to posts index
Reply   Like  

Perry TrestRe: Failed to open database
by on Feb 28, 2013 at 3:21:05 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


Return to posts index
Reply   Like  


Perry TrestRe: Failed to open database
by on Feb 28, 2013 at 6:56:16 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


Return to posts index
Reply   Like  

Eric JohnsonRe: Failed to open database
by on Feb 28, 2013 at 7:19:02 pm

Which SSD is it? Is it in the 2nd optical bay or HDD 1?


Return to posts index
Reply   Like  

Perry TrestRe: Failed to open database
by on Feb 28, 2013 at 7:26:05 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


Return to posts index
Reply   Like  


Perry TrestRe: Failed to open database
by on Feb 28, 2013 at 7:30:24 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


Return to posts index
Reply   Like  

Dan MoranRe: Failed to open database
by on Feb 28, 2013 at 11:56:45 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

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

--

Dan Moran
Colourist
Smoke & Mirrors: London
http://www.danmorancolor.com/blog


Return to posts index
Reply   Like  
+1

Sascha HaberRe: Failed to open database
by on Mar 1, 2013 at 9:37:24 pm

Thanks for bringing that up...

A slice of color...

Resolve 9.1.1 OSX 10.8.2

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


Return to posts index
Reply   Like  

<< PREVIOUS   •   VIEW ALL   •   PRINT   •   NEXT >>
Share on Facebook


FORUMSTUTORIALSFEATURESVIDEOSPODCASTSEVENTSSERVICESNEWSLETTERNEWSBLOGS

Creative COW LinkedIn Group Creative COW Facebook Page Creative COW on Twitter
© 2014 CreativeCOW.net All rights are reserved. - Privacy Policy

[Top]