From: Tom Lane <tgl@sss.pgh.pa.us>
To: =?UTF-8?B?Q2loYXQgS8O8w6fDvGtiYcSfcsSxYcOnxLFr?= <cihat.kucukbagriacik@profelis.com.tr>
cc: pgsql-general@lists.postgresql.org
Subject: Re: Passwordcheck Extension Not Installing
In-reply-to: <CAAqOvVMd4nUJVL0iXcMK4HwLm+UA2h_EqEfbzWysxTv45UMGDw@mail.gmail.com>
References: <CAAqOvVMd4nUJVL0iXcMK4HwLm+UA2h_EqEfbzWysxTv45UMGDw@mail.gmail.com>
Comments: In-reply-to =?UTF-8?B?Q2loYXQgS8O8w6fDvGtiYcSfcsSxYcOnxLFr?= <cihat.kucukbagriacik@profelis.com.tr>
	message dated "Sat, 08 Feb 2025 22:28:44 +0300"
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-ID: <2057122.1739136035.1@sss.pgh.pa.us>
Content-Transfer-Encoding: quoted-printable
Date: Sun, 09 Feb 2025 16:20:35 -0500
Message-ID: <2057123.1739136035@sss.pgh.pa.us>
Archived-At: <https://www.postgresql.org/message-id/2057123.1739136035%40sss.pgh.pa.us>
Precedence: bulk

=3D?UTF-8?B?Q2loYXQgS8O8w6fDvGtiYcSfcsSxYcOnxLFr?=3D <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 foun=
d"
> 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 Postgre=
SQL
> 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. Cou=
ld
> 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