MacPro: Difference between revisions
| Line 17: | Line 17: | ||
<code>sudo vim /Library/PostgreSQL/13/data/pg_hba.conf</code> | <code>sudo vim /Library/PostgreSQL/13/data/pg_hba.conf</code> | ||
<code> | |||
# 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 | |||
</code> | |||
'''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 00:34, 10 January 2024
The MacPro is a server that hosts a variety of services like the DaVinci Resolve Server.
Born in 2012, it is still a formidable machine, and 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.
DaVinci Resolve Server
The MacPro hosts the DaVinci Resolve Server via PostgreSQL.
Configuration
sudo vim /Library/PostgreSQL/13/data/pg_hba.conf
- 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.