Re: passwd / pg_hba.conf

Patrick Welche wrote:
> # password: Authentication is done by matching a password supplied
> # in clear by the host. If no AUTH_ARGUMENT is used, the
> # password is compared with the user's entry in the
> # pg_shadow table.
>
> It seems to me that this doesn't work for encrypted passwords stored in
> pg_shadow? The crypt: entry specifically mentions not storing encrypted
> passwords.. Just checking here, as it's a windoze box connecting with ODBC
> that has the problem, all the unix boxen are happy with md5 and encrypted
> passwords, so there could be many other causes for it to be unhappy..

Only newer 7.2 ODBC drivers have code to handle MD5 passwords, and ODBC
never handled crypt passwords, so this may be your problem.

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026