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 1mzh2y-0004O8-QX for pgsql-admin@arkaria.postgresql.org; Tue, 21 Dec 2021 15:27:24 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1mzh2x-00005R-4t for pgsql-admin@arkaria.postgresql.org; Tue, 21 Dec 2021 15:27:23 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1mzh2w-00005H-NQ for pgsql-admin@lists.postgresql.org; Tue, 21 Dec 2021 15:27:22 +0000 Received: from mail-wm1-x330.google.com ([2a00:1450:4864:20::330]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1mzh2t-0007eM-Vg for pgsql-admin@lists.postgresql.org; Tue, 21 Dec 2021 15:27:22 +0000 Received: by mail-wm1-x330.google.com with SMTP id b186-20020a1c1bc3000000b00345734afe78so2362861wmb.0 for ; Tue, 21 Dec 2021 07:27:19 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20210112; h=message-id:date:mime-version:user-agent:subject:content-language:to :references:from:in-reply-to; bh=LlJSUMmJw3T/vjH0HEwI9Xz6lU+gS3HKEWX7jpxfkRs=; b=C0ZfwU307Iya+gtsxgKeiXkSh0BAnW2gjgqz+2WOxoqPjcNeHXWo5twIISbfGx1vck bBPFv2dmz+T7QgQP8uSs7GG4ITt5SO4vxYqUfXV0TdTU1UCUGCVYEdcDvGDOHIpEywFN 5h8TStyWsDxIWteXkJgr+0uDA4ZPFTlqf6v2zEtcZvbRV2El+KByzTuYSdYIOwQGyfXb xPUwnFvtS8HMWqp53LDl2kfplWVrbUbd9llqgDS6ijRW6OVm2zc/xaSO4zqpQFOjLxn9 oPHA4p7lYH21wtpo+QRbGdC+idrzwVU0G3W699d2nKhwgZ2fotRpW+sk1JlhnT3TElkS 78ag== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; h=x-gm-message-state:message-id:date:mime-version:user-agent:subject :content-language:to:references:from:in-reply-to; bh=LlJSUMmJw3T/vjH0HEwI9Xz6lU+gS3HKEWX7jpxfkRs=; b=rANy0o0NSlWzpjeoNwAtw/v6Tt4pMiRTR8I8Dkp5QF2SBCWKQY3fl2Sp5wFlLqJbV4 GOEEzukK5FusicgY9xcmcDqvvlTeyTZCVR3+q1225d017ttojjAfFVeUzRzPhrkWUgnJ ucr/HAOwVPki2ELylsENJ3A93aB9uqYyup8MGBhUlw33ccWGHdVVbruulDJHW4Gi/6+U 4uxpYbgbIiOKTaGmL3ApnN1arR6eCtA2TCmPHSb+hfIXzIV9svOc317PXrlZ9RVQx1e9 fqWxTxOSI+dQ13/kULDLpIoTBG3Usexhw0siDV7TB0uA3cXn5TUl7O/g6Em7+mfe20kY VG0Q== X-Gm-Message-State: AOAM531r5wKhEE8ciiBlb26rwoJpHa/2MMWu185VjVvZ2b+b3qoM8tDO lFxTRaZ3Y641rNLas+ulbYqUgpUDOdQCTw== X-Google-Smtp-Source: ABdhPJxKvLWwxnZ+UcH+pxMoLrtuDuXqnXwYDpxNnyv7q2lOnOkpJTLdT2U2usjCrJgCRGPYNaNvIw== X-Received: by 2002:a05:600c:3ac5:: with SMTP id d5mr3173809wms.32.1640100437123; Tue, 21 Dec 2021 07:27:17 -0800 (PST) Received: from ?IPV6:2a05:4f46:e06:2000:c1f8:85a9:b9d:146d? ([2a05:4f46:e06:2000:c1f8:85a9:b9d:146d]) by smtp.gmail.com with ESMTPSA id w11sm8579156wrn.65.2021.12.21.07.27.16 for (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Tue, 21 Dec 2021 07:27:16 -0800 (PST) Content-Type: multipart/alternative; boundary="------------DJDZAEiBqZnXvtxMM6XAUQpY" Message-ID: <9b0a5879-1ad9-98db-e18b-5576542dad6b@gmail.com> Date: Tue, 21 Dec 2021 10:27:17 -0500 MIME-Version: 1.0 User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:91.0) Gecko/20100101 Thunderbird/91.3.2 Subject: Re: Reconfiguring active PostgreSQL instance Content-Language: en-US To: pgsql-admin@lists.postgresql.org References: From: "Gogala, Mladen" In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk This is a multi-part message in MIME format. --------------DJDZAEiBqZnXvtxMM6XAUQpY Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 8bit 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 > *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 > caution 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 > 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 --------------DJDZAEiBqZnXvtxMM6XAUQpY Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: 8bit

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
--------------DJDZAEiBqZnXvtxMM6XAUQpY--