ALTER USER abc PASSWORD - what's going on ???

From: Marcin Krawczyk <jankes(dot)mk(at)gmail(dot)com>
To: "pgsql-sql(at)postgresql(dot)org" <pgsql-sql(at)postgresql(dot)org>
Subject: ALTER USER abc PASSWORD - what's going on ???
Date: 2013-04-18 10:59:49
Message-ID: CABnqL3291P-u2z-RQLDA=8ttagxXwNWH2CfTzZYehACK5-3eDQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Hi,

I can't change the pass for my user. When I invoke ALTER USER abc PASSWORD
newpassword
it changes ok but then I can't login with my newpassword...

It says authetication failed.
My pg_hba.conf has md5 entry for the ip I connect from. It used to work ok,
but I accidentaly changed the password for the user abc from pgAdmin and
now I can't change it back to what it was.

What's going on ?

regards
mk

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message SEKA Bruno-Emmanuel 2013-04-18 11:19:28 Re: ALTER USER abc PASSWORD - what's going on ???
Previous Message basti 2013-04-18 08:34:49 Fwd: copy from csv, variable filename within a function