Postgres Pro
Downloads
Home   >   mailing lists

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

From SEKA Bruno-Emmanuel
Subject Re: ALTER USER abc PASSWORD - what's going on ???
Date
Msg-id CALgD7jBX7BRC_d5QZjSmXn7RE2iHQN=JYORqv+onsSy97qtnUQ@mail.gmail.com
Whole thread Raw
In response to ALTER USER abc PASSWORD - what's going on ???  (Marcin Krawczyk <jankes.mk@gmail.com>)
List pgsql-sql
Tree view

Which version of postgresql.?

Sent from my Samsung Galaxy Note.

On 18 Apr 2013 11:01, "Marcin Krawczyk" <jankes.mk@gmail.com> wrote:
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: Marcin Krawczyk
Date:
Subject: ALTER USER abc PASSWORD - what's going on ???
Next
From: Marcin Krawczyk
Date:
Subject: Re: ALTER USER abc PASSWORD - what's going on ???