MacPro: Difference between revisions
Line 26: | Line 26: | ||
<code>sudo vim /Library/PostgreSQL/13/data/pg_hba.conf</code> | <code>sudo vim /Library/PostgreSQL/13/data/pg_hba.conf</code> | ||
Update the config as such: | |||
<syntaxhighlight> | <syntaxhighlight> | ||
# pg_hba.conf file has been edited by DaVinci Project Server. Hence, it is recommended to not edit this file manually. | # pg_hba.conf file has been edited by DaVinci Project Server. Hence, it is recommended to not edit this file manually. | ||
Line 38: | Line 39: | ||
'''Note:''' You ''must'' add entries for hosting the WAN (e.g. 192.168.1.0/24) and the VPN (192.168.3.0/24). | '''Note:''' You ''must'' add entries for hosting the WAN (e.g. 192.168.1.0/24) and the VPN (192.168.3.0/24). | ||
====Restart Postgres==== | ====Restart Postgres==== | ||
Revision as of 03:04, 10 January 2024
The MacPro is a server that hosts a variety of services like the DaVinci Resolve Server.
Born in 2012 and still a formidable machine. It has been upgraded with a dual hex-core (12-core) Xeon Processors, 1TB NVMe storage, and 96GB RAM.
It can edit 6K video and it can still burn CD-ROMs!
For security, there is no port forwarding to the device; it can only be accessed via SSH or VNC over VPN.
Local Editing Workstation
Remote Desktop
DaVinci Resolve
Video editing via resolve locally or remote.
Hosting
DaVinci Resolve Server
The MacPro hosts the DaVinci Resolve Server via PostgreSQL.
Configuration File
Here is the location of the config:
sudo vim /Library/PostgreSQL/13/data/pg_hba.conf
Update the config as such:
# pg_hba.conf file has been edited by DaVinci Project Server. Hence, it is recommended to not edit this file manually.
# TYPE DATABASE USER ADDRESS METHOD
local all all scram-sha-256
host all all 127.0.0.1/32 scram-sha-256
host all all ::1/128 scram-sha-256
host all all 192.168.1.0/24 scram-sha-256
host all all 192.168.3.0/24 scram-sha-256
Note: You must add entries for hosting the WAN (e.g. 192.168.1.0/24) and the VPN (192.168.3.0/24).
Restart Postgres
sudo -u postgres /Library/PostgreSQL/13/bin/pg_ctl restart -D /Library/PostgreSQL/13/data
Daily Logs
sudo ls /Library/PostgreSQL/13/data/log
Software Updates
We use OpenCore to keep MacOS up-to-date and extend the life of this now vintage machine.
As a result, WiFi and Bluetooth no longer work as of OS X Catalina.