From: Dai, Tino <tdai@loc.gov>
To: Holger Jakobs <holger@jakobs.com>
To: pgsql-admin@lists.postgresql.org <pgsql-admin@lists.postgresql.org>
To: Gogala, Mladen <gogala.mladen@gmail.com>
Subject: Re: Reconfiguring active PostgreSQL instance
Date: Tue, 21 Dec 2021 15:37:42 +0000
Message-ID: <1640101158583.11955@loc.gov> (raw)
In-Reply-To: <F77B6CBD-23E1-4060-B7BD-968F7D4D80F3@jakobs.com>
References: <BL0PR01MB4148FDEC6C7E711E71279D708A7C9@BL0PR01MB4148.prod.exchangelabs.com>
<CAKFQuwZx3ne2mo1uZEf4KV4hvDBXoj5n+Qv-ebTB=GniCAuP+g@mail.gmail.com>
<BL0PR01MB4148F9B500D4F02AA0FEB2788A7C9@BL0PR01MB4148.prod.exchangelabs.com>
<9b0a5879-1ad9-98db-e18b-5576542dad6b@gmail.com>
<F77B6CBD-23E1-4060-B7BD-968F7D4D80F3@jakobs.com>
Is it AIX? The /u01 feels like AIX. -T
________________________________
From: Holger Jakobs <holger@jakobs.com>
Sent: Tuesday, December 21, 2021 10:33 AM
To: pgsql-admin@lists.postgresql.org; Gogala, Mladen
Subject: 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.mladen@gmail.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<mailto:natalie.reno@cchmc.org>
513.803.5370
From: David G. Johnston <david.g.johnston@gmail.com><mailto:david.g.johnston@gmail.com>
Sent: Tuesday, December 21, 2021 10:11 AM
To: Reno, Natalie <Natalie.Reno@cchmc.org><mailto:Natalie.Reno@cchmc.org>
Cc: Pgsql-admin <pgsql-admin@lists.postgresql.org><mailto: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<mailto: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
--
Holger Jakobs, Bergisch Gladbach
+49 178 9759012
- sent from mobile, therefore short -
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: tdai@loc.gov, holger@jakobs.com, pgsql-admin@lists.postgresql.org, gogala.mladen@gmail.com
Subject: Re: Reconfiguring active PostgreSQL instance
In-Reply-To: <1640101158583.11955@loc.gov>
* 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