public inbox for [email protected]  

help / color / mirror / Atom feed

From: Cihat Küçükbağrıaçık <[email protected]>
To: Tom Lane <[email protected]>
Cc: [email protected]
Subject: Re: Passwordcheck Extension Not Installing
Date: Mon, 10 Feb 2025 16:20:07 +0300
Message-ID: <CAAqOvVNWc9y2WcxqxW9hqD3wX=R3whb6nK0WU45K4gw2zEqjGg@mail.gmail.com> (raw)
In-Reply-To: <[email protected]>
References: <CAAqOvVMd4nUJVL0iXcMK4HwLm+UA2h_EqEfbzWysxTv45UMGDw@mail.gmail.com>
	<[email protected]>

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 <[email protected]>, 10 Şub 2025 Pzt, 00:20 tarihinde şunu yazdı:

> =?UTF-8?B?Q2loYXQgS8O8w6fDvGtiYcSfcsSxYcOnxLFr?= <
> [email protected]> 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
>


Attachments:

  [image/png] Ekran Resmi 2025-02-10 16.13.27.png (360.8K, 3-Ekran%20Resmi%202025-02-10%2016.13.27.png)
  download | view image

view thread (3+ messages)  latest in thread

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected], [email protected]
  Subject: Re: Passwordcheck Extension Not Installing
  In-Reply-To: <CAAqOvVNWc9y2WcxqxW9hqD3wX=R3whb6nK0WU45K4gw2zEqjGg@mail.gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox