User Manual

Manually Setting Up a
Linux Project Server
These instructions are only appropriate for systems created with the DaVinci Resolve CentOS
6.x/7.3 build image ISO. The default PostgreSQL install is set up to only allow connections to
the database from the local host IP address. Remote systems will not be able to access the
database. To change this, you need to modify the “pg_hba.conf” file as detailed below.
Open a shell on the desktop and type:
su<ENTER>
You’ll be prompted for the password. The password will be “DaVinci” for DaVinci Resolve
Legacy CentOS 6.x installs. For CentOS 7.3 installs, the password is whatever root password
you chose.
Based on which install you have, type either of the following:
For legacy DaVinci Resolve installs:
cd /db/PostgreSQL/8.4/data<ENTER>
For CentOS 7.3 standalone DaVinci Resolve installs:
cd /db/PostgreSQL/9.2/data<ENTER>
This puts you into the directory with the “pg_hba.conf” file.
Next, type:
ls<ENTER>
This lists the files in the directory. Make sure you see the pg_hba.conf file. If you do not, type
pwd<ENTER> to make sure you are really in the proper directory.
Next, type:
cp pg_hba.conf pg_hba.conf.bk<ENTER>
This makes a backup copy of “pg_hba.conf” in case something goes wrong.
Next, use a text editor such as vi or nano to edit the “pg_hba.conf” file. Once you have the file
open in a suitable editor, go to the bottom of the file and add the following line:
host all all 192.168.1.88/24 md5
Use the tab key to format the text to match the line above, just to keep things tidy. More
importantly, the “192.168.1.88” IP address used above should be replaced by the IP address of
your actual server; this will allow any other computer on the 192.168.1.x subnet (or whatever
YOUR actual subnet is) to access the database. Note that there is no space after the 88 and
before the /24.
Once you have added the line above, save the changes and exit the editor. As a sanity check,
you can type:
cat pg_hba.conf<ENTER>
This shows the contents of the file and verifies that your change at the end of the file is correct.
Lastly, enter the following:
service postgresql restart<ENTER>
This restarts the PostgreSQL server, which will now use the new “pg_hba.conf” information.
After the restart, other DaVinci Resolve systems on the same network subnet should be able to
create and connect to databases on this server.
Chapter – 177 Managing Databases and Project Servers 3564