Editing MacPro (section)

=== Configuration File===
Here is the location of the config:

<code>sudo vim /Library/PostgreSQL/13/data/pg_hba.conf</code>

For the initial configuration, update the config as such:

<syntaxhighlight>
# 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
</syntaxhighlight>

'''Note:''' You ''must'' add entries for hosting the WAN (e.g. 192.168.1.0/24) and the VPN (192.168.3.0/24). The VPN address will always need to be added, otherwise you will not be able to connect from [[VPN]].

====Restart Postgres====

Restart the postgres services via terminal to apply changes to config:
=====Big Sur=====
<code>sudo -u postgres /Library/PostgreSQL/13/bin/pg_ctl restart -D /Library/PostgreSQL/13/data</code>