Page 1 of 1

Failed to open database connection

PostPosted: Tue Aug 28, 2012 4:52 pm
by ssidwashere
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?

Re: Failed to open database connection

PostPosted: Wed Aug 29, 2012 8:57 pm
by CaptainHook
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.

Re: Failed to open database connection

PostPosted: Sat Dec 01, 2012 2:46 pm
by abrownrigg
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

Re: Failed to open database connection

PostPosted: Mon Dec 03, 2012 10:45 pm
by Dwaine Maggart
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.