Re: Reconfiguring active PostgreSQL instance

The path looks like it's a very unconventional installation. Usually, it should be something like /usr/local/... if it's on a unixoide system.

Maybe it's a Mac. This should be mentioned in the question.

Am 21. Dezember 2021 16:27:17 MEZ schrieb "Gogala, Mladen" <gogala(dot)mladen(at)gmail(dot)com>:
>Hi Natalie,
>
>It looks like the extension is not properly installed.
>
>Regards
>
>On 12/21/2021 10:15 AM, Reno, Natalie wrote:
>>
>> glimps_db_t=> create extension "uuid-ossp" ;
>>
>> ERROR:  could not open extension control file
>> "/u01/app/postgres/product/postgresql-12.8/data/extension/uuid-ossp.control":
>> No such file or directory
>>
>> Should I copy the control file over from the contrib directory?
>>
>> */Natalie Reno (she/her/hers)/*
>>
>> Lead Database Administrator
>>
>> Database Infrastructure Team
>>
>> /Research IT/
>>
>> /Cincinnati Children's Hospital/
>>
>> natalie(dot)reno(at)cchmc(dot)org
>>
>> 513.803.5370
>>
>> *From:* David G. Johnston <david(dot)g(dot)johnston(at)gmail(dot)com>
>> *Sent:* Tuesday, December 21, 2021 10:11 AM
>> *To:* Reno, Natalie <Natalie(dot)Reno(at)cchmc(dot)org>
>> *Cc:* Pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org>
>> *Subject:* Re: Reconfiguring active PostgreSQL instance
>>
>> *This email originated from an EXTERNAL sender to CCHMC. Proceed with
>> caution when replying, opening attachments, or clicking links in this
>> message.*
>>
>> On Tue, Dec 21, 2021, 06:42 Reno, Natalie <Natalie(dot)Reno(at)cchmc(dot)org> wrote:
>>
>> We provide a PostgreSQL instance that we configure ourselves. An
>> application is now needing the uuid-ossp extension which requires
>> the –with-uuid=ossp flag added to the configuration.
>>
>> So what happens when you execute create extension?
>>
>> David J.--
>>
>_*This email has originated from an extremely suspect and sometimes very
>grumpy sender. Proceed with extreme caution and use the Force, if
>possible.*_
>
>
>Hi Natalie,
>
>It looks like the extension is not properly installed.
>
>Regards
>
>
>Mladen Gogala
>Oracle DBA
>Tel: (347) 321-1217
>Blog: https://dbwhisperer.wordpress.com
--
Holger Jakobs, Bergisch Gladbach
+49 178 9759012
- sent from mobile, therefore short -