Message-ID: <5e920c39-8587-4185-b7ef-7e820b23e59b@dalibo.com>
Date: Mon, 10 Feb 2025 11:27:45 +0100
MIME-Version: 1.0
User-Agent: Mozilla Thunderbird
Subject: Re: Passwordcheck Extension Not Installing
To: pgsql-general@lists.postgresql.org
References: <CAAqOvVMd4nUJVL0iXcMK4HwLm+UA2h_EqEfbzWysxTv45UMGDw@mail.gmail.com>
Content-Language: fr
From: Guillaume Lelarge <guillaume.lelarge@dalibo.com>
Organization: Dalibo
In-Reply-To: <CAAqOvVMd4nUJVL0iXcMK4HwLm+UA2h_EqEfbzWysxTv45UMGDw@mail.gmail.com>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 8bit
Archived-At: <https://www.postgresql.org/message-id/5e920c39-8587-4185-b7ef-7e820b23e59b%40dalibo.com>
Precedence: bulk

Hi,

On 08/02/2025 20:28, Cihat Küçükbağrıaçık wrote:
> Hi Community,
> 
> I have a PostgreSQL 17.2 database running on Ubuntu 22.04. I'm trying to 
> install the |passwordcheck| extension, but I keep getting a "file not 
> found" error.
> 
> postgres=# 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 <https:// 
> 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 all.

Regards.


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