I tried to create new database on 3 other different windows machines but all station having the same error,

"ERRORFailed to open database connection:Could not connect to server: connection refused: (0x0000274D/10061) is the server running on host "127.0.0.1" and accepting TCP/IP connections on port 5432? QPSQL: Unable to connect"

* Find attached screen shot for the reference.

I tried the same on one of my macbook and able to create new database on a click.

We want to have the setup 3 Davinci resolve full versions (Windows+MacOSX+Linux) and connecting to the same (share) database (Davinci lite as database server running on windows).

Please advice how to resolve the database error as i have gone through the manual and its seems very simple but i am stuck and not able to create database which let me proceed to connect the other stations to the server.

* I tried uninstall the Davinci resolve and reinstall and delete the hidden folder from "program data" but no success.

Your issue of being unable to create a PostgreSQL database on Windows systems could have multiple reasons.

1. You didn't install PostgreSQL. When you run the Resolve installer, it has check boxes for various components. If the PostgreSQL check box was not checked, it would not be installed. Look in C:\Program Files and make sure a PostgreSQL folder exists. In that folder should be a 9.0 and/or a 9.2 folder. If you see these, then PostgreSQL was installed.

2. If PostgreSQL is installed, but your system is connected to a Windows Domain Server, then likely PostgreSQL was not properly installed and is not running. You can see if PostgreSQL is running by looking in the Windows Task Manager window, on the Services tab. If it's running, you should see a "postgresql-x64-9.0" or "postgresql-x64-9.2" service running. If you don't see a postgresql service running, then PostgreSQL will need to be uninstalled and reinstalled manually, and given a password that meets your Windows Domain Server password policy. The default password that we attempt to install PostgreSQL with is DaVinci. DaVinci is not a strong enough password for the Windows Domain Server, so it causes the install to fail. If you need to solve this problem, that will require additional help from us, and you should contact your local BMD support office for more information. When Resolve for Windows first came out, this was an often occurring issue. Until we made DISK databases the default on new installations. I imagine there could be a number of Resolve Windows installations where PostgreSQL is not running, but they don't care, since they are using DISK databases.

3. If PostgreSQL is installed and it's running, since it is a network connected service, firewalls can prevent the Resolve app from communicating with PostgreSQL. This can be determined by temporarily disabling the firewall app, and seeing if you can create a PostgreSQL database then. If so, you'll need to add a rule to your firewall to allow access to PostgreSQL.

Once you can create a PostgreSQL database on the local machine, then you can think about connecting to a remote database server.

Normally, PostgreSQL is configured to only allow a process on the local system (like Resolve) to communicate with it. If you want other systems to be able to connect to PostgreSQL running on a system, one of it's config files needs to modified to do this. This procedure for Mac systems is explained in the Mac Resolve Config guide, in the current guide on page 47, in the "Using a Mac as the DaVinci Resolve database server" section. We don't have similar instructions for a Windows system in the Windows config guide. The concept is the same. The process to accomplish that on a Windows system is different.

The file that needs to be modified is the pg_hba.conf file. It will be located here: C:\Program Files\PostgreSQL\9.0\data

You should make a backup copy of the file before you attempt to modify it. Open the pg_hba.conf file in Notepad, and scroll down to the bottom of the file. It should look like this:

# TYPE DATABASE USER CIDR-ADDRESS METHOD

# IPv4 local connections:host all all 127.0.0.1/32 md5# IPv6 local connections:host all all ::1/128 md5

In the IPv4 section, add this line:

host all all 192.168.1.0/24 md5

You would replace the 192.168.1.0/24 address in my example with your local network subnet address. So if your network is 192.168.33.x, you would use 192.168.33.0/24.

Save the change and reboot Windows. Now other systems on that same subnet should be able to connect to PostgreSQL.

If you create the desired database on the database server PC, using the Resolve Database Manager window on that system, then on the other Resolve systems that want to connect to it, you would use the Database Manager Connect menu, and in place of the 127.0.0.1 address, you would use the address of the database server PC.

Or, you can create a new database on the database server from one of other Resolve systems. When you click the + icon to create a new database, replace the local 127.0.0.1 address with the address of the database server.

Your detail reply is highly appreciated, we are able to install the database and connect all the systems as per the requirement.

I also posted a query in few topic but unfortunately did not getting any help on this, as a matter of fact i sent an email to support as well and got the reply after a week or so but the answer was not there.Please can you look into this post and reply... looking forward for some serious help here.

Wanted to bump this in hopes that I could get some further instruction.

I'm having the same issue with Davinci 14 on our two brand new iMacs. I made sure to do the custom installation to install the PostgreSQL feature, but I'm still getting the same error. The detail in the last post was incredible, but it was meant for windows users. Does anyone have any pointers for Mac users experiencing this problem?

