passwords in pg_shadow (duplicate). - Mailing list pgsql-general

From Terry Yapt
Subject passwords in pg_shadow (duplicate).
Date
Msg-id 1039029548.81be2f0pgsql@technovell.com
Whole thread Raw
Responses Re: passwords in pg_shadow (duplicate).  (Bruce Momjian <pgman@candle.pha.pa.us>)
List 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 by date:

Previous
From: Joseph Shraibman
Date:
Subject: Re: performance tuning
Next
From: SZUCS Gábor
Date:
Subject: Re: Efficient Boolean Storage