Configure PostgreSQL to work for only LOCALHOST or specified ip + port

postgresql configuration ipconfig
Ankur Loriya picture Ankur Loriya · Aug 1, 2012 · Viewed 41.2k times · Source

I want to configure PostgreSQL to accept connections only from a specified IP. It should not accept requests from any other IP.

Answer

francs picture francs · Aug 1, 2012

The following pg_hba.conf allows local and specified Ip have privilege login， but reject others。

# TYPE  DATABASE        USER            ADDRESS                 METHOD
local   all             all                                     trust
host    testdb          testuser      192.168.1.1/32             md5
host    all             all           0.0.0.0/0                 reject

Related questions

Where are my postgres *.conf files?

I have recently reinstalled postgresql 8.3 on my Ubuntu 8.04 after update. Used EnterpriseDB package. I can connect to the database locally, I see system DB postgres but I can't configure it because I can't find config files. Searched through entire hard …

Read More
How to configure postgresql for the first time?

I have just installed postgresql and I specified password x during installation. When I try to do createdb and specify any password I get the message: createdb: could not connect to database postgres: FATAL: password authentication failed for user Same …

Read More
pgadmin4 : postgresql application server could not be contacted.

I have installed PostgreSQL 9.6.2 on my Windows 8.1. But the pgadmin4 is not able to contact the local server. I have tried several solutions suggested here in stackoverflow, tried to uninstall and reinstall PostgreSQL 9.6.2 , tried to modify the config.py, config_…

Read More