@Seth thanks, I downloaded it and installed it manually according to the instruction manual.

@Dwane I'm trying to create a database on a computer that we can work off of and also host a database. I got it to create a database, but every time I try to connect another computer which is on the same network to it, I get the message that it failed to connect to the server and to check the log file. The error says "Error Failed to connect to the database. Please check log file for more details."

I'd like to think that I followed the instructions in the manual perfectly, but another thing that is happening is it won't let me create a database using my IP address. It just uses the default 127.0.0.1 location, and if I try to manually type in my IP address then it gives another error. I followed all the instructions while installing PostgresSQL and didn't do anything weird. Tried uninstalling and re installing.

EDIT:I just want to note that the manual for Davinci 14 seems to be a little out of date. In the section where it talks about connecting to a server, it talks about Davinci as if it is still 12 ("Open DaVinci Resolve on a computer that’s on the same network as the Database Server. At the DaVinci Resolve login screen, click the Database button in the lower right-hand corner, then click the Connect button at the bottom of the Database Manager." There is no sign in screen in 14, database is not on the right hand corner, and 'connect' is not at the bottom).

What you describe exactly sounds like you have not properly configured the pg_hba.conf to allow IP adresses in your network to access the DB.If not properly configured you can only access the db via 127.0.0.1 (localhost).The right info to do this is on the top of this thread in Dwaines 1st response.p.s. Once done DB has to be restarted to activate the changes.

That makes perfect sense, however I'm still confused. I thought the Davinci 14 manual gave clear instructions on how to do that on page 1309 when it says

"In the following instruction, change the four values of the IP address below to match the one you wrote down, and then keep the number that follows after the forward slash (/) as 24, which specifies that the fourth number of the IP address can be any number. echo “host all all 192.168.1.88/24 md5” >> /Library/PostgreSQL/9.5/data/ pg_hba.conf".

When I do this, it says "/Library/PostgreSQL/9.5/data/: Is a directory". I'm not sure what i'm doing wrong.

EDIT:I went in and edited the text as Dwaine suggested. Realized the problem I was having before was I did not have permission to change the file, so I had to go in and manually give myself permission to do so. Now I'm still stuck. I restarted the computer, opened Davinci, created a new database, and put in my IP in the location. I'm STILL getting the error

"Failed to open databse connection: could not connect to server: Permission denied Is the server runnong on host "192.168.1.0" and accepting TCP/IP connections on port 5432? QPSQL: Unable to connect."

Just in case and not assuming anything:The error message talks about 192.168.1.0 which is not a proper host ip adress normaly but generaly used to adress a whole network segment.Did you configure the ip adress of your connection in the resolve db connection settings correctly ?What is the ip adress of your server that runs the database ? That is the ip you should use for your resolve defined connection.

edit: also a proper notation in the hba file for your network is 192.168.1.0/24

I ended up manually removing Postgres from the computer via terminal. Reinstalled Davinci and followed the instructions in the manual. It's finally allowing me to create a database with my proper IP address.

My co worker keeps getting the error "davinci failed to connect to database. Please check logfile for more details" when he tries to connect. Is this common?

First, you don't need to mess with the pg_hba.conf file at all to use a local PostgreSQL server on the system it's running on. The default IP address that the PostgreSQL Connect dialog uses (127.0.0.1) is the correct IP address for the local PostgreSQL database, and that's what the default pg_hba.conf file supports. You should NOT put your PC IP address in that area, if PostgreSQL is running on the machine.

You should only mess with pg_hba.conf if you wish to allow other Resolve systems to connect to that PostgreSQL database.

In regards to your co-worker, is he on a different Resolve system attempting to connect to your Resolve system? If so, is he on the same network subnet? If he is, and he can't connect to your database, it's almost certain that pg_hba.conf is not properly modified.

Dwaine Maggart wrote:First, you don't need to mess with the pg_hba.conf file at all to use a local PostgreSQL server on the system it's running on. The default IP address that the PostgreSQL Connect dialog uses (127.0.0.1) is the correct IP address for the local PostgreSQL database, and that's what the default pg_hba.conf file supports. You should NOT put your PC IP address in that area, if PostgreSQL is running on the machine.

I'm trying to setup a shared database so I can access all of my projects both on my main workstation and also on my laptop when I'm on the road.I don't need collaborative workflows with more than one user working on several Resolve workstations.I just need a shared database with all my projects.

I'd like to install the PostgreSQL server on a macmini that already has server features for me.so I installed Resolve 14.3 with the PostgreSQL option activated, then rebooted.when I try to create a new database, I get

