Welcome to our community

Be a part of something great, join today!

Register Log in
  • Hey all, just changed over the backend after 15 years I figured time to give it a bit of an update, its probably gonna be a bit weird for most of you and i am sure there is a few bugs to work out but it should kinda work the same as before... hopefully :)

Resolve 14 and postgres setup help

S

Simon Buxton

Well-known member
Joined
Mar 9, 2013
Messages
90
Reaction score
0
Points
6
I'm looking for help with setting up postgres. Basically stuck at the first hurdle, and wondering if it is because i'm trying to do this in 14.

Have installed postgres after installing resolve studio 14 and do not yet have the /data/ folder, but cannot find any instruction specific to resolve for what the server should be setup as.

Can anyone help? The part i'm struggling on seems to be the part that no online tutorial mentions. Initial server setup settings.
 
What are you trying to set up Simon? A Resolve database server for multiple client access? Or just a local PostgreSQL database?

What type of system are you on? Mac, Windows or Linux?
 
Hi Dwaine,

Trying to setup the postgresSQL database so that I can access my projects from various computers in our company. I've attempted the steps in the manual but i'm missing the sql server setup instructions, i've done similar things for webserver sql databases but i still think there needs to be a part of the manual I haven't found yet for this feature in resolve. I've already bought multiple licenses for this so i'm pretty bummed out that I cant set it up.

Any help greatly appreciated :)
 
Hi Simon,

You don't mention what type of system you are trying to do this on. Basically, the supported easy way to do this is to install Resolve on the database server, and let it install and setup PostgreSQL. Then follow the directions in the Resolve user manual for modifying pg_hba.conf to allow remote access to the database.
 
Sorry, Macintosh 10.12.6, Sierra

I used the reslove (14) install dmg to add the postgres server to an existing resolve 14 install, but it never set it up - the /data/ area is still empty. Should this be populated by resolve on install of postgres? I'm not at the modifying stage yet as there is nothing to modify. Im on the USB dongle version.

Thanks for you time and suggestions.
 
Open the Mac Activity Monitor. In the View menu, select Show All Processes. Sort by Process Name. Scroll down the p area. If PostgreSQL is running, you should see several postgres processes.


If PostgreSQL appears to be running, launch Resolve and show the Database area on the Project Manager page, and attempt to make a new PostgreSQL database. What happens?
 
Postgres is not running. I think resolve didnt set up the server automatically, which i guess is my question. Is Resolve supposed to create the server automatically upon installation of postgres?
 
Yes, postgres should be running as soon as the Resolve installer completes. In the Mac Applications folder, how many PostgreSQL folders are there and what are their version numbers?
 
OK, I think i'm getting somewhere, i did a fresh download and install of resolve and a new install, I now have a postgres folder in the apps folder and could create a database. I'm not sure if the bug was from trying to just add the postgres install in the resolve installer (to an existing resolve install) or in the package version i had previously. Now to try and get this working!

Thank you for your help and patience.
 
Now i'm in! I have a shared database that I can open on my laptop. (This is just a test before I head to the US next month to buy new hardware for extra workstations)

I exported / imported a project from my macpro (host of the server) and it works fine on the macpro, but obviously on the laptop the files do not connect as the address for the files is not absolute, merely relative to the installation on the macpro. I know this is not how the collaboration feature is intended to be used, but I added the drives to the laptop using 'connect to server' and all the media files are now found, which is awesome. Playback 1 to 5 frame per second over wifi :)

Once I get the 10gbe network hardware I think I should be able to use this as intended by BMD. Thank you very much for your help. Please let me know if you see something i've written here as being completely wrong!
 
You should have a /Library/PostgreSQL/9.5 folder. It should definitely NOT have pgAdmin3 and Stack Builder in it.

You should ALSO have a PostgreSQL 9.5 folder in the Mac Applications folder, and that's where pgAdmin3 and Stack Builder should be.

It sounds like your PostgreSQL install is not correct.

Assuming this is a new PostgreSQL install, and assuming you are sure you have no Resolve project data in a PostgreSQL database, and assuming you don't also have an 8.4 folder in /Library/PostgreSQL, and assuming you don't have a PostgreSQL 8.4 folder in Applications, it would probably be best to start over with PostgreSQL be deleting it and running the Resolve installer again to reinstall it.

If those assumptions are valid, Trash the /Library/PostgreSQL folder. Empty the Trash.

Open the Mac Terminal app and type the following:

sudo dscl . delete /users/postgres<RETURN> (This will ask for a password, which should be the systems Admin password) (<RETURN> means to press the Return key, don't type <RETURN>)

Using a Resolve 12.5.3 or higher installer (free or Studio), run the installer:

At the Installation Type step of the installer, in the lower left area, select Customize.

In the upper Custom Install area, select the PostgreSQL Server checkbox.

Finish the installation.

Look in the Applications folder. If you see a PostgreSQL 9.5 folder, things went properly.

Verify that PostgreSQL is running by opening the Mac Utilities Activity Monitor.

In the Activity Monitor View menu, select All Processes.

Sort on the Process Name column and scroll down to the P's area.

If you see several postgres processes running (normally 8) then PostgreSQL is running.
 
You must log in or register to reply here.
Back
Top