Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1ixWEr-0002Wj-QV for pgsql-bugs@arkaria.postgresql.org; Fri, 31 Jan 2020 13:21:38 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1ixWEq-0004oh-7G for pgsql-bugs@arkaria.postgresql.org; Fri, 31 Jan 2020 13:21:36 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1ixWEo-0004oY-Vj for pgsql-bugs@lists.postgresql.org; Fri, 31 Jan 2020 13:21:36 +0000 Received: from wout2-smtp.messagingengine.com ([64.147.123.25]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1ixWEl-0004TQ-G4 for pgsql-bugs@lists.postgresql.org; Fri, 31 Jan 2020 13:21:33 +0000 Received: from compute7.internal (compute7.nyi.internal [10.202.2.47]) by mailout.west.internal (Postfix) with ESMTP id A99E67A2; Fri, 31 Jan 2020 08:21:29 -0500 (EST) Received: from mailfrontend1 ([10.202.2.162]) by compute7.internal (MEProxy); Fri, 31 Jan 2020 08:21:29 -0500 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=content-transfer-encoding:content-type :date:from:in-reply-to:message-id:mime-version:references :subject:to:x-me-proxy:x-me-proxy:x-me-sender:x-me-sender :x-sasl-enc; s=fm1; bh=o7msYU5mfC9umGFvbCfe6oHuOK8q314sSzYGTji3l nw=; b=PkG7OLXcxeXanImfXnhx2o5SCPj1WEdy1rOw1ud48DaEJT/j1OceFWbdK tYlsYfOse/pSMajnD2GiV5fypb6V3g9PNas/RwE0doihFg6idhhO+gjAwkrU3M07 1GS3xDn6dExba8XS/DpLet/jzLwvJDaO+VF3uVP2s3Ilol5EQK1jcj4rCaRbShLT uDBB820HZmZb4wxrIJEouolsodY4iP1+rPISUw43xtIR7Lg6DH2j2vQ16UwC+yIC XDP2jPodY52c7uR5U/x2KGEH8C8TLjdLA4VCCQ9JKMjB3HNQg/r1XAoth+utN2Np mOrXrZteay7YGTCghqM1uPtz4Q4Gg== X-ME-Sender: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgedugedrgedtgdegjecutefuodetggdotefrodftvf curfhrohhfihhlvgemucfhrghsthforghilhdpqfgfvfdpuffrtefokffrpgfnqfghnecu uegrihhlohhuthemuceftddtnecunecujfgurhepuffvfhfhohfkffgfgggjtgfgsehtje ertddtfeejnecuhfhrohhmpefrvghtvghrucfgihhsvghnthhrrghuthcuoehpvghtvghr rdgvihhsvghnthhrrghuthesvdhnughquhgrughrrghnthdrtghomheqnecuffhomhgrih hnpedvnhguqhhurggurhgrnhhtrdgtohhmnecukfhppeelfedrvdegvddrvdehhedruddu vdenucevlhhushhtvghrufhiiigvpedtnecurfgrrhgrmhepmhgrihhlfhhrohhmpehpvg htvghrrdgvihhsvghnthhrrghuthesvdhnughquhgrughrrghnthdrtghomh X-ME-Proxy: Received: from april.pezone.net (p5df2ff70.dip0.t-ipconnect.de [93.242.255.112]) by mail.messagingengine.com (Postfix) with ESMTPA id A34053280060; Fri, 31 Jan 2020 08:21:28 -0500 (EST) Subject: Re: BUG #16239: It is not possible to upgrade the password from md5 to SCRAM To: valeh.agayev@gmail.com, pgsql-bugs@lists.postgresql.org References: <16239-be97116acd827c0a@postgresql.org> From: Peter Eisentraut Organization: 2ndQuadrant Message-ID: <5ddbcee9-a088-323d-4840-6d817266ddd4@2ndquadrant.com> Date: Fri, 31 Jan 2020 14:21:27 +0100 User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.14; rv:52.0) Gecko/20100101 Thunderbird/52.9.1 MIME-Version: 1.0 In-Reply-To: <16239-be97116acd827c0a@postgresql.org> Content-Type: text/plain; charset=utf-8; format=flowed Content-Language: en-US Content-Transfer-Encoding: 7bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk On 2020-01-31 12:44, PG Bug reporting form wrote: > It is not possible to upgrade the password from md5 to SCRAM with \password > command, but with alter command is possible. It works for me. Are you perhaps using an older version of psql or libpq? -- Peter Eisentraut http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services