Re: Reconfiguring active PostgreSQL instance

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