Postgres Pro
Downloads
Home   >   mailing lists

ALTER USER abc PASSWORD - what's going on ??? - Mailing list pgsql-sql

From Marcin Krawczyk
Subject ALTER USER abc PASSWORD - what's going on ???
Date
Msg-id CABnqL3291P-u2z-RQLDA=8ttagxXwNWH2CfTzZYehACK5-3eDQ@mail.gmail.com
Whole thread Raw
Responses Re: ALTER USER abc PASSWORD - what's going on ???  (SEKA Bruno-Emmanuel <master.ematris@gmail.com>)
Re: ALTER USER abc PASSWORD - what's going on ???  (Marcin Krawczyk <jankes.mk@gmail.com>)
List pgsql-sql
Tree view
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

pgsql-sql by date:

Previous
From: basti
Date:
Subject: Fwd: copy from csv, variable filename within a function
Next
From: SEKA Bruno-Emmanuel
Date:
Subject: Re: ALTER USER abc PASSWORD - what's going on ???