From: | "Reno, Natalie" <Natalie(dot)Reno(at)cchmc(dot)org> |
---|---|
To: | "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com> |
Cc: | Pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org> |
Subject: | RE: Reconfiguring active PostgreSQL instance |
Date: | 2021-12-21 15:15:40 |
Message-ID: | BL0PR01MB4148F9B500D4F02AA0FEB2788A7C9@BL0PR01MB4148.prod.exchangelabs.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
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<mailto: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<mailto: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.
From | Date | Subject | |
---|---|---|---|
Next Message | Gogala, Mladen | 2021-12-21 15:27:17 | Re: Reconfiguring active PostgreSQL instance |
Previous Message | David G. Johnston | 2021-12-21 15:10:46 | Re: Reconfiguring active PostgreSQL instance |