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
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 |