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