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 1mzmgr-0002TC-RF for pgsql-admin@arkaria.postgresql.org; Tue, 21 Dec 2021 21:28:58 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1mzmgq-0007Tw-Mr for pgsql-admin@arkaria.postgresql.org; Tue, 21 Dec 2021 21:28:56 +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 1mzmgq-0007Tn-AD for pgsql-admin@lists.postgresql.org; Tue, 21 Dec 2021 21:28:56 +0000 Received: from hermes.gatewaynet.com ([193.92.121.98]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1mzmgj-00024O-At for pgsql-admin@lists.postgresql.org; Tue, 21 Dec 2021 21:28:55 +0000 Received: from hercules.internal.net (hercules.internal.net [10.9.200.8]) by hermes.gatewaynet.com (8.15.2/8.15.2/Debian-8+deb9u1) with ESMTP id 1BLLSjDI002570 for ; Tue, 21 Dec 2021 23:28:45 +0200 Received: from [10.9.251.249] (dcmchgw.internal.net [10.9.0.1]) by hercules.internal.net (Postfix) with ESMTP id 534D2E80EE for ; Tue, 21 Dec 2021 23:28:44 +0200 (EET) Subject: Re: Reconfiguring active PostgreSQL instance To: pgsql-admin@lists.postgresql.org References: <9b0a5879-1ad9-98db-e18b-5576542dad6b@gmail.com> <1640101158583.11955@loc.gov> From: Achilleas Mantzios Message-ID: <117620e1-cb7c-c8e8-d057-3513d9d14dc8@matrix.gatewaynet.com> Date: Tue, 21 Dec 2021 23:28:44 +0200 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:78.0) Gecko/20100101 Thunderbird/78.14.0 MIME-Version: 1.0 In-Reply-To: Content-Type: multipart/alternative; boundary="------------12774A293BA6ECB9F493DCFD" Content-Language: en-US X-Virus-Scanned: clamav-milter 0.102.4 at hermes X-Virus-Status: Clean X-Spam-Status: No, score=0.5 required=5.0 tests=ALL_TRUSTED,DYN_HAM_SIGNAT1, DYN_HAM_SIGNAT2,DYN_HAM_SIGNAT_L1,HTML_FONT_LOW_CONTRAST,HTML_MESSAGE, TW_PG,TW_UU,URIBL_BLOCKED autolearn=no autolearn_force=no version=3.4.2 X-Spam-Checker-Version: SpamAssassin 3.4.2 (2018-09-13) on hermes.gatewaynet.com 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. --------------12774A293BA6ECB9F493DCFD Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 8bit Στις 21/12/21 6:00 μ.μ., ο/η Reno, Natalie έγραψε: > > This is on Linux. It is a custom install. We don’t use RPMs but the > tar ball of the binaries. This is why we have the config file when we > create the software. > I gave you the solution in a previous mail. You dont need to reinstall postgresql. You just ./configure --what-ever and then go straight to compile and install (make install) the contrib module the usual way, (as root) after you disable USE_PGXS. Did you try that? > */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:* Dai, Tino > *Sent:* Tuesday, December 21, 2021 10:38 AM > *To:* Holger Jakobs ; > pgsql-admin@lists.postgresql.org; Gogala, Mladen > *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.* > > 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 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" > >: > > 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 > > > -- > Holger Jakobs, Bergisch Gladbach > +49 178 9759012 > - sent from mobile, therefore short - > --------------12774A293BA6ECB9F493DCFD Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: 8bit


Στις 21/12/21 6:00 μ.μ., ο/η Reno, Natalie έγραψε:

This is on Linux. It is a custom install. We don’t use RPMs but the tar ball of the binaries. This is why we have the config file when we create the software.

I gave you the solution in a previous mail. You dont need to reinstall postgresql. You just ./configure --what-ever and then go straight to compile and install (make install) the contrib module the usual way, (as root) after you disable USE_PGXS.

Did you try that?

 

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: Dai, Tino <tdai@loc.gov>
Sent: Tuesday, December 21, 2021 10:38 AM
To: Holger Jakobs <holger@jakobs.com>; pgsql-admin@lists.postgresql.org; Gogala, Mladen <gogala.mladen@gmail.com>
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.

 

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

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

--
Holger Jakobs, Bergisch Gladbach
+49 178 9759012
- sent from mobile, therefore short -

--------------12774A293BA6ECB9F493DCFD--