Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1mzhDA-0004mK-3o for pgsql-admin@arkaria.postgresql.org; Tue, 21 Dec 2021 15:37:56 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1mzhD8-0000u2-Nx for pgsql-admin@arkaria.postgresql.org; Tue, 21 Dec 2021 15:37:54 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1mzhD8-0000tt-89 for pgsql-admin@lists.postgresql.org; Tue, 21 Dec 2021 15:37:54 +0000 Received: from mx42.loc.gov ([140.147.31.2]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1mzhD5-0006Uq-LI for pgsql-admin@lists.postgresql.org; Tue, 21 Dec 2021 15:37:53 +0000 Received: from pps.filterd (c4bappps02.loc.gov [127.0.0.1]) by c4bappps02.loc.gov (8.16.0.43/8.16.0.43) with SMTP id 1BLFa0mb171310; Tue, 21 Dec 2021 10:37:44 -0500 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=loc.gov; h=from : to : subject : date : message-id : references : in-reply-to : content-type : mime-version; s=july2020; bh=atr+ilEZjRNzoJlONp7dbaSdRiMU2sbBndOMJM5rPdw=; b=GGtFFrt9gRcdfjlZvkAH/LGsOlYVx178yYjzb6eK48f+hQ378KEOE5NmUb65ELP9Ii2e YWzBPnyn0uIy7ER0GTwDz6eXSueCTG+3wGOfDhvdTLO1DuGeyX1SyCn0MKNvmJfuhk2t 7oeIsWqyv0pRIrMi2fQBXK9KyEzUt5uTfPlJL6h21L0q4BAdye34AQhL0xyLBwjh1t3K tfVCDOXKmD+9EUjLkyWDu4MG7Bd4MWfCywZvi+8L5hux0sWMwD3Px4E4NRgOLFCZHd5Q iD9Ih5SVNpOq6PdBQegqMhpVzlM7hNz4V0FNfU07hHo1zshxaD8AHxNbIhbWTFdksUaL 6A== Received: from mail2.loc.gov (acfxex01.loc.gov [140.147.237.145]) by c4bappps02.loc.gov with ESMTP id 3d3fgc09fh-1 (version=TLSv1.2 cipher=ECDHE-RSA-AES256-SHA384 bits=256 verify=NOT); Tue, 21 Dec 2021 10:37:43 -0500 Received: from ACFXEX04.LCDS.LOC.GOV (140.147.237.158) by ACFXEX01.LCDS.LOC.GOV (140.147.237.145) with Microsoft SMTP Server (TLS) id 15.0.1497.26; Tue, 21 Dec 2021 10:37:42 -0500 Received: from ACFXEX04.LCDS.LOC.GOV ([140.147.237.158]) by acfxex04.LCDS.LOC.GOV ([140.147.237.158]) with mapi id 15.00.1497.026; Tue, 21 Dec 2021 10:37:43 -0500 From: "Dai, Tino" To: Holger Jakobs , "pgsql-admin@lists.postgresql.org" , "Gogala, Mladen" Subject: Re: Reconfiguring active PostgreSQL instance Thread-Topic: Reconfiguring active PostgreSQL instance Thread-Index: Adf2b2dParKAXJpCRDK5HejW2vYDzAAN2+EAAAArzwAAAGfdgAAANyKA//+s54A= Date: Tue, 21 Dec 2021 15:37:42 +0000 Message-ID: <1640101158583.11955@loc.gov> References: <9b0a5879-1ad9-98db-e18b-5576542dad6b@gmail.com>, In-Reply-To: Accept-Language: en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: x-ms-exchange-transport-fromentityheader: Hosted x-originating-ip: [140.147.111.5] Content-Type: multipart/alternative; boundary="_000_164010115858311955locgov_" MIME-Version: 1.0 X-Proofpoint-GUID: E1MOmpF0nXXKXm3sStU4jhYS3iOE9qqn X-Proofpoint-ORIG-GUID: E1MOmpF0nXXKXm3sStU4jhYS3iOE9qqn X-Proofpoint-Virus-Version: vendor=fsecure engine=2.50.10434:6.0.425,18.0.790 definitions=2021-12-21_04:2021-12-21,2021-12-21 signatures=0 X-Proofpoint-Spam-Details: rule=outbound_notspam policy=outbound score=0 spamscore=0 phishscore=0 mlxlogscore=999 bulkscore=0 suspectscore=0 mlxscore=0 malwarescore=0 adultscore=0 lowpriorityscore=0 classifier=spam adjust=0 reason=mlx scancount=1 engine=8.12.0-2110150000 definitions=main-2112210074 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --_000_164010115858311955locgov_ Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Is it AIX? The /u01 feels like AIX. -T ________________________________ From: Holger Jakobs 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 sh= ould 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" : 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=3D> create extension "uuid-ossp" ; ERROR: could not open extension control file "/u01/app/postgres/product/po= stgresql-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 Sent: Tuesday, December 21, 2021 10:11 AM To: Reno, Natalie Cc: Pgsql-admin Subject: Re: Reconfiguring active PostgreSQL instance This email originated from an EXTERNAL sender to CCHMC. Proceed with cautio= n when replying, opening attachments, or clicking links in this message. On Tue, Dec 21, 2021, 06:42 Reno, Natalie > wrote: We provide a PostgreSQL instance that we configure ourselves. An applicatio= n is now needing the uuid-ossp extension which requires the -with-uuid=3Dos= sp 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 grum= py 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 - --_000_164010115858311955locgov_ Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable

Is it AIX? The /u01 feels like AIX. -T

From: Holger Jakobs <hol= ger@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=3D> create extension "uuid-ossp&= quot; ;

ERROR:  could not open extension control file &= quot;/u01/app/postgres/product/postgresql-12.8/data/extension/uuid-ossp.con= trol": No such file or directory

 

Should I copy the control file over from the contrib= directory?

 

Natalie Reno (she/her/hers)

Lead Database Administrator<= /p>

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, openi= ng 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=3Dossp flag added to the configuration.=  

 

So what happens when you execute create extension?

 

David J.--

This email has originated from an extremely s= uspect and sometimes very grumpy sender. Proceed with extreme caution and u= se 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 -
--_000_164010115858311955locgov_--