Access Configuration

Access authentication for the Halo database is configured by modifying the pg_hba.conf file in the data directory.

vi $PGDATA/pg_hba.conf

Add the following:

# TYPE    DATABASE    USER    ADDRESS          METHOD
host      all         all     0/0              md5
host      test        test    10.10.10.17/24   md5

The first line allows any user from any IP to connect using an MD5-encrypted password; the second line allows only the user test at address 10.10.10.17/24 to connect to the test database. To restrict to a specific network segment, replace ADDRESS with the corresponding subnet.