Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1qIwij-0001OG-F4 for pgsql-general@arkaria.postgresql.org; Mon, 10 Jul 2023 19:38:53 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1qIwii-00056j-6c for pgsql-general@arkaria.postgresql.org; Mon, 10 Jul 2023 19:38:52 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1qIwih-00056a-SI for pgsql-general@lists.postgresql.org; Mon, 10 Jul 2023 19:38:51 +0000 Received: from wout4-smtp.messagingengine.com ([64.147.123.20]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qIwie-003Ku8-Vi for pgsql-general@lists.postgresql.org; Mon, 10 Jul 2023 19:38:51 +0000 Received: from compute3.internal (compute3.nyi.internal [10.202.2.43]) by mailout.west.internal (Postfix) with ESMTP id E28EB3200973; Mon, 10 Jul 2023 15:38:46 -0400 (EDT) Received: from mailfrontend1 ([10.202.2.162]) by compute3.internal (MEProxy); Mon, 10 Jul 2023 15:38:47 -0400 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=aklaver.com; h= cc:content-transfer-encoding:content-type:content-type:date:date :from:from:in-reply-to:in-reply-to:message-id:mime-version :references:reply-to:sender:subject:subject:to:to; s=fm1; t= 1689017926; x=1689104326; bh=VQU+BUNIY94NOLVTzjPLB184wYi3U+sbivr gpaBIllA=; b=cRuA3PqU4chC8fud2UWtw1tZzanwiddoqKgV42tiqWVvujepUds nIK9y2g01fMlpnDY7UZYpI0jKKWO38DKzPgn1CAzlh3U99+x8vvA/1a1zsyQ8job HAqA/T71n+GxVAFwqY8vqX8MW6x0ZCb8IDN/9B4VB363hFdfUBw1ZNnDvSZeZYfx wJ7AatX7a9jNjKJBoAib+NeyOh1E5/DxRle+6/mK/ltps42TEfHRJpyqgjtxLPlo G7RThLqglVMqA1Pw3YvfzrH4dHjtMYJG1QYxMElly90rOmHp0u2sSMEt8O3UubVB 33q8wFfzQycCmtSbE6k/l3U6yG0NkdQ4kMQ== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:content-transfer-encoding:content-type :content-type:date:date:feedback-id:feedback-id:from:from :in-reply-to:in-reply-to:message-id:mime-version:references :reply-to:sender:subject:subject:to:to:x-me-proxy:x-me-proxy :x-me-sender:x-me-sender:x-sasl-enc; s=fm2; t=1689017926; x= 1689104326; bh=VQU+BUNIY94NOLVTzjPLB184wYi3U+sbivrgpaBIllA=; b=P wTacxzJYX1EcArTdDMkb97/9iWUsZC6vWnn4cxt0/zvjVHWuFmG9KTNZriwprfsi KqIo/jIvTtpjAmPdSrrxwV7aZAmksHbFzjdyK/W64Da6wh8nDEgQkF1Mwo0+Opto LKsubTFgCDWtZIt4tSh3MRGTxEFIWDkTE7H9ZEiRzg23XquhpGX0A9fjiaEQt/2X oiZ/+uIBp+VhNHfn4Gp4oPfULWy2K74NEBi2M3U8nXsJIXaiuIOBXm41G11RyZ3M XLqm3V4d/Iy0U9hcMnnt0hwx5an4SEI9WN1FUNFUxJfHR0Xsit5WTRs+E+w93au1 DtITZbecsX73fF4jSm40w== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgedviedrvdekgddufeduucetufdoteggodetrfdotf fvucfrrhhofhhilhgvmecuhfgrshhtofgrihhlpdfqfgfvpdfurfetoffkrfgpnffqhgen uceurghilhhouhhtmecufedttdenucesvcftvggtihhpihgvnhhtshculddquddttddmne cujfgurhepkfffgggfuffvfhfhjggtgfesthejredttdefjeenucfhrhhomheptegurhhi rghnucfmlhgrvhgvrhcuoegrughrihgrnhdrkhhlrghvvghrsegrkhhlrghvvghrrdgtoh hmqeenucggtffrrghtthgvrhhnpeevvdekiefhudfhhfdtkeelgeffudeigfetjeegfffg hfetfeelledugfelleegveenucevlhhushhtvghrufhiiigvpedtnecurfgrrhgrmhepmh grihhlfhhrohhmpegrughrihgrnhdrkhhlrghvvghrsegrkhhlrghvvghrrdgtohhm X-ME-Proxy: Feedback-ID: i76984098:Fastmail Received: by mail.messagingengine.com (Postfix) with ESMTPA; Mon, 10 Jul 2023 15:38:45 -0400 (EDT) Message-ID: Date: Mon, 10 Jul 2023 12:38:45 -0700 MIME-Version: 1.0 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:102.0) Gecko/20100101 Thunderbird/102.13.0 Subject: Re: Need Help On Upgrade Content-Language: en-US To: Johnathan Tiamoh , pgsql-general@lists.postgresql.org References: From: Adrian Klaver In-Reply-To: Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On 7/10/23 11:15, Johnathan Tiamoh wrote: > Hello, > > I upgraded from postgresql 9.5 to 14.8. After the upgrade users were not > able to connect due to password hash. > > The password encryption was on scram-sha-256. The password hash was on > md5. in the pg_hba.conf file the authentication method was md5. I do not > know why users could not connect because as per postgresql > documentation, that should work. > 1) You are going to have to be more specific about where and what the settings are or where for both Postgres versions and the *.conf files. So: Postgres 9.5 postgresql.conf password_encryption = ? pg_hba.conf Provide the relevant lines Postgres 14.8 postgresql.conf password_encryption = ? pg_hba.conf Provide the relevant lines 2) Provide the error messages received when trying to connect. > I have previously done a similar upgrade and did not face similar issues. > > > Kind regards > Johnathan Tiamoh -- Adrian Klaver adrian.klaver@aklaver.com