Postgres Pro
Downloads
Home   >   mailing lists

Re: Login Failures After Upgrade - Mailing list pgsql-general

From Tom Lane
Subject Re: Login Failures After Upgrade
Date
Msg-id 5528.1040052189@sss.pgh.pa.us
Whole thread Raw
In response to Login Failures After Upgrade  ("Greg Kelley" <gkelley@britannicaviation.com>)
List pgsql-general
Tree view 
"Greg Kelley" <gkelley@britannicaviation.com> writes:
> Just upgraded from 7.1.3 to 7.3 (using RPMs) and now none of the assigned
> users can login as before. Tried resetting passwords with 'ALTER USER XXX
> WITH PASSWORD='pwd' and it didn't help. pg_hba.conf listing follows:

Try setting the method to 'md5' not 'password'.

            regards, tom lane

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Total crash of my db-server
Next
From: Robert Treat
Date:
Subject: working around setQuerySnapshot limitations in functions