From: PG Bug reporting form <noreply@postgresql.org>
To: pgsql-bugs@lists.postgresql.org
Cc: yakov.garbuz@asmr.com
Subject: BUG #17585: Wrong path to the extension control file
Date: Fri, 12 Aug 2022 20:23:21 +0000
Message-ID: <17585-f1cb9854d087c002@postgresql.org> (raw)
The following bug has been logged on the website:
Bug reference: 17585
Logged by: Yakov Garbuz
Email address: yakov.garbuz@asmr.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@12/12.11/share/postgresql@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
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: pgsql-bugs@postgresql.org
Cc: noreply@postgresql.org, pgsql-bugs@lists.postgresql.org, yakov.garbuz@asmr.com
Subject: Re: BUG #17585: Wrong path to the extension control file
In-Reply-To: <17585-f1cb9854d087c002@postgresql.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox