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

Поиск
Список
Период
Сортировка
От Marcin Krawczyk
Тема ALTER USER abc PASSWORD - what's going on ???
Дата
Msg-id CABnqL3291P-u2z-RQLDA=8ttagxXwNWH2CfTzZYehACK5-3eDQ@mail.gmail.com
обсуждение исходный текст
Ответы 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>)
Список 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

В списке pgsql-sql по дате отправления:

Предыдущее
От: basti
Дата:
Сообщение: Fwd: copy from csv, variable filename within a function
Следующее
От: SEKA Bruno-Emmanuel
Дата:
Сообщение: Re: ALTER USER abc PASSWORD - what's going on ???