Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1mzkBh-0004wo-5Y for pgsql-admin@arkaria.postgresql.org; Tue, 21 Dec 2021 18:48:37 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1mzkBg-0002o8-0L for pgsql-admin@arkaria.postgresql.org; Tue, 21 Dec 2021 18:48:36 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1mzkBf-0002ny-Kn for pgsql-admin@lists.postgresql.org; Tue, 21 Dec 2021 18:48:35 +0000 Received: from mout.kundenserver.de ([212.227.126.130]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1mzkBb-0000kh-1f for pgsql-admin@lists.postgresql.org; Tue, 21 Dec 2021 18:48:34 +0000 Received: from ANAT ([78.197.128.121]) by mrelayeu.kundenserver.de (mreue010 [212.227.15.168]) with ESMTPSA (Nemesis) id 1MqbDs-1mdrkh2lCS-00mdtU; Tue, 21 Dec 2021 19:48:27 +0100 From: "Michel SALAIS" To: "'Reno, Natalie'" , References: In-Reply-To: Subject: RE: Reconfiguring active PostgreSQL instance Date: Tue, 21 Dec 2021 19:48:26 +0100 Message-ID: <004401d7f69b$5758cc40$060a64c0$@msym.fr> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0045_01D7F6A3.B91FA540" X-Mailer: Microsoft Outlook 16.0 Thread-Index: AQFEGE1AUTR0oxJNUrk3B4UKGb+lla1lA1Cw Content-Language: fr X-Provags-ID: V03:K1:GXqA48xjtWsy6krbIEwzsy+HqOUJFNqeb4gPfSX9HtSe53MWTnP 3x/rqNVIQmngy5egwvfgBE1qvguQ/w4WUyzy3VE7shDMlg4b+meK7h0y+w/Wvy6kfQU+CK8 23cRv+s+m68YlorCDArqkolJ1U0aEBVVj5MTApd6cgJ+IlF1pQhqchtwLyyDOxUXvHvP09i m2+pxqOakhBrFjfLd+Fzw== X-Spam-Flag: NO X-UI-Out-Filterresults: notjunk:1;V03:K0:f0k8BL/3coc=:PI2xrOD5WtG0UMmihZl9kl bVczhttu0mWYJRO2mBxZlAuKwaPJJqi6sElxEoOxX68zzbeXev9L13DBRcLLC42M3pRk6dOi+ yvvrUlPV5BlmxvxqxUqXJ9XxzXfNsCfyqDLDMOWgQfnHIavGoP60SrHhc+Cgc/w1ntYfQMAal YnrNVQcEXn6cXdZiyXXdltEY2qKYrTJBXwoLJ90fveXriOxyiGamUU5Zm0pH1CbecGKV147zq VY+WTW610al9anXiRH0gVN0XVAvWXzr6J42IIGqmZAPATK0gIP01xsSPz4chrL2vPbj5IW9Ng BZ6dJbXsw+/M1nBij4XJQ1ixmK5Qoo4Jl9KUHpFZ4BNAqJdHLt1XTKJ3HpZHErF+1ReVxEeG+ p9f9sSz0omHCBOp51WPxanPiPl17+/f5pxRskEdUWR+tPflHPLimNgYDd4jE3ANFpqTk863t7 6JQFJlKUQ9HUkJWN6wyvhjgPqXDHWZ10iaLDCz02S3fZC92fWjqIO47hN3gfi+NvMUliX31kY rBSqeb4t4j73jHMlIEgXGhwlpwMi5l9PM+YMYtrrlXKFIw3ZvNCMOn+Qoa1aD8kDSJmyK5zrf 4Lc3N6BYVu++SAcdetl8hEKuT6GXBp9ssoZJxWH1XmW2BdNai592lsNrfQHNWJK3LNDDzo0Nb eHc9Lpr+qaGJR7exZqCLUqDzaCGEwT/vBAuiEA1IUCs2K2/YbgJJRYimXLMjBm8nET3A= List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk This is a multipart message in MIME format. ------=_NextPart_000_0045_01D7F6A3.B91FA540 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hi, =20 Have you done =93at least=94 the following =20 cd /u01/app/postgres/product/postgresql/contrib/uuid-ossp make make install =20 Michel SALAIS De : Reno, Natalie =20 Envoy=E9 : mardi 21 d=E9cembre 2021 14:43 =C0 : pgsql-admin@lists.postgresql.org Objet : Reconfiguring active PostgreSQL instance =20 We provide a PostgreSQL instance that we configure ourselves. An = application is now needing the uuid-ossp extension which requires the = =96with-uuid=3Dossp 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? =20 Here is what we run for each install: =20 ./configure --prefix=3D${POSTGRES_DIR} = --bindir=3D${POSTGRES_DIR}/bin --sbindir=3D${POSTGRES_DIR}/sbin --libexecdir=3D${POSTGRES_DIR}/libexec --sysconfdir=3D${POSTGRES_DIR}/etc --libdir=3D${POSTGRES_DIR}/lib --includedir=3D${POSTGRES_DIR}/include --datadir=3D${POSTGRES_DIR}/data --mandir=3D${POSTGRES_DIR}/man --docdir=3D${POSTGRES_DIR}/doc --htmldir=3D${POSTGRES_DIR}/doc --dvidir=3D${POSTGRES_DIR}/doc --pdfdir=3D${POSTGRES_DIR}/doc --psdir=3D${POSTGRES_DIR}/doc --with-perl --with-systemd --with-pam =20 make world make install make install-docs make install-world =20 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 =20 Natalie Reno (she/her/hers) Lead Database Administrator Database Infrastructure Team Research IT Cincinnati Children's Hospital natalie.reno@cchmc.org 513.803.5370 =20 ------=_NextPart_000_0045_01D7F6A3.B91FA540 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable

Hi,

 

Have you done “at = least” the following

 

cd /u01/app/postgres/product/postgresql/contrib/uuid-ossp<= /o:p>

make

make install

 

Michel = SALAIS

De : Reno, Natalie = <Natalie.Reno@cchmc.org>
Envoy=E9 : mardi 21 = d=E9cembre 2021 14:43
=C0 : = pgsql-admin@lists.postgresql.org
Objet : Reconfiguring = active PostgreSQL instance

 

We provide a PostgreSQL instance that we configure = ourselves. An application is now needing the uuid-ossp extension which = requires the –with-uuid=3Dossp 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=3D${POSTGRES_DIR} --bindir=3D${POSTGRES_DIR}/bin = --sbindir=3D${POSTGRES_DIR}/sbin --libexecdir=3D${POSTGRES_DIR}/libexec = --sysconfdir=3D${POSTGRES_DIR}/etc --libdir=3D${POSTGRES_DIR}/lib = --includedir=3D${POSTGRES_DIR}/include --datadir=3D${POSTGRES_DIR}/data = --mandir=3D${POSTGRES_DIR}/man --docdir=3D${POSTGRES_DIR}/doc = --htmldir=3D${POSTGRES_DIR}/doc --dvidir=3D${POSTGRES_DIR}/doc = --pdfdir=3D${POSTGRES_DIR}/doc --psdir=3D${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<= /p>

513.803.5370

 

------=_NextPart_000_0045_01D7F6A3.B91FA540--