From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | yakov(dot)garbuz(at)asmr(dot)com |
Cc: | pgsql-bugs(at)lists(dot)postgresql(dot)org |
Subject: | Re: BUG #17585: Wrong path to the extension control file |
Date: | 2022-08-12 22:57:29 |
Message-ID: | 204589.1660345049@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
PG Bug reporting form <noreply(at)postgresql(dot)org> writes:
> 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
I find it *extremely* implausible that those are actually the same
server, because the path to the extension directory isn't configurable;
it's pretty much wired in at build time. So I think you've managed to
put two separate PG installations on that machine. One of them looks to
be following HomeBrew directory conventions, while /usr/pgsql-12/ is sort
of like what Debian does and not at all like any macOS packager I know.
Are you really sure you're connecting to the same machine in both
examples? "SELECT version();" might be informative, also
"SHOW config_file;".
regards, tom lane
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2022-08-13 19:23:11 | Re: BUG #17583: Server crashes on executing CROSS JOIN with very big number of tables |
Previous Message | PG Bug reporting form | 2022-08-12 20:23:21 | BUG #17585: Wrong path to the extension control file |