Re: Passwordcheck Extension Not Installing

From: Cihat Küçükbağrıaçık <cihat(dot)kucukbagriacik(at)profelis(dot)com(dot)tr>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: Passwordcheck Extension Not Installing
Date: 2025-02-10 13:20:07
Message-ID: CAAqOvVNWc9y2WcxqxW9hqD3wX=R3whb6nK0WU45K4gw2zEqjGg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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(at)sss(dot)pgh(dot)pa(dot)us>, 10 Şub 2025 Pzt, 00:20 tarihinde şunu yazdı:

> =?UTF-8?B?Q2loYXQgS8O8w6fDvGtiYcSfcsSxYcOnxLFr?= <
> cihat(dot)kucukbagriacik(at)profelis(dot)com(dot)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
>

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Mukesh Tanuku 2025-02-10 13:34:12 Re: PG-15.6: timeout parameters erroring out
Previous Message Florents Tselai 2025-02-10 13:01:48 Re: How to read an external pdf file from postgres?