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 CALgD7jACQafN9pd3sKSzg0W5Zj8XYOw4w4xYqdnq9VoNOwr96A@mail.gmail.com
Whole thread Raw
In response to Re: ALTER USER abc PASSWORD - what's going on ???  (Marcin Krawczyk <jankes.mk@gmail.com>)
List pgsql-sql
Tree view

OK then..

Sent from my Samsung Galaxy Note.

On 18 Apr 2013 11:22, "Marcin Krawczyk" <jankes.mk@gmail.com> wrote:
I figured it out... when changing role from pgAdmin, it has a default VALID UNTIL 1970 set and after confirming changes it just made my abc user account invalid... but upon connecting postgres complains about pass authetication, maybe the message should be changed ?

It's 9.1 by the way.

pozdrowienia
mk


2013/4/18 Marcin Krawczyk <jankes.mk@gmail.com>
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: Re: ALTER USER abc PASSWORD - what's going on ???
Next
From: Jasen Betts
Date:
Subject: Re: Peer-review requested of soft-delete scheme