Обсуждение: create extension points to the wrong directory

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

On 6/28/19 4: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

Are you doing this in the 9.5 instance instead of the 10 instance?

In other words what does(in psql):

select version();

show?


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


-- 
Adrian Klaver
adrian.klaver@aklaver.com