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 1slo7m-001JfO-Fj for pgsql-general@arkaria.postgresql.org; Wed, 04 Sep 2024 11:24:34 +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 1slo7k-008Iau-Su for pgsql-general@arkaria.postgresql.org; Wed, 04 Sep 2024 11:24:33 +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 1slo7k-008Iam-ED for pgsql-general@lists.postgresql.org; Wed, 04 Sep 2024 11:24:32 +0000 Received: from mail-wr1-x430.google.com ([2a00:1450:4864:20::430]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1slo7h-0006K7-UN for pgsql-general@lists.postgresql.org; Wed, 04 Sep 2024 11:24:31 +0000 Received: by mail-wr1-x430.google.com with SMTP id ffacd0b85a97d-3770320574aso695893f8f.2 for ; Wed, 04 Sep 2024 04:24:29 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=cybertec-at.20230601.gappssmtp.com; s=20230601; t=1725449067; x=1726053867; darn=lists.postgresql.org; h=mime-version:user-agent:content-transfer-encoding:references :in-reply-to:date:to:from:subject:message-id:from:to:cc:subject:date :message-id:reply-to; bh=QJWCjOgEoZkUNeCEIz96nezhmLl2JflkSgFR4ytqj6E=; b=cuLxMbcIIB/GM9LXKWv0fsr13pJFjzYCb9qEXlnJwGCLgriX7R7CeV47KOKXMchjA8 WBqsVECo2N8sPIs5EtZyPWiUjKCVTQaHXU5pSXeMblXys0HHqisXYgBphbDYKGbq6AVc nv8MII+zzPkqvcBwXFaQ5zrmK+/b0eo/5/PfpkbPlQISRs34ykxdJyLjs067BFwhtddZ cqPRNETVcMzVaXjtx5YdUqwAeEutanHMmF66JcxJl/r2x4zFuZNEPKMAzFNBG9G0Z/4u LQGKZxJCldaRTjegkOIS39IlP4/kzN/7e6tjt/L4iI7taoZyjjZSj0aUF4CDy7mKHA97 OHpg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1725449067; x=1726053867; h=mime-version:user-agent:content-transfer-encoding:references :in-reply-to:date:to:from:subject:message-id:x-gm-message-state:from :to:cc:subject:date:message-id:reply-to; bh=QJWCjOgEoZkUNeCEIz96nezhmLl2JflkSgFR4ytqj6E=; b=c3ikVV9ud4c6qcXx5RGYP480lDTFjMO2uk4dwJjTv3EtBrnr+VTuXec83idhEFTCiL DcxLPljwusHEKHUC0R3Xsurv+LxakwmJTVvghr7zToRxObgYomhHQVM34+BzPNrwgclU Xr1YiWBlZvrk/PxS/Yb+dGRnzH+aX7xe3KJ3K4+sD34azkND0n6PxhZBYiO+nCySqIYP UxMgY0INkyzkJF1rbiu5KsGNjv4T7KAWiDjtK+8tYn6MdFywbiBZkgvD5ywTgArNOKvo oFfUodazP4IOEA33KOKFawWHwY8G2yNntl0KfMLC7JFQn4dVDMGtmUq+uYr7BaUkDvkv 3TaA== X-Forwarded-Encrypted: i=1; AJvYcCUIPZashoAYctIU+nlZO98ffTOAT5b3hqusSMUMjbPkzQz5Lbl/r9mPexEGoVmEh3iyavkvw9bgFK0162oA@lists.postgresql.org X-Gm-Message-State: AOJu0Yze5nKnSXHx9zgneXA4/CJzg+PyPkyxVM23pQMgNvA3O0VyrwL+ UfgAbm3Q3pxnjL0Zc2coS7ywu0vUrnImXMmGTeV4uIEfd4WhXqjtSzxXOMkJ3kU= X-Google-Smtp-Source: AGHT+IFLwzVW+RXRlVyNb6sAxd4BPmHyb8ZixnPCoes0XaBPHFBny/27AYjNM4SGzYCPyJ4fcF+GLg== X-Received: by 2002:a05:6000:bd0:b0:374:c606:df0a with SMTP id ffacd0b85a97d-374c606dfc7mr6738005f8f.36.1725449066641; Wed, 04 Sep 2024 04:24:26 -0700 (PDT) Received: from dynamic-pd01.res.v6.highway.a1.net ([2001:871:5e:b7d4:b89d:ed:29a4:178]) by smtp.gmail.com with ESMTPSA id 5b1f17b1804b1-42bbd1eee1bsm170148285e9.9.2024.09.04.04.24.26 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Wed, 04 Sep 2024 04:24:26 -0700 (PDT) Message-ID: <981dd499db1c6464b4e5d6461a6519cf4029ba7d.camel@cybertec.at> Subject: Re: libpq15 with postgres server16 and scram-sha-256 From: Laurenz Albe To: MM , pgsql-general@lists.postgresql.org Date: Wed, 04 Sep 2024 13:24:25 +0200 In-Reply-To: References: Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable User-Agent: Evolution 3.52.4 (3.52.4-1.fc40) MIME-Version: 1.0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Wed, 2024-09-04 at 11:54 +0100, MM wrote: > is it possible to connect with PGConnectdb version 15 to a server that ha= s in METHOD in pg_hba.conf=C2=A0 =C2=A0"scram-sha-256" > or do I need version libpq 16 ? You can use "scram-sha-256" authentication from v10 on. Note that it only works if the database password is a scram-sha-256 hash, n= ot an MD5 hash. Yours, Laurenz Albe