Re: create extension points to the wrong directory - Mailing list pgsql-general

From Rob Sargent
Subject Re: create extension points to the wrong directory
Date
Msg-id c8fc431b-1088-5ac6-bab2-41a42b313261@gmail.com
Whole thread Raw
In response to create extension points to the wrong directory  (Benedict Holland <benedict.m.holland@gmail.com>)
List pgsql-general


On 6/28/19 5:41 PM, Benedict Holland wrote:
Hello all,

I really can't figure this one out. I am trying to get debug working on a postgrseql 10 database on ubuntu. I installed the proper package postgresql-10-pldebugger. When I go to create the extention, I get the error:

create extension pldbgapi
ERROR: could not open extension control file "/usr/share/postgresql/9.5/extension/pldbgapi.control": No such file or directory
Which is true because it is in /usr/share/postgrseql/10/extension/pldbgapi.control. I am trying to run this command in pgadmin4. I am stuck. There doesn't seem to be a configuration option. Any ideas?

Thanks,
~Ben


Kinda late in the day so most of the pros might not see this.

maybe uninstall postgresql-9.5

Can you try same create extension from psql directly?

select version(); ? version 10

select * from pg_settings where name ~ 'dir';


pgsql-general by date:

Previous
From: Benedict Holland
Date:
Subject: create extension points to the wrong directory
Next
From: Adrian Klaver
Date:
Subject: Re: create extension points to the wrong directory