pg_hba.conf / password, crypt,md5

Поиск
Список
Период
Сортировка
Искать
От
Marc Ende
Тема
pg_hba.conf / password, crypt,md5
Дата
Msg-id
17m12t-0Sp6qeC@fmrl01.sul.t-online.com
Список
Дерево обсуждения
pg_hba.conf / password, crypt,md5 Marc Ende <me@marc-ende.de>
Re: pg_hba.conf / password, crypt,md5 Tom Lane <tgl@sss.pgh.pa.us>
Re: pg_hba.conf / password, crypt,md5 "Nick Fankhauser" <nickf@ontko.com>
Re: pg_hba.conf / password, crypt,md5 "Chad R. Larson" <chad@eldocomp.com>
Hi there,

I think it might be a well known problem, but I haven't found a solution.

I've used a postgres 7.0 before. Now I need to upgrade to an actual version (7.2.2).
In the "old" pg_hba.conf I had the both lines in the pg_hba.conf:
local	all					password
host	all	127.0.0.1 255.255.255.255 password

now I've tried the same but now I can logon as a valid user with an invalid password.
Postgres now allows to login with any valid username without specifying a password.

After that I'm trying to use other authorization types but it didn't gave me the
security back :(

Thanks for any hint.

Yours sincerly

Marc Ende
--

Marc Ende
consulting and development
http://www.marc-ende.de/                    me@marc-ende.de
В списке pgsql-admin по дате отправления
От: Randall Perry
Дата:
От: Tom Lane
Дата:
FAQ