BUG #17585: Wrong path to the extension control file

From: PG Bug reporting form <noreply(at)postgresql(dot)org>
To: pgsql-bugs(at)lists(dot)postgresql(dot)org
Cc: yakov(dot)garbuz(at)asmr(dot)com
Subject: BUG #17585: Wrong path to the extension control file
Date: 2022-08-12 20:23:21
Message-ID: 17585-f1cb9854d087c002@postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

The following bug has been logged on the website:

Bug reference: 17585
Logged by: Yakov Garbuz
Email address: yakov(dot)garbuz(at)asmr(dot)com
PostgreSQL version: 12.11
Operating system: Mac OS
Description:

When I login to a server
sudo -u postgres -h "nnn.nnn.nnn.nnn" -p nnnn -d postgres psql
and execute command
CREATE EXTENSION IF NOT EXISTS postgres_fdw;
it runs OK, extension created and file postgres_fdw.control found in the
folder
"/usr/local/Cellar/postgresql(at)12/12.11/share/postgresql(at)12/extension/"

But when I login to the same server but to the different database and as a
different user
sudo -u myuser -h "nnn.nnn.nnn.nnn" -p nnnn -d mydb psql
and try execute the same command
CREATE EXTENSION IF NOT EXISTS postgres_fdw;
I'm getting ERROR: could not open extension control file
"/usr/pgsql-12/share/extension/postgres_fdw.control": No such file or
directory

For some reason application is looking for file postgres_fdw.control in the
non-existing directory /usr/pgsql-12/

Please advise

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2022-08-12 22:57:29 Re: BUG #17585: Wrong path to the extension control file
Previous Message Euler Taveira 2022-08-12 19:25:31 Re: BUG #17584: SQL crashes PostgreSQL when using ICU collation