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