passwords in pg_shadow

Поиск
Список
Период
Сортировка
От Terry Yapt
Тема passwords in pg_shadow
Дата
Msg-id 1038861171.81bcfe0pgsql@technovell.com
обсуждение исходный текст
Список 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 по дате отправления:

Предыдущее
От: "P.J. \"Josh\" Rovero"
Дата:
Сообщение: Re: timing queries?
Следующее
От: Terry Yapt
Дата:
Сообщение: Public Schema.