From: Achilleas Mantzios <achill@matrix.gatewaynet.com>
To: pgsql-admin@lists.postgresql.org
Subject: Re: Reconfiguring active PostgreSQL instance
Date: Tue, 21 Dec 2021 23:28:44 +0200
Message-ID: <117620e1-cb7c-c8e8-d057-3513d9d14dc8@matrix.gatewaynet.com> (raw)
In-Reply-To: <BL0PR01MB41489710919036C8D35A55A98A7C9@BL0PR01MB4148.prod.exchangelabs.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>
<1640101158583.11955@loc.gov>
<BL0PR01MB41489710919036C8D35A55A98A7C9@BL0PR01MB4148.prod.exchangelabs.com>
Στις 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 <mailto: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 <mailto:holger@jakobs.com>>
> *Sent:* Tuesday, December 21, 2021 10:33 AM
> *To:* pgsql-admin@lists.postgresql.org
> <mailto: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 <mailto: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
> <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: achill@matrix.gatewaynet.com, pgsql-admin@lists.postgresql.org
Subject: Re: Reconfiguring active PostgreSQL instance
In-Reply-To: <117620e1-cb7c-c8e8-d057-3513d9d14dc8@matrix.gatewaynet.com>
* 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