Failed to open database connection

Getting started with a Blackmagic product? Ask questions here about setup and installation.
  • Author
  • Message
Offline

ssidwashere

  • 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 "127.0.0.1"
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?
Offline

CaptainHook

Blackmagic Design

  • Posts: 959
  • Joined: Wed Aug 22, 2012 4:50 am
  • Location: Melbourne, Australia

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.
https://vimeo.com/acoupleofnightowls/
http://www.captainhook.co.nz/blackmagic-cinema-camera-lut/
Offline

abrownrigg

  • 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
Offline
User avatar

Dwaine Maggart

Blackmagic Design

  • Posts: 1513
  • 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 Getting Started

Who is online

Users browsing this forum: Andrei Nikolaenko and 5 guests