Received: from malur.postgresql.org ([217.196.149.56])
	by arkaria.postgresql.org with esmtp (Exim 4.72) (envelope-from
	<pgsql-sql-owner+M37249=pgsql+2Dsql=arkaria.postgresql.org@postgresql.org>)
	id 1USmZc-0007rx-7B
	for pgsql-sql@arkaria.postgresql.org; Thu, 18 Apr 2013 11:00:16 +0000
Received: from localhost ([127.0.0.1] helo=postgresql.org)
	by malur.postgresql.org with smtp (Exim 4.72) (envelope-from
	<pgsql-sql-owner+M37249=pgsql+2Dsql=arkaria.postgresql.org@postgresql.org>)
	id 1USmZb-0006y3-Ef
	for pgsql-sql@arkaria.postgresql.org; Thu, 18 Apr 2013 11:00:15 +0000
Received: from makus.postgresql.org ([2001:4800:7903:4::125])
	by malur.postgresql.org with esmtp (Exim 4.72)
	(envelope-from <jankes.mk@gmail.com>) id 1USmZa-0006xx-CZ
	for pgsql-sql@postgresql.org; Thu, 18 Apr 2013 11:00:14 +0000
Received: from mail-wi0-x236.google.com ([2a00:1450:400c:c05::236])
	by makus.postgresql.org with esmtp (Exim 4.72)
	(envelope-from <jankes.mk@gmail.com>) id 1USmZX-0004HI-Qz
	for pgsql-sql@postgresql.org; Thu, 18 Apr 2013 11:00:13 +0000
Received: by mail-wi0-f182.google.com with SMTP id m6so2747404wiv.3
	for <pgsql-sql@postgresql.org>; Thu, 18 Apr 2013 04:00:09 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113;
	h=x-received:mime-version:from:date:message-id:subject:to
	:content-type; bh=SbJmqLCyllrq28DqxZhywU53YPPU3trxzfSnZD/yO/M=;
	b=tvwmOPzHejMJbcOZtARu0sgisksKjQ6m6VqLfm9qh93Cxapc31dyA/LKhQfOCIaGmh
	R4LEnNoOqcuAgIomWCUr4i7/gnqb3N1QK6XkHvyDKorXFp9+EK43atpfvt4n5nSxfq/n
	zAcorCr1CBVVxQCAKpyHVOcdmFef5aMYKFwYaHkNy+11/RJLAqz+C/4wjtyRh+Lw3wtv
	j//OFt6IyHy3lT/FHqyeR5agJB1lERoU3j/GCKmUBgZ3V+o+cyXE8MiNAzsR0o8WG1HE
	B2cfZ75+wEXKPULHNcM0C5IC0UL2nh0DJmtx86jIx8MH18IBechrYXO7Q79PSdq098vn
	qD9A==
X-Received: by 10.194.219.162 with SMTP id pp2mr17725540wjc.27.1366282809696;
	Thu, 18 Apr 2013 04:00:09 -0700 (PDT)
MIME-Version: 1.0
Received: by 10.216.74.201 with HTTP; Thu, 18 Apr 2013 03:59:49 -0700 (PDT)
From: Marcin Krawczyk <jankes.mk@gmail.com>
Date: Thu, 18 Apr 2013 12:59:49 +0200
Message-ID: 
 <CABnqL3291P-u2z-RQLDA=8ttagxXwNWH2CfTzZYehACK5-3eDQ@mail.gmail.com>
Subject: ALTER USER abc PASSWORD - what's going on ???
To: "pgsql-sql@postgresql.org" <pgsql-sql@postgresql.org>
Content-Type: multipart/alternative; boundary=001a11c1b9a888e80804daa081f6
X-Pg-Spam-Score: -2.0 (--)
List-Archive: <http://archives.postgresql.org/pgsql-sql>
List-Help: <mailto:majordomo@postgresql.org?body=help>
List-ID: <pgsql-sql.postgresql.org>
List-Owner: <mailto:pgsql-sql-owner@postgresql.org>
List-Post: <mailto:pgsql-sql@postgresql.org>
List-Subscribe: <mailto:majordomo@postgresql.org?body=sub%20pgsql-sql>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-sql>
X-Mailing-List: pgsql-sql
Precedence: bulk
Sender: pgsql-sql-owner@postgresql.org

--001a11c1b9a888e80804daa081f6
Content-Type: text/plain; charset=ISO-8859-1

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

--001a11c1b9a888e80804daa081f6
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr">Hi,<div><br></div><div style>I can&#39;t change the pass f=
or my user. When I invoke=A0ALTER USER abc PASSWORD newpassword=A0</div><di=
v style>it changes ok but then I can&#39;t login with my newpassword...</di=
v><div style>

<br></div><div style>It says authetication failed.=A0</div><div style>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&#39;t change it back to what it was.=A0</div>

<div style><br></div><div style>What&#39;s going on ?</div><div><br clear=
=3D"all"><div>regards<br>mk</div>
</div></div>

--001a11c1b9a888e80804daa081f6--