Page 1 of 1
Failed to open database connection
Posted:
Tue Aug 28, 2012 4:52 pmby 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 "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?
Re: Failed to open database connection
Posted:
Wed Aug 29, 2012 8:57 pmby 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
Posted:
Sat Dec 01, 2012 2:46 pmby 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
Posted:
Mon Dec 03, 2012 10:45 pmby 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.
Re: Failed to open database connection
Posted:
Tue Sep 12, 2023 2:52 pmby Berube
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
Re: Failed to open database connection
Posted:
Wed Sep 13, 2023 6:56 pmby Dwaine Maggart
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.
Re: Failed to open database connection
Posted:
Wed Sep 13, 2023 8:00 pmby Berube
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
Re: Failed to open database connection
Posted:
Thu Sep 14, 2023 4:41 amby Username
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
Re: Failed to open database connection
Posted:
Thu Sep 14, 2023 7:03 pmby Berube
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