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 1thW3w-003Ow7-42 for pgsql-general@arkaria.postgresql.org; Mon, 10 Feb 2025 15:51:08 +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 1thW3u-002JNd-Je for pgsql-general@arkaria.postgresql.org; Mon, 10 Feb 2025 15:51:06 +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 1thW3u-002JNV-51 for pgsql-general@lists.postgresql.org; Mon, 10 Feb 2025 15:51:06 +0000 Received: from mail-lf1-x12a.google.com ([2a00:1450:4864:20::12a]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1thW3p-0003O0-2o for pgsql-general@lists.postgresql.org; Mon, 10 Feb 2025 15:51:05 +0000 Received: by mail-lf1-x12a.google.com with SMTP id 2adb3069b0e04-545039b6a67so2227071e87.0 for ; Mon, 10 Feb 2025 07:51:01 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=profelis.com.tr; s=profelis.com.tr; t=1739202660; x=1739807460; 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=kwavS+qUlH3ecQoYhQomy/0DpBziOuuQeEqxFJ9vwG8=; b=ElsdUfU204jfL8kKkZOLK4WX+HMSZj2fYUKsZW5IdBOInsSTs/xMYbAbOQbl4nh/66 u7an4ElGiNOe2OhAPAEnPT2CO+W01yeKWqyz2qJo06fW7UtbAuDlHwRKgkZENNL4Sarf J09bSLKZAqbNucwKZVyopNpybLIqGp7ZY8mfA= X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1739202660; x=1739807460; 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=kwavS+qUlH3ecQoYhQomy/0DpBziOuuQeEqxFJ9vwG8=; b=jBucpVvdMLzlGamT+kjkJ9bli6zIaPr9VJeYGMorrNnnHa8Mqo8ftPvzBAgfc3G23Y vHb1vWMs1Qkcb8zdu5Ga0M+JUy/+f0pObu3Ek9D9dwWJtrsLBminOOP9hk58vBzrSZHt L8UG6mUWCLd61zzbERKsV5AuIYJ3TMAhDrQwXU3p/KiPbKalsXyDBW2ITG7a+CTG/VU7 TrjSzzYnn1Y2Tv4tcqoJfqgeC9pYgpiWjO1Alm8cUEfkJrhYuKKY2sqtGoTGTdbjS5k1 FKXd3oTf+qYbLUACRXbEcyEg1kFP1KcqN7KjD6KEDj0RX3xXCJhbFjoknUXDDkQFrqBC EevA== X-Forwarded-Encrypted: i=1; AJvYcCWLKlSdpnk/DAysqp0MYfRoLTzB3Jxvo2AUBRq6HTztzy5KEBmkRxQo6nrnGTocuJhMTeQOc23WgE3CVMkz@lists.postgresql.org X-Gm-Message-State: AOJu0YxkHEMUbTDQN8piGh0H5sBfWcc9LKy2eNNdf/D+X93G2T0GpJn9 gGFvLFRslnF4Oq9VNrKe0sbEFBa+459thsmRhwwikelaywAShL/BPs3+J6hZ6+7VkB0WtOc+b17 3tZZm55HOPudek3KKsHVu9Sf8g54a+bQlOPwMqA== X-Gm-Gg: ASbGncv2CtUtPCNRmEy+lCtaVfMjeHz2i6bEHirBpyOoutOxqe45lIZoO1UBw9cArVp UOiGlFfgmukfeY4C7nrc8mxRnSMMmNEsXVO6wbLeouLWR8irzdyPocuU8CqzNhay9tHXXqpxrsw == X-Google-Smtp-Source: AGHT+IFNLU+Jw7vmUfXmbTgn02HjyNQc6tryg+lsrxBjfn7ebVNhlM+oe3x7VVxxIBHOegr65y2lT39FSvrBUq7vl0o= X-Received: by 2002:a05:6512:ba3:b0:545:ee3:f3cd with SMTP id 2adb3069b0e04-5450ee3fbb4mr749834e87.9.1739202660123; Mon, 10 Feb 2025 07:51:00 -0800 (PST) MIME-Version: 1.0 References: <5e920c39-8587-4185-b7ef-7e820b23e59b@dalibo.com> In-Reply-To: From: =?UTF-8?B?Q2loYXQgS8O8w6fDvGtiYcSfcsSxYcOnxLFr?= Date: Mon, 10 Feb 2025 18:50:48 +0300 X-Gm-Features: AWEUYZlKPs7trBJO5IfjM_8naYfv6zwKqNlf8S67NOy-4UtnjTEQjgc5CQHXl2M Message-ID: Subject: Re: Passwordcheck Extension Not Installing To: guillaume.lelarge@dalibo.com, pgsql-general@lists.postgresql.org Content-Type: multipart/alternative; boundary="000000000000bfdf85062dcbac5d" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --000000000000bfdf85062dcbac5d Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable Hi, Thank you for your response. Yes, it turns out that it works without needing to run *CREATE EXTENSION*. My issue has been resolved. Thank you for your help. Best regards. > > ---------- Forwarded message --------- > G=C3=B6nderen: Guillaume Lelarge > Date: 10 =C5=9Eub 2025 Pzt, 13:28 > Subject: Re: Passwordcheck Extension Not Installing > To: > > > Hi, > > On 08/02/2025 20:28, Cihat K=C3=BC=C3=A7=C3=BCkba=C4=9Fr=C4=B1a=C3=A7=C4= =B1k wrote: > > Hi Community, > > > > I have a PostgreSQL 17.2 database running on Ubuntu 22.04. I'm trying t= o > > install the |passwordcheck| extension, but I keep getting a "file not > > found" error. > > > > postgres=3D# create extension passwordcheck; > > ERROR: extension "passwordcheck" is not available > > DETAIL: Could not open extension control file "/usr/share/ > > postgresql/17/extension/passwordcheck.control": No such file or > directory. > > HINT: The extension must first be installed on the system where > > PostgreSQL is running. > > > > > > Even though I have installed the |postgresql-contrib| packages, I still > > cannot see the extension. Below, I have listed the steps I followed. > > Could you help me with this issue? > > > > https://www.postgresql.org/docs/current/passwordcheck.html > www.postgresql.org/docs/current/passwordcheck.html> > > > > To install passwordcheck, you shouldn't use "CREATE EXTENSION". You need > to add it to shared_preload_librarires, restart PostgreSQL, and that's al= l. > > Regards. > > > -- > Guillaume Lelarge > Consultant > https://dalibo.com > > > --000000000000bfdf85062dcbac5d Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable

Hi,

Thank you for your response.= Yes, it turns out that it works without needing to run CREATE EXTE= NSION. My issue has been resolved. Thank you for your help.

= Best regards.





---------- Forwarded message -----= ----
G=C3=B6nderen: Guillaume= Lelarge <guillaume.lelarge@dalibo.com>
D= ate: 10 =C5=9Eub 2025 Pzt, 13:28
Subject: Re: Passwordcheck Extension No= t Installing
To: <pgsql-general@lists.postgresql.org>
<= br>
Hi,

On 08/02/2025 20:28, Cihat K=C3=BC=C3=A7=C3=BCkba=C4=9Fr=C4=B1a=C3=A7=C4=B1= k wrote:
> Hi Community,
>
> I have a PostgreSQL 17.2 database running on Ubuntu 22.04. I'm try= ing to
> install the |passwordcheck| extension, but I keep getting a "file= not
> found" error.
>
> postgres=3D# create extension passwordcheck;
> ERROR: =C2=A0extension "passwordcheck" is not available
> DETAIL: =C2=A0Could not open extension control file "/usr/share/ =
> postgresql/17/extension/passwordcheck.control": No such file or d= irectory.
> HINT: =C2=A0The extension must first be installed on the system where =
> PostgreSQL is running.
>
>
> Even though I have installed the |postgresql-contrib| packages, I stil= l
> cannot see the extension. Below, I have listed the steps I followed. <= br> > Could you help me with this issue?
>
> https://www.postgresql.org/docs/curre= nt/passwordcheck.html <https://
> www.postgresql.org/docs/current/passwo= rdcheck.html>
>

To install passwordcheck, you shouldn't use "CREATE EXTENSION"= ;. You need
to add it to shared_preload_librarires, restart PostgreSQL, and that's = all.

Regards.


--
Guillaume Lelarge
Consultant
https:/= /dalibo.com


--000000000000bfdf85062dcbac5d--