Postgres setup help

Hi,
I'm trying to set up windows computer as postgres server so could this and another Mac computer work together on projects on same network. I'm using Resolve 14 beta 4 studio on both machines. I created successfully postgres database on windows but not sure if in correct way and mac computer can't connect to it.
I couldn't find anything useful in the resolve manual because it was mainly talking about mac.
What is the way to create this 2 computer on same network workflow?

P.S. I'm so sorry if this has been already asked, but google was not an useful friends this time so I hope I can get help here.

[Anish Prithviraj]

Hi Lukas,

I believe the manual lists the instructions for Mac. Similar to the Mac, the pg_hba.conf file needs to be modified on Windows. It is located at:
C:\Program Files\PostgreSQL\9.5\data\pg_hba.conf

Add an entry in there as specified in the manual and restart the server.

[Dwaine Maggart]

Below is a bit more detailed version of Anish's description.

Note that it references 9.2 as the PostgreSQL folder, which is what we've used until recently. If you have version 9.5 installed, replace 9.2 with 9.5.

Windows Database Server Setup

This procedure is the Windows equivalent of the Mac procedure on page 1071 of the Resolve 12 Reference manual.

Note: If you are using Windows Firewall, you will need to add C:\Program Files\PostgreSQL\9.2\bin\postgres.exe to the Allowed apps list. Private network only.

To set up a Windows system as a DaVinci Resolve database server:

1. If you haven’t already, install the full version of DaVinci Resolve on the Windows PC that you plan
to use as the remote Database Server. This machine doesn’t need video cards or a dongle
connected (although it’s good to have a dongle available for the last step), but the Resolve
application installer sets up PostgreSQL as well as the database structure which is configured
for Resolve. Make sure you check the PostgreSQL checkbox on the Resolve Installer window, as that is no longer checked by default in Resolve 12.
Once you have installed the software, you need to set up the
permissions and access to the PostgreSQL server application running on this machine. Be
sure to follow the instructions carefully.

2. Open an Explorer window and navigate to the C:\Program Files\PostgreSQL\9.2\data folder.

3. Make a backup copy of the pg_hba.conf file.

4. Open the pg_hba.conf file in Notepad. You need to open Notepad in Admin mode, or it won't let you save changes to this file.

5. Scroll to the bottom of the file. Add a new line at the end of the file:

host all all 192.168.1.88/24 md5

The IP address in the new line (192.168.1.88 above) should match your IP subnet. So if the IP address of the PC is 192.168.10.212, then you should enter 192.168.10.212 in the new line. Make sure you put the /24 at the end of the IP address. This will allow any other Resolve system on that subnet to connect to the database.

6. After adding the new line, Save the pg_hba.conf file, then exit Notepad.

7. You will then need to restart the PC for this change to take effect.

Thank you Dwaine! I was able to set up database and connect it from the mac.
My issue right now is that I also shared my hard drives from windows to see on the mac. Everything works. But in resolve when I use files on PC the pathway is either straight to HDD or through Network example: \\desktop-82etc123/SSD Drive 4TB/Projects
When I open on Mac the same project it does not see it. So if I show the Network HDD it goes like this example: \\Volumes\SSD Drive 4TB\Projects
Is it possible for both machines to see the hard drive correctly without the need to change path everytime?

[Dwaine Maggart]

Yes. In Resolve Preferences - Media Storage, there is a column called Mapped Mount.

This allows you to map between different mount types.

Details in the manual. Search for Mapped Mount.

Dwaine,
Sorry for late reply but thank you so much for your help!

Hi, I tried to install Postgres on my F: partition in Windows, due to lack of space but the DaVinci Resolve installer doesn't find it. When I start Davinci it says: "DaVinci Resolve Project Server could not find a PostgreSQL installation on this machine." What should I do? Does PostgreSQL have to be on C:?

[Peter Chamberlain]

You should use the Resolve installer to install the PostGres server app and yes, on c drive

Okay thanks for the information, maybe I'll try in in my Mac VM.

I tried to install on C: using the setup in the installer but windows 10 says that the password does not meet the complexity requirements. Any ideas what I should do?

I managed on my own to extract the PostgreSQL installer out of the installer and I provided a password complex enough to satisfy Windows 10, then after I installed the PostGreSQL separately, i installed Davinci Resolve. It recognized that Postgres was installed so now I can use Resolve. So now Resolve works but it doesn't know about my password. Where can I change the password used by Resolve so that DaVinci Resolve recognizes the installed PostgreSQL version?

[Dwaine Maggart]

The Resolve Project Server app is not going to work unless the PostgreSQL password is DaVinci.

However, there is no issue creating and connecting to new PostgreSQL databases in the Resolve Project Manager page using your changed password.

Hi,

I'm also running into to password complexity issue.
Can anybody tell me:
A. if I can manually install either PostgreSQL 9.5.14 or 9.6.6 to solve this issue?
or
B. How you managed to get the PostgreSQL installer out of the Resolve installer?
or
C. Any other solution that will help me out.

Your help is greatly appriciated

You can manually install and setup PostgreSQL. There is no issue with that in Linux, I don't think Windows would be different. You just have to make sure the password for user postgres is set to DaVinci before you launch Resolve for the first time.

Thanks Igor,

I know, but for Windows, there are only installers for 9.5.14 and 9.6.6 or higher.
I'm aware that there are other methods, like downloading the proper zip archive and installing through a command line. But some of that is not allowed by the security policy on the machines we use.
That's why I asked about the other versions.

I do think we'll end up going this route. But it would be great if I could find a method that is slightly more user-friendly for my colleagues.

Thanks for your reply though!