PostgreSQL pg hba.conf

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

• HBA Host Based Authentication

pg_hba.conf client authentication configuration file.

• /etc/postgresql/14/main/pg_hba.conf
• /etc/postgresql/13/main/pg_hba.conf
• /etc/postgresql/12/main/pg_hba.conf
• /etc/postgresql/11/main/pg_hba.conf
• /etc/postgresql/10/main/pg_hba.conf

Amazon Linux 2:

• /usr/share/pgsql/pg_hba.conf.sample
• /var/lib/pgsql/data/pg_hba.conf (sudo service postgresql initdb)

https://www.postgresql.org/docs/11/runtime-config-connection.html#RUNTIME-CONFIG-CONNECTION-SETTINGS

• listen_addresses
• listen_addresses 0.0.0.0

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 IPs :

/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

Errors

• [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
• no pg_hba.conf entry for host

Related terms

• psql command line cli and .psqlrc configuration file
• /etc/postgresql/12/main/postgresql.conf
• $HOME/.pg_service.conf
• ident

See also

• pg_hba.conf, peer, md5
• PostgreSQL: pg_dump, pg_restore, pgAdmin, pg_config, psql, pg_ctl, pg_isready, initdb, Role, Schema, DBeaver, Navicat, DataGrip, OmniDB, Adminer, docker-compose.xml PostgreSQL, PostgreSQL version, PostgreSQL logs, postgresql.conf, pg_hba.conf, $HOME/.pg_service.conf, Create database (PostgreSQL), Create user, createdb, GRANT, pg_stat, PostgreSQL VACUUM, EXPLAIN, pg stat activity, Autovacuum, ALTER DATABASE, PostgreSQL statistics collector, Shared buffers, EXPLAIN (PostgreSQL), EXPLAIN ANALYZE, Bitmap scan, EXPLAIN VERBOSE, EXPLAIN VERBOSE (PostgresSQL), WAL, ALTER USER, CREATE ROLE, CREATE USER, \du, show users, \l, The Statistics Collector, pganalyze, cron.schedule, Master, pg_tables, PostgreSQL replication, CREATE, SET, TOAST, PgBouncer, Restore DB, Index, meta-commands, Table, foreign table, Schema, Sequence, Views, materialized view, Table Partitioning, monitoring, PostgreSQL System Administration Functions, PostgreSQL extension, privileges, logging, PGTune, PostgreSQL parameter tunning, PostgreSQL modules, pgbench, PostgreSQL users, catalogs

https://stackoverflow.com/questions/18580066/how-to-allow-remote-access-to-postgresql-database