Reconfiguring active PostgreSQL instance

From: "Reno, Natalie" <Natalie(dot)Reno(at)cchmc(dot)org>
To: "pgsql-admin(at)lists(dot)postgresql(dot)org" <pgsql-admin(at)lists(dot)postgresql(dot)org>
Subject: Reconfiguring active PostgreSQL instance
Date: 2021-12-21 13:42:41
Message-ID: BL0PR01MB4148FDEC6C7E711E71279D708A7C9@BL0PR01MB4148.prod.exchangelabs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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?

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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Holger Jakobs 2021-12-21 13:54:21 Re: Steps to enable SSL Enable
Previous Message Daulat 2021-12-21 13:36:31 Steps to enable SSL Enable