passwords in pg_shadow (duplicate).

Поиск
Список
Период
Сортировка
От Terry Yapt
Тема passwords in pg_shadow (duplicate).
Дата
Msg-id 1039029548.81be2f0pgsql@technovell.com
обсуждение исходный текст
Ответы Re: passwords in pg_shadow (duplicate).  (Bruce Momjian <pgman@candle.pha.pa.us>)
Список pgsql-general
==========================
Hello all,

I have "migrate" a test server from 7.2.x to 7.3. All was ok (without regression tests yet), but I have a problem to
connectto the server from all my client-odbc applications. 

I have a:
"FATAL: Password authentication failed for user xxxxxx"

I have SELECT * from pg_shadow and I noticed about a difference with my 7.2 installation:

7.2 -> Password is text plain.
7.3 -> Password is md5 crypt or something similar.

If I change my md5 password from its encryption to plain text, I can connect fine.

It is the normal behavior or not ? The users and their passwords come from a pg_dumpall.

Thanks a lot.



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

Предыдущее
От: Joseph Shraibman
Дата:
Сообщение: Re: performance tuning
Следующее
От: SZUCS Gábor
Дата:
Сообщение: Re: Efficient Boolean Storage