Setting up a PostgreSQL Database Server Resolve 14.3.1

I've been at this for hours and it's driving me insane, has anyone actually successfully setup a PostgreSQL Server that works. So Resolve 14.3.1 on a clean install of Sierra, installed PostgreSQL with 14.3.1 but nothing is the same as it states in the manual or as I can find on the internet.

1 - sudo su - postgres throws back an "su: unknown login: postgres" error.
2 - There is no Postgres folder in my Applications folder which many websites say should exist.
3 - In /Library/PostgreSQL/9.5 there is not "data" folder.
4 - And it goes on and on and on and on and on and on with no bloody success.

Why the hell does this have to be so complicated and why does nothing match whats written in the manual.

In the Resolve installer ensure that the PostgreSQL option is enabled.
On OS X, in the Resolve installer select "Customise" to access this option.



This creates a "PostgreSQL 9.5" folder in Applications
[which contains the Application Stack Builder application, a Documentation folder, pgAdmin III, Reload Configuration and SQL Shell (sql)].

If this is folder is not present once installation has completed, navigate to the following directory:
System Drive > Library > Application Support > BlackMagic Design > DaVinci Resolve > Upgrade PostgreSQL

and run the "Upgrade to PostgreSQL 9.5" script in that folder.
The script automatically opens Terminal. Type in your Admin password and run the script.
This should then create the "PostgreSQL 9.5" folder in Applications.

Yeah, unfortunately the documentation is still a bit spotty.

When you run through the Resolve 14.3.1 Studio installer on macOS, look for the little “Customize” button, and be sure to have the PostgreSQL item checked. It’s very easy to fly through and miss it.

Then the DaVinci Resolve Project Server app should work fine.

I recommend my script for macOS for backups.

https://github.com/sethgoldin/davinci-r ... flow-tools


Sent from my iPhone using Tapatalk

Reynaud beat me to it! With pictures!


Sent from my iPhone using Tapatalk

Thank you.

I did do the custom install but I was afraid to run the "Upgrade to PostgreSQL" script because I thought it might affect my current database. I made a backup of it ran the script as you said and I now seem to be getting somewhere. Hopefully I can get this to work.

I appreciate your help.

Ok it all seems to be installed but now it seems like the version 14 manual refers to an older version of Resolve. There is no + sign so I clicked on "New Database" but I am unable to create a Database. I keep getting the same error. I don't see anything anywhere about selecting a QPSQL Driver and I keep getting the error that's in my screenshot.

I can't seem to add the screenshot.

Here it is.

What would be the next step.
I can't seem to create a Database or Connect to one.

Please BM update your manual so dummies like me don't have to go through this pain and suffering.
This has been an absolutely unproductive day all for something that should take 5 minutes to set up.

Here's what I'm trying to Create.

Hop over into the Project Server app and enable sharing on the particular database. Also, switch your local network connection from “DHCP” to DHCP with manual address” so that you have a static IP.


Sent from my iPhone using Tapatalk

I don't know where the Project Server app is or what your mean by "Project Server app".
My system IP is locked to an IP by its MAC address.

Thanks

It’s called “DaVinci Resolve Project Server.” It should be on whatever computer you set PostgreSQL up on.

The server itself must have a static IP address, and then you must enable sharing on that database.

This can be done in the command line by modifying the `pg_hba.conf` file, but that’s complicated if you’ve never done it before. The Project Server app is a quick and easy way to do it with a nice GUI.


Sent from my iPhone using Tapatalk

It seems like the pg_hba.conf file that should be in the /Library/PostgreSQL/9.5/data Folder is nonexistent based on the error message that pops up.

If you’ve installed PostgreSQL, it’s there. The file is a config file that needs a particular line written out to specify that that database can be shared i.e. accessed by other workstations on the network.

However, this is complicated to do, so the easier way to do it is just to enable sharing via the GUI by using the “DaVinci Resolve Project Server” app on the computer that has PostgreSQL installed.


Sent from my iPhone using Tapatalk

Ok so I found that in the Resolve folder which is inside of the Applications folder and I've set my IP manually to a Static IP but I'm seeing 127.0.0.1 as in the next screenshot.

Do you have the free version or the $300 Studio version?


Sent from my iPhone using Tapatalk

I'm running the Studio Version.
Actually I own three Studio Licenses.

So the app is showing that you’re only sharing locally. 127.0.0.1 is the machine itself. You need to share with a static IP set up.


Sent from my iPhone using Tapatalk

I've discovered that the pg_hba.conf file doesn't exist and I have no idea how to create and configure it.

I want to thank everyone who tried to help me solve this issue, I really appreciate all of your efforts. I also want to apologize for coming off so harsh in my posts. After a few hours of frustration I found it difficult to type a post without sounding like I wanted to kill or blow something up.

Anyway, after a "calm" phone call to BM I found out that the manual I was using isn't current enough and contains some errors. Unfortunately I may have really screwed things up because now the "DaVinci Resolve Project Server" always gives me the error in the attached screen shot and then I'm only able to exit out of it.

I think the PostgreSQL Server is no longer running but since I'm not very good in terminal and nothing it spews out matches whats in the manuals I'm clueless as to what the problem is. Hopefully I can get someone at BM to remote in and fix this because I'm more than likely just going to make things even worse.

For anyone who attempts this almost impossible feat just know that the latest manual is pretty much useless as well. It has no installation info and states nothing about what to do when the installer doesn't install everything it's supposed to like it did for me. Like I'm just supposed to know that I have to navigate to /Library/Application Support/Blackmagic Design/DaVinci Resolve/Upgrade PostgreSQL and run the "Upgrade to PostgreSQL 9.5" Script the very first time I attempt to get it working.

To check if Postgres is running open Activity Monitor (Applications > Utilities), ensure all Processes are currently monitored (View menu > All Processes ticked) and search for "Postgres".

Activity monitor.png (65.49 KiB) Viewed 28078 times

The same may be achieved via Terminal by typing:
ps auxwww | grep postgres

Terminal.png (79.79 KiB) Viewed 28078 times