Search code examples
postgresqlconfigurationipconfig

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

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

Solution

  • The following example pg_hba.conf allows local and a specified IP to have privileged login, but rejects 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