Failed to open database connection

Get answers to your questions about color grading, editing and finishing with DaVinci Resolve.
  • Author
  • Message


  • Posts: 1
  • Joined: Tue Aug 28, 2012 4:47 pm

Failed to open database connection

PostTue Aug 28, 2012 4:52 pm

Hi there, I've used Davinci Resolve on previous machines and only just recently installed the Lite version on my MacBook Pro running Mountain Lion.

After installing the latest Lite version, when I try to create a new database I'm prompted with a message that says:

Failed to open database connection: could not connect to server: Connection refused
Is the server running on host ""
and accepting
TCP/IP connections on port 5432?
QPSQL: Unable to connect

Is there something that I've missed or requirement that I don't have that is bringing this problem on?


Blackmagic Design

  • Posts: 1802
  • Joined: Wed Aug 22, 2012 4:50 am
  • Location: Melbourne, Australia
  • Real Name: Hook

Re: Failed to open database connection

PostWed Aug 29, 2012 8:57 pm

On some machines we've seen the database installation fail, and this causes the database to not start up properly.

A fix for this requires a few command for you to type on the terminal. This will uninstall the database, so the next install of Resolve will install it properly.

Before you run these it's important to make sure you don't have any data or resolve projects saved in your postgres database.

1) Stop the server
sudo /sbin/SystemStarter stop postgresql-8.4
2) Remove menu shortcuts:
sudo rm -rf /Applications/PostgreSQL 8.4
3) Remove the ini file
sudo rm -rf /etc/postgres-reg.ini
4) Removing Startup Items
sudo rm -rf /Library/StartupItems/postgresql-8.4
5) Remove the data and installed files
sudo rm -rf /Library/PostgreSQL/8.4
6) Delete the user postgres
sudo dscl . delete /users/postgres

Now, re-install Resolve, reboot, and then start Resolve.
**Any post by me prior to Aug 2014 was before i started working for Blackmagic**


  • Posts: 8
  • Joined: Sat Dec 01, 2012 2:40 pm

Re: Failed to open database connection

PostSat Dec 01, 2012 2:46 pm

I am having much the same problem. Although I cant even get Resolve lite to install the PostgreSQL folder in the applications. I'm running now with all permissions open that I can see. Say's it installs fine.. this is on mountain lion.. But get that same database error. The terminal fixes dont seem to be working for me, as they give me a 'file doesnt exist' when I try to affect applications/PostgreSQL 8.4

I've gone into the library, and renamed the PostgreSQL folder THERE as _bad, and reinstalled.. same problem. Not running osx server either.. Just on a macbook pro running 10.8.2
User avatar

Dwaine Maggart

Blackmagic Design

  • Posts: 7683
  • Joined: Wed Aug 22, 2012 2:53 pm

Re: Failed to open database connection

PostMon Dec 03, 2012 10:45 pm

Assuming you are using Resolve V9, open the Database Manager and make a new DISK database. Then it won't matter that PostgreSQL is not working. Details on this are on page 611 of the V9 Resolve manual.
Dwaine Maggart
Blackmagic Design DaVinci Support

Return to DaVinci Resolve

Who is online

Users browsing this forum: Andrew Kolakowski, Bing [Bot], Cosmin Hodiș-Mîndraș, Helmutwr, panos_mts, pavelsiska, Shrinivas Ramani, Simon_Kre, Tomek Cobas and 91 guests