Authentification problems with local connections

Поиск
Список
Период
Сортировка
От Graham Vickrage
Тема Authentification problems with local connections
Дата
Msg-id NDBBJABDILOPAOOMFJHOAENDCAAA.graham@digitalplanit.com
обсуждение исходный текст
Ответы Re: [ADMIN] Authentification problems with local connections
Список pgsql-admin
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


В списке pgsql-admin по дате отправления:

Предыдущее
От: Fabio Benevenuti
Дата:
Сообщение: Identifier limits
Следующее
От: Andre Antonio Parmeggiani
Дата:
Сообщение: 'user' sql reserved word ?