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
>
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? |