Editing PostgreSQL pg hba.conf

https://www.postgresql.org/docs/current/auth-pg-hba-conf.html

<code>[[pg_hba.conf]]</code> client [[authentication]] configuration file.
* <code>[[/etc/postgresql/14/main/pg_hba.conf]]</code>
* <code>[[/etc/postgresql/13/main/pg_hba.conf]]</code>
* <code>[[/etc/postgresql/12/main/pg_hba.conf]]</code>
* <code> /etc/postgresql/11/main/pg_hba.conf</code>
* <code> /etc/postgresql/10/main/pg_hba.conf</code>


[[Amazon Linux 2]]: <code>[[/usr/share/pgsql/pg hba.conf.sample]]</code>


https://www.postgresql.org/docs/11/runtime-config-connection.html#RUNTIME-CONFIG-CONNECTION-SETTINGS
 
* <code>[[listen_addresses]]</code>
* <code>listen_addresses 0.0.0.0</code>


== Remote communication ==
 cat /etc/postgresql/*/main/[[pg_hba.conf]] | grep -v "#" | grep .
 local   all             postgres                                peer
 local   all             all                                     peer
 host    all             all             127.0.0.1/32            md5
 host    all             all             ::1/128                 md5
 local   replication     all                                     peer
 host    replication     all             127.0.0.1/32            md5
 host    replication     all             ::1/128                 md5


To allow remote communications from all [[IP]]s <ref>https://stackoverflow.com/questions/18580066/how-to-allow-remote-access-to-postgresql-database</ref>:
 /etc/postgresql/*/main/[[pg_hba.conf]] 
 local   all             postgres                                peer
 local   all             all                                     peer
 host    all             all             '''0.0.0.0/0'''               md5
 host    all             all             '''::/0'''                    md5
 local   replication     all                                     peer
 host    replication     all             127.0.0.1/32            md5
 host    replication     all             ::1/128                 md5

== Related terms ==
* <code>[[psql]]</code> command line cli and <code>[[.psqlrc]]</code> configuration file
* <code>[[/etc/postgresql/12/main/postgresql.conf]]</code>
* <code>[[$HOME/.pg_service.conf]]</code>
* <code>[Nest] 41  - 09/27/2022, 10:12:12 PM   ERROR [ExceptionHandler] [[no pg_hba.conf entry for host]] "20.10.2.58", user "your-user", database "your-db", SSL off</code>
* <code>[[no pg_hba.conf entry for host]]</code>

== See also ==
* {{PostgreSQL}}


[[Category:PosgreSQL]]