Re: Reconfiguring active PostgreSQL instance

On 21/12/21 4:00 μ.μ., Achilleas Mantzios wrote:
> On 21/12/21 3: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. When we did
>> the original configuration, we did the entire world which means the libraries are available. Is there any way to add this to the configuration without having to re-run the make and installs? Or is
>> there a way around this like copying the .sql and .lib files to the appropriate directories? Or can the configure statement be run again with just the new flag?
>>
> My gut is telling me you won't need to recompile. (since you are compiling from the source tree, with the source include files), but you need to check.
> Why don't you give it a try the easy way first? Do you have a test system?
confirmed, with 11.x , ossp-uuid-1.6.2_9 and FreeBSD 11.4
Side note: you might to play (unset) USE_PGXS
>>
>> Here is what we run for each install:
>>
>>      ./configure --prefix=${POSTGRES_DIR} --bindir=${POSTGRES_DIR}/bin --sbindir=${POSTGRES_DIR}/sbin --libexecdir=${POSTGRES_DIR}/libexec --sysconfdir=${POSTGRES_DIR}/etc
>> --libdir=${POSTGRES_DIR}/lib --includedir=${POSTGRES_DIR}/include --datadir=${POSTGRES_DIR}/data --mandir=${POSTGRES_DIR}/man --docdir=${POSTGRES_DIR}/doc --htmldir=${POSTGRES_DIR}/doc
>> --dvidir=${POSTGRES_DIR}/doc --pdfdir=${POSTGRES_DIR}/doc --psdir=${POSTGRES_DIR}/doc --with-perl  --with-systemd --with-pam
>>
>>    make world
>>
>>    make install
>>
>>    make install-docs
>>
>>    make install-world
>>
>> Here is what is in the contrib directory:
>>
>> /u01/app/postgres/product/postgresql/contrib/uuid-ossp>ls
>>
>> expected/  Makefile  sql/ uuid-ossp--1.0--1.1.sql  uuid-ossp--1.1.sql  uuid-ossp.c uuid-ossp.control  uuid-ossp--unpackaged--1.0.sql
>>
>> */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
>>
>
>
> --
> Achilleas Mantzios
> DBA, Analyst, IT Lead
> IT DEPT
> Dynacom Tankers Mgmt

--
Achilleas Mantzios
DBA, Analyst, IT Lead
IT DEPT
Dynacom Tankers Mgmt