Dwaine Maggart wrote:I don't have a solution to offer, except to remove macOS server from a system that you want to use as a Resolve database server.

thank you Dwaine. I can't do that for the moment, so I though about another way of getting what I need and would like your opinion.

what if I setup Resolve in the 2 Macs with a disk based database, creating it on one machine, pointing it in a Dropbox folder, and on the second machine simply loading that database?this way, both Macs are able to read from, and save to the same database.

I did a quick test and it seems to work – would you have any recommendation against it for some reason, or it's just as simple as it sound?

out of curiosity, is it just a matter of user?what if the two machines have the same user account and names?anyway I did a quick test with a new database with a couple of test projects and it seemed to work. but I trust you guys and won't go down this road.

I would just hope that macOS server wasn't conflicting with PostgreSQL.

and last question.suppose I get the PostgreSQL server running on machine A.what happens if machine A hosts the DB, and machine B is trying to access that while machine A is turned off?is there some level of caching?would I be able to at least "see" the projects and load them, then saving them?

Unfortunately, macOS Server does interfere with Resolve's use of PostgreSQL.

Last question answer: If machine A is turned off, there is no database for machine B to access.

This is why we suggest a dedicated machine is used for the PostgreSQL server.

You can certainly setup sharing on all the Resolve clients that have PostgreSQL installed, so one machine can access another's projects. The problem with that is, when the machine hosting the database/project, and running Resolve crashes or hangs. Then the other machine connected to it will lose access to the project, and both systems will be down.

So best that the machine hosting the database isn't being used for other things that might hang/crash it.

Dwaine Maggart wrote:You can certainly setup sharing on all the Resolve clients that have PostgreSQL installed, so one machine can access another's projects. The problem with that is, when the machine hosting the database/project, and running Resolve crashes or hangs. Then the other machine connected to it will lose access to the project, and both systems will be down.

So best that the machine hosting the database isn't being used for other things that might hang/crash it.

thanks Dwaine, very helpful answer.

in my scenario, I work alone and I don't need to use Resolve at the same time on more machines.so let's say that machine A is the main workstation and machine B is the laptop.I work on machine A the 70% of times, and 30% I'm on the road on the laptop. usually I start projects on A and then keep working on B on the road, and then finishing them again on A – but sometimes I start them on B while away from the studio.At the moment I can't justify to get a new machine running 24/7 just to host the db.

so in this scenario, what would you recommend? is there any workaround or solution?Is it the whole macOS server that interferes or just some module/service/daemon that I could turn off?thanks for helping, highly appreciated!

In your scenario, a shared database server just doesn't work at all, while the laptop is away from the server.

Seems like the only option is to have a copy of the project on both systems. But if you start a project on machine A and want to use machine B with that project on the road, you'd need to get the A project copied into the B local database. Then when B comes back to A, you'd need to copy the B project over to the A machine.

You could move projects back and forth between machines when they were both together, by using a shared database. Or you could export a project .drp and import it to the other system.

Dwaine Maggart wrote:In your scenario, a shared database server just doesn't work at all, while the laptop is away from the server.

thanks Dwaine,I don't understand your point. if I'll be able to setup a server for the Resolve database, why wouldn't be the best for me? I would have a centralized access to all the ongoing projects, from machine A and B. and if the server is on 24/7, I think it's the best option.am I missing something?

moving .drp's back and forth has been my way to go forever. but as I use Resolve more and more also for editing and starting projects, I was looking for a better alternative.

The on the road VPN solution could work if you keep- Working database small as affects resolve startup / loading time (latency , network speed)- Leave autosave or livesave stuff off . Just do a manual save at times (depending project size and network speed this can be sloooow). So most DB access will be only during startup and project load and safe.- Resolve will die on you if connection drops.

Alternatively you could use your VPN to just connect and export a project from your home DB and load it in your local DB on the road. Then when finished push it back or do that at home. At least you have access to the DB every where. You still of course need to bring all your media files.

However, you can copy all the projects from a PostgreSQL database into a Disk database, if you desire.

thanks @Dwaine Maggart,a couple of questions about that.I've decided to switch to disk db from now on.

- what is the best way for moving ALL of my old projects from PostgreSQL to disk db? I can see in the manual that you can copy/paste from one to another. Should I do that one project at a time, or also more than one? and what about archived projects inside a folder? and what about stills/etc.?

- I noticed that when I switch to a project inside the new disk db, I can't see my export presets and data burn-in presets. I guess it's because my presets were created in the PostgreSQL environment. Is there a way to import these as well? I tried to look around but I can't find anything about this. I have many many presets and it would take so long to re-create all of those in the new disk db. any solution?