Page Comparison

...

After the setup of the Postgres Server you need to configure the server to allow access from a remote workstation. There are two files that need changes:

1. configure access database to the databaseenable 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:

...