Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1uZWYX-004lGX-F4 for pgsql-general@arkaria.postgresql.org; Wed, 09 Jul 2025 15:17:57 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1uZWYV-000Kmr-Gs for pgsql-general@arkaria.postgresql.org; Wed, 09 Jul 2025 15:17:56 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1uZWYV-000Kmi-6N for pgsql-general@lists.postgresql.org; Wed, 09 Jul 2025 15:17:55 +0000 Received: from mail-oi1-x22e.google.com ([2607:f8b0:4864:20::22e]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1uZWYU-006Q35-0d for pgsql-general@lists.postgresql.org; Wed, 09 Jul 2025 15:17:54 +0000 Received: by mail-oi1-x22e.google.com with SMTP id 5614622812f47-40d12821c1cso24946b6e.2 for ; Wed, 09 Jul 2025 08:17:54 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1752074273; x=1752679073; darn=lists.postgresql.org; h=to:subject:message-id:date:from:in-reply-to:references:mime-version :from:to:cc:subject:date:message-id:reply-to; bh=0pQs4RMSHtiJZ/TeTOPg6aiagWCin8TG5s+jc62Uxb8=; b=LFecxir0Zkd5tSVbCVupXa7oPGg4ylASqLFn7+UIJaHwMtZsU+XKZgiA9jEBXydXIf h78lnZn6YNqbZnLx5+V2xDy0CozIX3rDWZNBbTo/kvclAD0vhRMVXiwfEBkBSK5aCgLy ZXTq5aza/By/RlqjrVSq09M9/UZ4s5uP7AAZua5wxm8oqhrI2K9FSjROKo1FDqBPFoAA tG9p/OaTPGYrruMfITVFF7jQ+GFX1dxIG210ZjxIMY8e+LP0uQxqLyn2CmJBs5g4EhxZ t2VkUI3tIQC9u3EA2cvOtEFIYZ2TYuh6qgTQkJ86hmfkEgjDsUL7EGlTVeLGytjD1+FQ 40AQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1752074273; x=1752679073; h=to:subject:message-id:date:from:in-reply-to:references:mime-version :x-gm-message-state:from:to:cc:subject:date:message-id:reply-to; bh=0pQs4RMSHtiJZ/TeTOPg6aiagWCin8TG5s+jc62Uxb8=; b=nPSAZaJitY6/gwHXkrVlYPVG9ZNfWs2hbzdqvcuTvMLRo8v0nMC0/GTRJ4z1m+80kM FODfqMTdv0p5Zc0a0wosPt+KyzNilpiEUb1C4DQp4ss6bFYt6IGYlyceHbWo5IPvkQkk uLVZaiiCcZEq/82NE+8N2POjXw6VJA7wjP2W+muZRPWAAXfugyYgh/GA1nqlJywSbq4s 0a1gD55WBZktyO6I3nSW3zfKo7FpWgwpjQNkz8a8YVsmWcvzKVXiwMXy8tXYJCHi3wLV Y/dzQwpGkjKSxwKRJXmcHLG1kXlKUGbe/oyexVDCYav8gWbdqAtJIp7mlSr0yTfYMMyt 45Bg== X-Gm-Message-State: AOJu0Yzqlof47oFYQLeWiFrA4vfSOPRMKFksFlpKqJ1/eXTsUbpz4aEh vTuf/glptUq7EbnoRNy/usJ1fGfyby+eSZU0sS1Qsup4OpG+ECAytlsOKbDTm2YNWzFJOYIvQUw xelYDUu0uMO9WBqq1zvpe9Dwri6SXRPECHQ== X-Gm-Gg: ASbGncspSM/OYyjdF7zlwvXfNsX3bwKRBX41f7WvZim4snHAXgZTR4zgsBBnPytnk3K MvyNeCpNKVpOixUMb80Sva98T3uyBnGwQQGTDB+BVapvGtvbtbjbG9ydgIduIwcRDQwVrW5SLt9 Qj8O6lHM7dErFKejoJNxFY1Bzicuk2DKHIPZWYAdWtFG7q8x3ph5xlDDyvvJTOXQ8K0azTKHA83 0pE X-Google-Smtp-Source: AGHT+IHTAWtGNwSMSBJiy5Q6gGjj995B585WB7+pSuH7ety7H7zxZN6RY8Ria+HX9bCAyTH05mlaf8p6E/f+RRPXo/I= X-Received: by 2002:a05:6808:218d:b0:406:6e4b:bd91 with SMTP id 5614622812f47-413abd7bddbmr198647b6e.7.1752074273369; Wed, 09 Jul 2025 08:17:53 -0700 (PDT) MIME-Version: 1.0 References: <32a35a64-272e-4f0c-ba31-e764762d2f36@aklaver.com> In-Reply-To: <32a35a64-272e-4f0c-ba31-e764762d2f36@aklaver.com> From: Ron Johnson Date: Wed, 9 Jul 2025 11:17:40 -0400 X-Gm-Features: Ac12FXyp7ZjiWXBlZoYOFyLS0mQLeAg_CtJA9_3nq57T3lTU9CGozGfo0QpImlI Message-ID: Subject: Re: Password Encryption and Connection Issues To: "pgsql-general@lists.postgresql.org" Content-Type: multipart/alternative; boundary="000000000000af3382063980944b" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --000000000000af3382063980944b Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable On Wed, Jul 9, 2025 at 11:11=E2=80=AFAM Adrian Klaver wrote: > On 7/9/25 06:56, Alpaslan AKDA=C4=9E wrote: > > Hello all > > > > > As a result, some users are able to connect, while others cannot. > > What client is being used and what version of said client? > This is a salient point:clients from the pre-PG10 can only connect using md5. Thus, we have to use md5 hashes even in PG16. =F0=9F=98=AD --=20 Death to , and butter sauce. Don't boil me, I'm still alive. lobster! --000000000000af3382063980944b Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
On Wed, Jul 9, 2025 at 11:11=E2=80=AFAM A= drian Klaver <adrian.klaver= @aklaver.com> wrote:
On 7/9/25 06:56, A= lpaslan AKDA=C4=9E wrote:
> Hello all
>

> As a result, some users are able to connect, while others cannot.

What client is being used and what version of said client?
=
=C2=A0
This is a salient=C2=A0point:clients from the pre-PG1= 0 can only connect using md5.=C2=A0 Thus, we have to use md5 hashes even in= PG16.=C2=A0=F0=9F=98=AD

--
Death to <Redacted>, and butter sauce.
Don't bo= il me, I'm still alive.
<Redacted> lobster!
--000000000000af3382063980944b--