I am trying to restrict access to my databases by adding the following lines
to the pg_hba.conf file: -
local dpstatistic password
local details password
host all 127.0.0.1 255.255.255.255 password
When I now try to access the database using:
[postgres@10 bin]$ psql -u dpstatistics
username: dpstats
password: dpstats
I get the following message:
"No pg_hba.conf entry for host localhost, user dpsuper, database
dpstatistics"
despite the fact that the user dpstats appears in the pg_shadow table: -
usename |usesysid|usecreatedb|usetrace|usesuper|usecatupd|passwd
|valuntil
----------+--------+-----------+--------+--------+---------+----------+-----
---
dpstats | 503|t |t |t |t |dpstats |
Is there an entry missing that I have over-looked, any help greatly
appreciated
Cheers
Graham
************