Fri Jun 30, 2017 6:52 am
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.
Dwaine Maggart
Blackmagic Design DaVinci Support