How to configure PostgreSQL to accept all incoming connections

Question

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

User · Answer

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

User · Answer

Add this line to pg hba conf of postgres folder  host    all    all    all    trust    trust  allows all users to connect without any password

User · Answer

Just use 0 0 0 0 0  host    all             all             0 0 0 0 0            md5  Make sure the listen addresses in postgresql conf  or ALTER SYSTEM SET  allows incoming connections on all available IP interfaces  listen addresses        After the changes you have to reload the configuration  One way to do this is execute this SELECT as a superuser  SELECT pg reload conf     Note  to change listen addresses  a reload is not enough  and you have to restart the server

User · Answer

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

User · Answer

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

[postgresql] How to configure PostgreSQL to accept all incoming connections

Examples related to postgresql