passwords in pg_shadow - Mailing list pgsql-general

From Terry Yapt
Subject passwords in pg_shadow
Date
Msg-id 1038861171.81bcfe0pgsql@technovell.com
Whole thread Raw
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: "P.J. \"Josh\" Rovero"
Date:
Subject: Re: timing queries?
Next
From: Terry Yapt
Date:
Subject: Public Schema.