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 1qIzV1-00019c-7R for pgsql-general@arkaria.postgresql.org; Mon, 10 Jul 2023 22:36:55 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1qIzV0-0004pR-3Y for pgsql-general@arkaria.postgresql.org; Mon, 10 Jul 2023 22:36:54 +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 1qIzUz-0004pI-8X for pgsql-general@lists.postgresql.org; Mon, 10 Jul 2023 22:36:53 +0000 Received: from wout3-smtp.messagingengine.com ([64.147.123.19]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qIzUv-003MMh-AG for pgsql-general@lists.postgresql.org; Mon, 10 Jul 2023 22:36:52 +0000 Received: from compute6.internal (compute6.nyi.internal [10.202.2.47]) by mailout.west.internal (Postfix) with ESMTP id 4BAAF32003CE; Mon, 10 Jul 2023 18:36:47 -0400 (EDT) Received: from mailfrontend1 ([10.202.2.162]) by compute6.internal (MEProxy); Mon, 10 Jul 2023 18:36:47 -0400 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=aklaver.com; h= cc: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= 1689028606; x=1689115006; bh=GIaj8Bt8pbswMDdrKjJ88SGnDiZpWCE3Kp4 0FQww3I0=; b=HbKXY/87P0UafcdCwRuTYDqhYw9BCCFBUfuZGav6EM2KPHy+j0M 3mk+QMb5/Zq3TZsG21wx8s8BMnW9oUzHYy9Ax7IfCa79VoYWi5hxVX26SA/lxyB7 x5S4hdA11OYbA9ufCxP9tUnf+lblIHzNu3XzWe++bGtbf55WZqsfycS/+jIwx6Pf pwUn2t/0mf2tor6bXGtPZ1fBBCrpqQzeiU4FHSf7oafCQN64UfERDhMvVpOAyjCI NfqwcG3u9p/LZ9fHaZPxBWzZwJTXO4Xxe2BoBDA4t2yKK91Wxej/2Peojcxe26/B 41wo+ZLTwFOn11wc8d/5aGgaDhDfoJJNZPg== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc: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= 1689028606; x=1689115006; bh=GIaj8Bt8pbswMDdrKjJ88SGnDiZpWCE3Kp4 0FQww3I0=; b=QH3aZTVBj7ODqDu15VpE/RAJTUqGN75FF+hdd3HY267sHyOQr+h 3AngcWBMKOc3NMQqNMWJ+hFAWVp8ut4KnkqR9/nkj5qTGk22kr4GKJn1k7x+AGMY evEwKmIqT15MYkOFMQKMo+Fi4vmdvF/DcWF2Oc/jFevuCFEZLq866eVTyjBoC4ga lUPmGqbaZu02d19Gu7dNJUOP+G6G59CxCEEj7WhBysFft5gW60SnfRtfbhlWwzgX a8pMABTzxZ4DSFib0HSTT0MZiDTialvHTo7MTRPT+bMTyhoKolWhbQjPwSDVGvoq 62VyfY4GN89ag5ZcnitHzN+ZErZUN7iqFlA== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgedviedrvdelgddufecutefuodetggdotefrodftvf curfhrohhfihhlvgemucfhrghsthforghilhdpqfgfvfdpuffrtefokffrpgfnqfghnecu uegrihhlohhuthemuceftddtnecusecvtfgvtghiphhivghnthhsucdlqddutddtmdenuc fjughrpefkffggfgfuvfevfhfhjggtgfesthekredttdefjeenucfhrhhomheptegurhhi rghnucfmlhgrvhgvrhcuoegrughrihgrnhdrkhhlrghvvghrsegrkhhlrghvvghrrdgtoh hmqeenucggtffrrghtthgvrhhnpeetueehledttdejfeehkeelieefveevgfdvleehvdfg tdeihffffedvvddtieeigeenucffohhmrghinheptddrtddrtddrtdenucevlhhushhtvg hrufhiiigvpedtnecurfgrrhgrmhepmhgrihhlfhhrohhmpegrughrihgrnhdrkhhlrghv vghrsegrkhhlrghvvghrrdgtohhm X-ME-Proxy: Feedback-ID: i76984098:Fastmail Received: by mail.messagingengine.com (Postfix) with ESMTPA; Mon, 10 Jul 2023 18:36:46 -0400 (EDT) Message-ID: <26dd72fe-25f7-fe8d-b8f6-8ebfee651dbb@aklaver.com> Date: Mon, 10 Jul 2023 15:36: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 To: Johnathan Tiamoh Cc: pgsql-general@lists.postgresql.org References: Content-Language: en-US From: Adrian Klaver In-Reply-To: Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 8bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On 7/10/23 13:20, Johnathan Tiamoh wrote: > >> Ok Adrian, >> >> Postgres 9.5 >> >>      postgresql.conf >> >>         password_encryption  = ?  md5  ====> wish is the default for 9.5 >> >>      pg_hba.conf    -----------------> md5 >> >>          Provide the relevant lines >> >> Postgres 14.8 >> >>      postgresql.conf >> >>         password_encryption  = ?   scram-sha-256  ====> which is the >> default for 14.8 >> >>      pg_hba.conf      md5 > > You have not answered: > > 2) Provide the error messages received when trying to connect. > [XXXXXXXXXXXXXXXXXXXXXXX| APPNAME=[unknown]| DB=proftpd| USER=proftpd| > PID=9053| 2| authentication| PGE-28P01: DETAIL:  Connection matched > pg_hba.conf line 113: "host    all         all 0.0.0.0/0 >              md5" > The above is not showing any actual error. There should a part that says what failed when connecting. -- Adrian Klaver adrian.klaver@aklaver.com