I've got a PostgreSQL data base that I'd like to configure to accept all incoming connections regardless of the source IP address. How can this be configured in the pg_hba.conf file? I'm using postgreSQL version 8.4.
This question is related to
postgresql
0.0.0.0/0 for all IPv4 addresses
::0/0 for all IPv6 addresses
all to match any IP address
samehost to match any of the server's own IP addresses
samenet to match any address in any subnet that the server is directly connected to.
e.g.
host all all 0.0.0.0/0 md5
Add this line to pg_hba.conf of postgres folder
host all all all trust
"trust" allows all users to connect without any password.
Addition to above great answers, if you want some range of IPs to be authorized, you could edit /var/lib/pgsql/{VERSION}/data file and put something like
host all all 172.0.0.0/8 trust
It will accept incoming connections from any host of the above range. Source: http://www.linuxtopia.org/online_books/database_guides/Practical_PostgreSQL_database/c15679_002.htm
Configuration all files with postgres 12 on centos:
step 1: search and edit file
sudo vi /var/lib/pgsql/12/data/pg_hba.conf
press "i" and at line IPv4 change
host all all 0.0.0.0/0 md5
step 2: search and edit file postgresql.conf
sudo vi /var/lib/pgsql/12/data/postgresql.conf
add last line: listen_addresses = '*' :wq! (save file) - step 3: restart
systemctl restart postgresql-12.service
Source: Stackoverflow.com