Page Comparison

...

1. configure database to enable networking

   1. edit the file: postgresql.conf
      Linux: /etc/postgresql/{version}/main/postgresql.conf
      MacOS: /usr/local/var/postgresql.conf
      Windows: C:\Program Files\PostgreSQL\{version}\data\postgresql.conf

   2. remove the # before the line: listen_addresses = '*'
      This allows access from all IP addresses.

   3. save the file
      

2. allow access from remote workstation

   1. edit the file: pg_hba.conf
      Linux: /etc/postgresql/{version}/main/pg_hba.conf
      MacOS: /usr/local/var/pg_hba.conf
      Windows: C:\Program Files\PostgreSQL\{version}\data\pg_hba.conf

   2. add this line to the block IPV4:

# TheTYPE same usingDATABASE a host name (would typically cover both IPv4 and IPv6).
# TYPE DATABASE USER CIDR-ADDRESS  METHOD host    all    CIDR-ADDRESS         all   METHOD
# IPv4        localhost               trustlocal connections
host    all             all             0.0.0.0/0               trust

...