Page Comparison

...

https://www.sqlshack.com/setting-up-a-postgresql-database-on-mac/

brew install postgres

/usr/local/var/pg_hba.conf

/usr/local/var/pg_hba.conf

Setup Postgres Server - Windows

...

Edit pg_hba.conf and allow Users access the database.

File location pg_hba.conf

Windows: C:\Program Files\PostgreSQL\14\data\pg_hba.conf
MacOS: /usr/local/var/pg_hba.conf

1. configure access to the database

   1. edit postgresql.conf
      Windows: C:\Program Files\PostgreSQL\14\data\postgresql.conf
      MacOS: /usr/local/var/postgresql.conf

   2. edit line: listen_addresses = '*'

2. allow User access

   1. edit pg_hba.conf

   2. edit block:

# TYPE DATABASE USER CIDR-ADDRESS  METHOD
host  all  all 0.0.0.0/0 md5trust