Re[2]: Enabling extensions on a compiled instance of postgresql 12.1

From: "Sterpu Victor" <victor(at)caido(dot)ro>
To: "Julien Rouhaud" <rjuju123(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re[2]: Enabling extensions on a compiled instance of postgresql 12.1
Date: 2020-02-13 14:11:16
Message-ID: em923303ea-d80d-43b1-9595-8e1b5e14e22e@victor-pc
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

It works.
Thank you, thank you, thank you.

------ Original Message ------
From: "Julien Rouhaud" <rjuju123(at)gmail(dot)com>
To: "Sterpu Victor" <victor(at)caido(dot)ro>
Cc: pgsql-general(at)postgresql(dot)org
Sent: 2020-02-13 3:48:08 PM
Subject: Re: Enabling extensions on a compiled instance of postgresql
12.1

>On Thu, Feb 13, 2020 at 01:34:55PM +0000, Sterpu Victor wrote:
>> Hello
>>
>> I compiled from source postgresql 12.1 and all went fine but when I
>>try to
>> restore my DB I can see that I have 3 extensions missing: uuid-ossp,
>> btree_gist, tablefunc.
>> I tried to run: CREATE EXTENSION "uuid-ossp"; and the error is ERROR:
>> could
>> not open extension control file
>> "/usr/local/pgsql_12.1/share/extension/uuid-ossp.control": No such
>>file or
>> directory
>> How do I enable these extensions? I tried to copy the file from my
>>previous
>> postgres version but is not compatible.
>> These were my compiling options: ./configure --with-ossp-uuid
>> --with-uuid=bsd --prefix=/usr/local/pgsql_12.1
>
>Did you also do a "make install" under the contrib/ directory?

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2020-02-13 15:45:57 Re: pg_upgrade —link does it remove table bloat
Previous Message Julien Rouhaud 2020-02-13 13:48:08 Re: Enabling extensions on a compiled instance of postgresql 12.1