Re: Login Failures After Upgrade

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Greg Kelley" <gkelley(at)britannicaviation(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Login Failures After Upgrade
Date: 2002-12-16 15:23:09
Message-ID: 5528.1040052189@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"Greg Kelley" <gkelley(at)britannicaviation(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message scott.marlowe 2002-12-16 16:23:29 Re: Total crash of my db-server
Previous Message Tom Lane 2002-12-16 15:11:20 Re: Total crash of my db-server