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