From: Gogala, Mladen <gogala.mladen@gmail.com>
To: pgsql-admin@lists.postgresql.org
Subject: Re: Reconfiguring active PostgreSQL instance
Date: Tue, 21 Dec 2021 10:27:17 -0500
Message-ID: <9b0a5879-1ad9-98db-e18b-5576542dad6b@gmail.com> (raw)
In-Reply-To: <BL0PR01MB4148F9B500D4F02AA0FEB2788A7C9@BL0PR01MB4148.prod.exchangelabs.com>
References: <BL0PR01MB4148FDEC6C7E711E71279D708A7C9@BL0PR01MB4148.prod.exchangelabs.com>
<CAKFQuwZx3ne2mo1uZEf4KV4hvDBXoj5n+Qv-ebTB=GniCAuP+g@mail.gmail.com>
<BL0PR01MB4148F9B500D4F02AA0FEB2788A7C9@BL0PR01MB4148.prod.exchangelabs.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.reno@cchmc.org
>
> 513.803.5370
>
> *From:* David G. Johnston <david.g.johnston@gmail.com>
> *Sent:* Tuesday, December 21, 2021 10:11 AM
> *To:* Reno, Natalie <Natalie.Reno@cchmc.org>
> *Cc:* Pgsql-admin <pgsql-admin@lists.postgresql.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.Reno@cchmc.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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: gogala.mladen@gmail.com, pgsql-admin@lists.postgresql.org
Subject: Re: Reconfiguring active PostgreSQL instance
In-Reply-To: <9b0a5879-1ad9-98db-e18b-5576542dad6b@gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox