Postgres setup help

Get answers to your questions about color grading, editing and finishing with DaVinci Resolve.
  • Author
  • Message
Offline

Lukas Sinkevicius

  • Posts: 4
  • Joined: Thu Jun 29, 2017 7:24 pm

Postgres setup help

PostThu Jun 29, 2017 7:30 pm

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.
Offline

Anish Prithviraj

Blackmagic Design

  • Posts: 44
  • Joined: Wed Sep 12, 2012 11:13 am

Re: Postgres setup help

PostFri Jun 30, 2017 2:03 am

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.
Anish Prithviraj
Offline
User avatar

Dwaine Maggart

Blackmagic Design

  • Posts: 4411
  • Joined: Wed Aug 22, 2012 2:53 pm

Re: Postgres setup help

PostFri 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
Offline

Lukas Sinkevicius

  • Posts: 4
  • Joined: Thu Jun 29, 2017 7:24 pm

Re: Postgres setup help

PostFri Jun 30, 2017 5:23 pm

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?
Offline
User avatar

Dwaine Maggart

Blackmagic Design

  • Posts: 4411
  • Joined: Wed Aug 22, 2012 2:53 pm

Re: Postgres setup help

PostFri Jun 30, 2017 5:56 pm

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 Maggart
Blackmagic Design DaVinci Support
Offline

Lukas Sinkevicius

  • Posts: 4
  • Joined: Thu Jun 29, 2017 7:24 pm

Re: Postgres setup help

PostFri Jul 28, 2017 7:15 pm

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

StevenCalkins

  • Posts: 4
  • Joined: Fri Aug 17, 2018 11:41 am
  • Real Name: Steven Calkins

Re: Postgres setup help

PostFri Aug 17, 2018 11:46 am

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:?
Offline

Peter Chamberlain

Blackmagic Design

  • Posts: 4777
  • Joined: Wed Aug 22, 2012 7:08 am

Re: Postgres setup help

PostSun Aug 19, 2018 7:52 pm

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

StevenCalkins

  • Posts: 4
  • Joined: Fri Aug 17, 2018 11:41 am
  • Real Name: Steven Calkins

Re: Postgres setup help

PostMon Aug 20, 2018 9:22 am

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

StevenCalkins

  • Posts: 4
  • Joined: Fri Aug 17, 2018 11:41 am
  • Real Name: Steven Calkins

Re: Postgres setup help

PostMon Aug 20, 2018 12:59 pm

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?
Offline

StevenCalkins

  • Posts: 4
  • Joined: Fri Aug 17, 2018 11:41 am
  • Real Name: Steven Calkins

Re: Postgres setup help

PostMon Aug 20, 2018 6:36 pm

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?
Offline
User avatar

Dwaine Maggart

Blackmagic Design

  • Posts: 4411
  • Joined: Wed Aug 22, 2012 2:53 pm

Re: Postgres setup help

PostTue Aug 21, 2018 8:06 am

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.
Dwaine Maggart
Blackmagic Design DaVinci Support

Return to DaVinci Resolve

Who is online

Users browsing this forum: AndreasOberg, Browneye9999, Google [Bot], John Griffin, RCModelReviews and 25 guests