Re: BUG #17939: CREATE EXTENSION pltcl; looks in the wrong folder - Mailing list pgsql-bugs

From Julien Rouhaud
Subject Re: BUG #17939: CREATE EXTENSION pltcl; looks in the wrong folder
Date
Msg-id 20230523070419.3ztesptgw3m6ch77@jrouhaud
Whole thread Raw
In response to BUG #17939: CREATE EXTENSION pltcl; looks in the wrong folder  (PG Bug reporting form <noreply@postgresql.org>)
List pgsql-bugs
On Tue, May 23, 2023 at 06:47:19AM +0000, PG Bug reporting form wrote:
>
> matthew@matthew-QEMU:~$ psql -d matthew -U matthew
> psql (15.2 (Ubuntu 15.2-1), server 14.7 (Ubuntu 14.7-0ubuntu0.22.10.1))
> [...]
> So when the version I have is definitely version 15.2 it looks for
> extensions in the folder for version 14.

The *client* version is definitely 15.2, but as psql told when you opened the
connection you're actually connected on a 14.7 *server*, so postgres is
searching in the correct folder.

You can look at e.g. pg_lsclusters to see what instances are currently setup,
and of which version.



pgsql-bugs by date:

Previous
From: Alexey Kachalin
Date:
Subject: Prepared SQL name collision. The name implicitly is truncated by NAMEDATALEN
Next
From: Alvaro Herrera
Date:
Subject: Re: Need Support to Upgrade from 13.6 to 15.3