Passwordcheck Extension Not Installing

=?UTF-8?B?Q2loYXQgS8O8w6fDvGtiYcSfcsSxYcOnxLFr?= <cihat.kucukbagriacik@profelis.com.tr> writes:

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?

Are any of the usual extensions present in that directory, or is it
just passwordcheck that's missing?

The most obvious bet is that you installed a postgresql-contrib
package that is not really compatible with the server package
you're using and it put all the extension files somewhere else
than where the server expects to find them. Try checking the
file listing for the postgresql-contrib package you used.

regards, tom lane

On 2/8/25 11: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?

I don't see it in any of the contrib/ directories for 14-17 on Ubuntu
22.04. Nor can I find it elsewhere in the packages.

You might try asking here:

https://www.postgresql.org/list/pgsql-pkg-debian/

https://www.postgresql.org/docs/current/passwordcheck.html
<https://www.postgresql.org/docs/current/passwordcheck.html&gt;

resim.png

Regards.

--
Adrian Klaver
adrian.klaver@aklaver.com

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

Hi Tom,

Thank you for your response. My *postgresql-contrib* package and PostgreSQL
versions appear to be compatible, as shown below. Additionally, other
extensions are installed in the *"/usr/share/postgresql/17/extension/"*
directory.

I have also observed that the *passwordcheck.so* file exists in the
*"/usr/lib/postgresql/17/lib/"* directory. It seems that, for some reason,
when the PostgreSQL service starts, it is unable to read the
*passwordcheck.so* file and create the *passwordcheck.control* file in the
*"/usr/share/postgresql/17/extension/"* directory. I don't think this issue
is due to a missing package; it appears to be a general problem.

[image: Ekran Resmi 2025-02-10 16.13.27.png]

Regards.

Tom Lane <tgl@sss.pgh.pa.us>, 10 Şub 2025 Pzt, 00:20 tarihinde şunu yazdı:

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.

=?UTF-8?B?Q2loYXQgS8O8w6fDvGtiYcSfcsSxYcOnxLFr?= <cihat.kucukbagriacik@profelis.com.tr> writes:

I have also observed that the *passwordcheck.so* file exists in the
*"/usr/lib/postgresql/17/lib/"* directory. It seems that, for some reason,
when the PostgreSQL service starts, it is unable to read the
*passwordcheck.so* file and create the *passwordcheck.control* file in the
*"/usr/share/postgresql/17/extension/"* directory.

No, you misunderstand the process. The .control file is one of the
distributed files for an extension; the server has no ability to
create one.

What we both missed is that *passwordcheck is not an extension*.
It has no SQL-visible objects. It's just a shared library that
you must preload into the server, as per its documentation.

regards, tom lane