From: Achilleas Mantzios <achill@matrix.gatewaynet.com>
To: pgsql-admin@lists.postgresql.org
Subject: Re: Reconfiguring active PostgreSQL instance
Date: Tue, 21 Dec 2021 17:08:17 +0200
Message-ID: <eba93c26-ea88-718f-d7cf-670776e51c16@matrix.gatewaynet.com> (raw)
In-Reply-To: <5cc502e1-db7a-bdeb-847b-3bf8e483d016@matrix.gatewaynet.com>
References: <BL0PR01MB4148FDEC6C7E711E71279D708A7C9@BL0PR01MB4148.prod.exchangelabs.com>
<5cc502e1-db7a-bdeb-847b-3bf8e483d016@matrix.gatewaynet.com>
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.reno@cchmc.org <mailto:natalie.reno@cchmc.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
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: <eba93c26-ea88-718f-d7cf-670776e51c16@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