pg_hba.conf - Allow All Connections Over TCP/IP Networks

Wang, Mary Y wrote:

Hi,

I'd like to allow all connections over TCP/IP networks. So could I just add the following line to the pg_hba.conf in the $PGDATA directory?
"host all * trust"

The database server is located inside a firewall.

host all all 0.0.0.0/0 trust

or

host all all 192.168.0.0/24 trust

(or whatever your subnet is in CIDR style network/size notation)

of course, you also need

listen_address = '*'

in your postgresql.conf so the server is listening on all network interfaces

Personally, I still prefer to use md5 rather than trust and use password
authentication for LAN connections.