Enabling extensions on a compiled instance of postgresql 12.1

From: "Sterpu Victor" <victor(at)caido(dot)ro>
To: pgsql-general(at)postgresql(dot)org
Subject: Enabling extensions on a compiled instance of postgresql 12.1
Date: 2020-02-13 13:34:55
Message-ID: em921ca1f1-31af-4936-9333-ebfa7c7664d8@victor-pc
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Thank you.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Julien Rouhaud 2020-02-13 13:48:08 Re: Enabling extensions on a compiled instance of postgresql 12.1
Previous Message Tim Kane 2020-02-13 13:19:19 Re: Avoiding out of date statistics / planner