MacPro: Difference between revisions
| Line 25: | Line 25: | ||
Here is the location of the config: | Here is the location of the config: | ||
<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: | Update the config as such: | ||
Revision as of 02:45, 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-256Note: 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.