Re: [SQL] ALTER USER abc PASSWORD - what's going on ???

2013-04-19 Thread Marcin Krawczyk
Ok, thank you. pozdrowienia mk 2013/4/18 Guillaume Lelarge guilla...@lelarge.info On Thu, 2013-04-18 at 13:21 +0200, Marcin Krawczyk 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

[SQL] ALTER USER abc PASSWORD - what's going on ???

2013-04-18 Thread Marcin Krawczyk
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

Re: [SQL] ALTER USER abc PASSWORD - what's going on ???

2013-04-18 Thread SEKA Bruno-Emmanuel
Which version of postgresql.? Sent from my Samsung Galaxy Note. On 18 Apr 2013 11:01, Marcin Krawczyk jankes...@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

Re: [SQL] ALTER USER abc PASSWORD - what's going on ???

2013-04-18 Thread Marcin Krawczyk
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.

Re: [SQL] ALTER USER abc PASSWORD - what's going on ???

2013-04-18 Thread SEKA Bruno-Emmanuel
OK then.. Sent from my Samsung Galaxy Note. On 18 Apr 2013 11:22, Marcin Krawczyk jankes...@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

Re: [SQL] ALTER USER abc PASSWORD - what's going on ???

2013-04-18 Thread Guillaume Lelarge
On Thu, 2013-04-18 at 13:21 +0200, Marcin Krawczyk 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... FYI, this pgAdmin bug has been fixed. The fix will be available in the