Need Help with Collaboration and PostgreSQL Server

Hello All.

After recieving my Davinci Resolve Studio license, I am having some trouble setting up collaboration features on my network.

I am new to the world of servers, so go easy!

What I am trying to do is to have 2 computers, both connected via ethernet to the same network, have a server in common so that both can edit at the same time. After watching a few YouTube videos, I have come up with these steps:

1. Create new PostgreSQL server on Computer 1 (host.)
2. Go to the Project Server and enable sharing.
3. Create a Resolve Access Key, and save it on a common network drive.
4. On Computer 2, drag the access key from the File Explorer to Davinci Resolve.

After which Computer 2 *should* say something along the lines of "connected successfully."
However, I get an error message that says "Failed to connect to the database. Please check log file for more details." (Also I don't know where this log file is because I'm that much of a noob. )

Also, before you guys ask:
•Both computers have Davinci Resolve Studio.
•Both computers have PostgreSQL installed, which came with the Davinci Resolve Project Server installation.
•Both computers are connected to the same network via Ethernet.

Help is appreciated!

Setting up a PostgreSQL Database Server Resolve 17 need help

UPDATE: After browsing Youtube, I have found the solution to this problem.

The problem was that although PostgreSQL was installed, its port, 5432, was not enabled in Windows Firewall settings.

The following instructions will enable communication through port 5432.

1. Open Windows Defender Firewall (firewall settings, inside Control Panel)
2. Go to "Advanced Settings" (left side.)
3. Go to Inbound Rules (left side.) This is where we will allow the PostgreSQL port.
4. Press "New Rule" under Actions (right side)
5. Change the option from "Program" to "Port," then press next.
6. Keep the TCP option, and under "specific local ports" type "5432," then press next.
7. Allow the connection, then press next.
8. Make sure to allow Domain, Private, and Public options, then press next.
9. Name the rule whatever you'd like, something like "PostgreSQL for Davinci Resolve" etc. and description as well.

Now after generating a key in the Davinci Resolve Project Server and opening it on the remote location, Collaboration Features should now work.

That's good. A tip: you don't need PostgreSQL installed on the other machine, but having it installed won't hurt anything.

An alternative to clicking around in the confusing Windows firewall GUI is this one-liner to run in an elevated command prompt:

Code: Select all

netsh advfirewall firewall add rule name=Postgres action=allow dir=in protocol=TCP localport=5432 profile=any

This is of course only recommended if your Windows Postgres server is not accessible from the Internet, and only on your LAN. It will allow connections from any machine on the network to the local Windows PostgreSQL server.

And if it still doesn't work, make sure that you edited your "postgresql.conf" file to replace the default
listen_addresses = 'localhost'
with

Code: Select all

listen_addresses = '*'

or something like

Code: Select all

listen_addresses = '192.168.1.0/24' # your local network