Re: Reconfiguring active PostgreSQL instance

Στις 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(dot)reno(at)cchmc(dot)org <mailto:natalie(dot)reno(at)cchmc(dot)org>
>
> 513.803.5370
>
> *From:* Dai, Tino <tdai(at)loc(dot)gov>
> *Sent:* Tuesday, December 21, 2021 10:38 AM
> *To:* Holger Jakobs <holger(at)jakobs(dot)com>;
> pgsql-admin(at)lists(dot)postgresql(dot)org; Gogala, Mladen <gogala(dot)mladen(at)gmail(dot)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(at)jakobs(dot)com <mailto:holger(at)jakobs(dot)com>>
> *Sent:* Tuesday, December 21, 2021 10:33 AM
> *To:* pgsql-admin(at)lists(dot)postgresql(dot)org
> <mailto:pgsql-admin(at)lists(dot)postgresql(dot)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(dot)mladen(at)gmail(dot)com <mailto:gogala(dot)mladen(at)gmail(dot)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(dot)reno(at)cchmc(dot)org <mailto:natalie(dot)reno(at)cchmc(dot)org>
>
> 513.803.5370
>
> *From:*David G. Johnston <david(dot)g(dot)johnston(at)gmail(dot)com>
> <mailto:david(dot)g(dot)johnston(at)gmail(dot)com>
> *Sent:* Tuesday, December 21, 2021 10:11 AM
> *To:* Reno, Natalie <Natalie(dot)Reno(at)cchmc(dot)org>
> <mailto:Natalie(dot)Reno(at)cchmc(dot)org>
> *Cc:* Pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org>
> <mailto:pgsql-admin(at)lists(dot)postgresql(dot)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(dot)Reno(at)cchmc(dot)org <mailto:Natalie(dot)Reno(at)cchmc(dot)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 -
>