MacPro: Difference between revisions

From Wreckroom
Jump to navigation Jump to search
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:====
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

File:MacPro.png
Classic Mac Pro

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.