Failed to open database connection

Get answers to your questions about color grading, editing and finishing with DaVinci Resolve.
  • 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: 2054
  • 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**
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: 11246
  • 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
Offline
User avatar

Berube

  • Posts: 3
  • Joined: Tue Sep 12, 2023 2:44 pm
  • Location: Los Angeles, CA
  • Real Name: Jonathan Berube

Re: Failed to open database connection

PostTue Sep 12, 2023 2:52 pm

Hello there,

I'm having a similar issues.
I tried the suggested sudo commands and a fresh install and still running into this one.

"There was a problem connecting to the server 127.0.0.1."
"This file server will not allow any additional users to log on."
"Try to connect again later."

Resolve v8.5.1
Mac OS Ventura 13.3.1

Been trying to uninstall, re-install fresh copy, reboot etc.. no luck.

Thanks for your help in advance.

-Berube
Attachments
resolve_01.jpg
resolve_01.jpg (198.06 KiB) Viewed 390 times
Jonathan Berube
Head of Creative Operation
Director | Sr. VFX Art Director
Offline
User avatar

Dwaine Maggart

Blackmagic Design

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

Re: Failed to open database connection

PostWed Sep 13, 2023 6:56 pm

What exactly are you doing? Are you using the Resolve Project Server app, and if so, is it on the same machine?

Or are you using the Resolve app to try to connect or create a Network database on the Mac?

If the issue is related to using a PostgreSQL server on the same Mac, make sure PostgreSQL is running, by opening the Mac Activity Monitor, and in the View menu, select All Processes, then sort on the Process Name column and scroll to the P's area. If PostgreSQL is running, there should be several postgres processes running.

If PostgreSQL is not running, we need to sort that out. If it is running, then we need to know answers to the questions above.
Dwaine Maggart
Blackmagic Design DaVinci Support
Offline
User avatar

Berube

  • Posts: 3
  • Joined: Tue Sep 12, 2023 2:44 pm
  • Location: Los Angeles, CA
  • Real Name: Jonathan Berube

Re: Failed to open database connection

PostWed Sep 13, 2023 8:00 pm

Hello Dwaine,

Thank you for your reply.

I'm just launching Resolve. Not trying to do anything special besides grading on my machine. Resolve is installed on my local drive (Application Folder), and my project is saved on my Desktop. Simple/simple. I un-installed Resolve and re-installed it. Not sure what changed for this to come up.

Best,

-J
Last edited by Berube on Thu Sep 14, 2023 5:05 pm, edited 1 time in total.
Jonathan Berube
Head of Creative Operation
Director | Sr. VFX Art Director
Offline

Username

  • Posts: 389
  • Joined: Tue Jun 25, 2019 2:33 am
  • Real Name: Petter Flink

Re: Failed to open database connection

PostThu Sep 14, 2023 4:41 am

Hi there.

It looks as if you are trying to mount your own computers drive as a file share volume
That’s not at all how the Postgres server works.
Postgres is a database and don’t store files and content. It only stores text and data about your projects and edits.

You might want to read a bit in the instructions which will guide you right.

Berube wrote:Hello there,

I'm having a similar issues.
I tried the suggested sudo commands and a fresh install and still running into this one.

"There was a problem connecting to the server 127.0.0.1."
"This file server will not allow any additional users to log on."
"Try to connect again later."

Resolve v8.5.1
Mac OS Ventura 13.3.1

Been trying to uninstall, re-install fresh copy, reboot etc.. no luck.

Thanks for your help in advance.

-Berube
Grew up with a Nikon FM
Resolve & Fusion Studio 18.6
MBP M1 16GB/1TB
MM M1 16GB/512GB TB4 1TB & 2TB
MM i7 16GB/1TB & PowerColor Vega 56 8GB
Offline
User avatar

Berube

  • Posts: 3
  • Joined: Tue Sep 12, 2023 2:44 pm
  • Location: Los Angeles, CA
  • Real Name: Jonathan Berube

Re: Failed to open database connection

PostThu Sep 14, 2023 7:03 pm

Hello everyone,

Ok I found the issue and was able to sort it out.

Again, I was not trying to do anything specific. I installed a fresh version of DaVinci Resolve Studio 18.5 from the Apple App Store, and would get the error at the first launch without configuring anything.

It appears the build of Resolve Studio available on the Apple App store is faulty, incomplete and buggy. After noticing the reviews, I went ahead and bought Resolve from the Black Magic website directly as opposed to the App Store and all my issues went away at the first launch.

Hope this helps other users.

Best,

-Berube
Attachments
Resolve_01.jpg
Resolve_01.jpg (619.56 KiB) Viewed 213 times
Jonathan Berube
Head of Creative Operation
Director | Sr. VFX Art Director

Return to DaVinci Resolve

Who is online

Users browsing this forum: 4EvrYng, carsonjones, Google [Bot], govind, Joe001, peeceful, Peter Cave, Uli Plank, VMFXBV and 208 guests