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 1mzfPs-0000pN-1c for pgsql-admin@arkaria.postgresql.org; Tue, 21 Dec 2021 13:42:56 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1mzfPq-0001f0-Bt for pgsql-admin@arkaria.postgresql.org; Tue, 21 Dec 2021 13:42:54 +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 1mzfPp-0001eq-Jp for pgsql-admin@lists.postgresql.org; Tue, 21 Dec 2021 13:42:54 +0000 Received: from mail-bn8nam08on2136.outbound.protection.outlook.com ([40.107.100.136] helo=NAM04-BN8-obe.outbound.protection.outlook.com) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1mzfPh-0006o6-8Z for pgsql-admin@lists.postgresql.org; Tue, 21 Dec 2021 13:42:52 +0000 ARC-Seal: i=1; a=rsa-sha256; s=arcselector9901; d=microsoft.com; cv=none; b=QDRO2yYren158u7iM0FEqoCf1Ha+bCKqEp9BLkmquDtXKO0UnMw4MQJPIfl2j19v3w+ND4iD51sqjKL7oQN07luxZKWHuzexR31zw+XjYW/QQAHVVxBaMZD4uRCZoE3xvwVPXvtsEorza+slrElOIIWFZUJEJDtH+Wj86nNr5i46bTClh8yhWK3LjnCGr84dsP505MhxDBhAOXObBGdpJg+VaIph7iuiis/jLG8+CMVKiDjz1+hk7J7eW99koroaRuXj36II4QEh/TtnoyA8QltBtdq1jzwpCsRC4jKXn+l5DWjhuuOZ01r4hxTJFxHiIEgcb1aE9wzjJnFQO+Dpmg== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=microsoft.com; s=arcselector9901; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version:X-MS-Exchange-AntiSpam-MessageData-ChunkCount:X-MS-Exchange-AntiSpam-MessageData-0:X-MS-Exchange-AntiSpam-MessageData-1; bh=/gqhFMclIxrUzuCLwx+g+VEb3N+VP7Ua6rH2MKxd3xw=; b=hCcW59Qy1I3LrvAy3yaHjUNSGLD674IhsUHFgfFqC6fK2ZoDuEfDmN98hG6+6TlfGwv7VG8P8jEHcPRIjtInIn1r3AbELXiYb/yZYYjt6hlPpk6ndf03jeUtCBlRhtCr9aiQ55Htnqa7u4uUt6oTH80DRs8G4QbCi2YuunozwOCwE146zBa0EzRxxbwQBs63ZVvHgrENxkzjFFU7PoMkWB58fabN2B5YxiypYOSDsVFvf7vbnL57RVJqRd3uM1h3zGyQpfU9ANJvsWcd3YS5giMr2J7yjBfHiPy5WZ1nOkkfC/yHi9uHAqR0M8+RDpw6pCfrz2Xrv+CjVVEQDDCsRg== ARC-Authentication-Results: i=1; mx.microsoft.com 1; spf=pass smtp.mailfrom=cchmc.org; dmarc=pass action=none header.from=cchmc.org; dkim=pass header.d=cchmc.org; arc=none DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=cchmc.org; s=selector2; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version:X-MS-Exchange-SenderADCheck; bh=/gqhFMclIxrUzuCLwx+g+VEb3N+VP7Ua6rH2MKxd3xw=; b=Y6yJceQYo0DRZz98WSKO6dSYMam76eTAsZQMdtc617HbnpJks8Mjn29i5GEgTe970xmi+GYvYki81EgUPdeo323lvpsL0zwBp9Aqtsx/jokS7IRMT5ZF7oY3KgMGEzaODSBqjMKRS+ywnmsPoE2kpmIs+KnfQbA+K5kweZhMM1o= Received: from BL0PR01MB4148.prod.exchangelabs.com (2603:10b6:208:44::12) by BL3PR01MB7177.prod.exchangelabs.com (2603:10b6:208:344::22) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.20.4801.14; Tue, 21 Dec 2021 13:42:42 +0000 Received: from BL0PR01MB4148.prod.exchangelabs.com ([fe80::b4b8:c07b:1496:2ee0]) by BL0PR01MB4148.prod.exchangelabs.com ([fe80::b4b8:c07b:1496:2ee0%7]) with mapi id 15.20.4801.020; Tue, 21 Dec 2021 13:42:42 +0000 From: "Reno, Natalie" To: "pgsql-admin@lists.postgresql.org" Subject: Reconfiguring active PostgreSQL instance Thread-Topic: Reconfiguring active PostgreSQL instance Thread-Index: Adf2b2dParKAXJpCRDK5HejW2vYDzA== Date: Tue, 21 Dec 2021 13:42:41 +0000 Message-ID: Accept-Language: en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: authentication-results: dkim=none (message not signed) header.d=none;dmarc=none action=none header.from=cchmc.org; x-ms-publictraffictype: Email x-ms-office365-filtering-correlation-id: a78da6c6-506b-4a92-cd79-08d9c487c308 x-ms-traffictypediagnostic: BL3PR01MB7177:EE_ x-microsoft-antispam-prvs: x-ms-oob-tlc-oobclassifiers: OLM:8882; x-ms-exchange-senderadcheck: 1 x-ms-exchange-antispam-relay: 0 x-microsoft-antispam: BCL:0; x-microsoft-antispam-message-info: z9ekW/Az9y/6wGosLzBlmb3MtVLD61ph1gzfrJAvpzMNICaWRude/JJyYtvdgnWsfBZkITEtTA/0CjtaUjGpXhqut9YjattswktwjSInG6pzwwmjVThHDcQ3dV45TttRqBqBZw3MVKjTfULPfO1dGjaCtUq8INjw3ndA7yWLghOtaJHuPlcJV1lx3t1qxCf1k6BrI2NurjqpQRVEflEcjOyVGW/S5/2aRbkgXjZJeGif12ouIrMrTBj066k5KsU6Vaop99JSxhLNbKGbb7iKJvifxociiy8GREImdtU/s8II6QG9V3mxRQNnBEGtSLrr2+3pKbRClaBGnw26CaOWIenAs1N51RxTm/cPG2J0PTSEnfTJBO31sWVIch7KtO4oexbF53IPqlzyPMl/3Vt8YLKlQlhv8FPixqLuMQTgSz4333G3WedNzK0HHtDzFpKbxtsYKdD+JyGPLLwVdCRoRNySrIq2y1BpIGscTXPgpvNQRER2Djh3CKyvdBsbZ2Suo18PlrWmGxubfWDK6HWYVyi5VZItYbXg8NpE4Sx3r7bxNDfyOX9F/SwOwRciD+xJkMt4D+kp17nF8fV7Yutac5FB9BSD721b2qGiPYY/8Hej2THn3pNcjI7mA1P3In2qtv+v2+swY5BU+m/GGwXCswhRYkZLGA8DbltvhyJzXNm44wdMjUuliBM5Vs36xEe+G/I6TOpyopyx0t7sMtxT0Q== x-forefront-antispam-report: CIP:255.255.255.255;CTRY:;LANG:en;SCL:1;SRV:;IPV:NLI;SFV:NSPM;H:BL0PR01MB4148.prod.exchangelabs.com;PTR:;CAT:NONE;SFS:(4636009)(366004)(83380400001)(5660300002)(6916009)(186003)(33656002)(9686003)(508600001)(316002)(26005)(2906002)(7696005)(66476007)(76116006)(66946007)(86362001)(8936002)(66556008)(55016003)(66446008)(8676002)(38100700002)(3480700007)(52536014)(71200400001)(122000001)(40140700001)(38070700005)(6506007)(64756008);DIR:OUT;SFP:1102; x-ms-exchange-antispam-messagedata-chunkcount: 1 x-ms-exchange-antispam-messagedata-0: =?us-ascii?Q?QsKwUIrxOi+TUmByoeAS0zT370iauRZBuUIF7NJLbJCwA056jMpBW/Vvnb/h?= =?us-ascii?Q?ered/v4iXP86T2M58MaTFjDbmBhbdPyJAm3JEIFDzPluQGQdIKqcqVSB4Iq8?= =?us-ascii?Q?9xMeXBAr1HJHoKKjZDxMf2smga9ktU7fmL0tkqpF7Nv2BmQ/IoXxyPYAcVDh?= =?us-ascii?Q?yXq+oVrwL3BIQLnitz2Jb1rObDs3K29nUiJ2v6Sfb8LQ8qjw2wscfH6pwvkr?= =?us-ascii?Q?oTTSaqVx5hLOuXTG9OLUyWa7PTYd+9GLA+HTPYkbAiohJ4kf5G2mWqtGpizR?= =?us-ascii?Q?uC4tQy0iodtBfhQD97CZhmBgrZUnxbJXRsQqg4g9wsmVeSA6jK7EvDci2FFi?= =?us-ascii?Q?xZapDnG3UzYH3httcvEndiSP9wS9NvBVZYHKNPtJo8I+bXxN7ujus9qJmQCr?= =?us-ascii?Q?558XgYAxg7nd5EJ3Uz9pVunlOGIlwZNqwAWbOPzbDls2FdM3/4LPhK82wM1d?= =?us-ascii?Q?+Zk88IWKQHCgQtVdM2f+DLjlgGFfw+cCs7YgweCM6qb+sOH1VCUfMARBpjfW?= =?us-ascii?Q?835tTqJe17jVE7TFPpEi0QK8v8GGtJ/TGCP3Y7HhCBjAHn3FFVcC3+lQrE57?= =?us-ascii?Q?xTEuU1sY90dFnRf2UtERudwBPN87JVWSu0h0EL+zf0TDw9ROZqUOaSMz6JYR?= =?us-ascii?Q?MtKLtCd1fHmMWN6E8+XrntW8ygt2T1WGOL3nPEYfHMUwVEqpURPhGLy7T30j?= =?us-ascii?Q?gKAtqS7GE0GVmYf1o6wcCpLt8pGWRud1dVwls65ZQbamxsQYRvsWO82WS08C?= =?us-ascii?Q?3+kFib9+65LAwGfVdPuOurWH/g2Pvsj2gwzxr0C8OYe/7sW2lzkuW8NY+32s?= =?us-ascii?Q?DYJiq4pOw2qR02Yqu9pnnEzSKjDz2LS6V7Cf0gUOKmo0HsiIif7UBKlaZVAx?= =?us-ascii?Q?5mKuEU84qJTCMDKe/iuxL3K2LcVpYhOWv2mTK5IJwzwHo/5m4o4bhKCRzbtT?= =?us-ascii?Q?jF55BduwsFd1SiMo93H7dFgsyHaCgym+IZ0jsOHDSnVCNPZ5MhzAYc9XrZmU?= =?us-ascii?Q?77FOGoa+6tT+CbZlmaWepvxsQ3uGu9yZm9slmtFyEzAYPzmxCXMJDbuWdBZN?= =?us-ascii?Q?ur03P8/o55G5QOMVTsoulssfNz9k3CVKHXccQJR/YmCdkS9tEjGyvTyx22UW?= =?us-ascii?Q?Ahmo2I4FKuMyUZKQGIRsMxZtSHNFE7/pIUbiixHG+U6Kcc8foGmJ37W0iqCG?= =?us-ascii?Q?t5L2wwCK/RxQBvdT0kmzh5sU0LZa0rMbpSdJDyh8Q0LhonFVNpv//+rjrLj2?= =?us-ascii?Q?d7kCkbWvKIM49a63/JQjpx5VUyB0eB/zdUyESFeMUZlL7aLCbci1KHe3/sRR?= =?us-ascii?Q?181VWtueN8gpD/Sxrz3F3Byl+LRJbA2TzWQMvCz0l45lU+0bmEC/uvGFSsMt?= =?us-ascii?Q?EhsP3S1Y6cFRMxR7h7sqcGFjHJyDKtxx9ipcbDH7qnGKgOquh3EM4STRS1MX?= =?us-ascii?Q?up5VvLwVFpm/nFnjWS/GDEAMhL4Ef4hiSGGTjGpL2sqbmfvoI0UyhJH3prhn?= =?us-ascii?Q?dj16+KHTFF0PqOJ3mKWsgX6b9eExPpBHxLMcpSKKVrrrtVllbf4NrDmPFF1t?= =?us-ascii?Q?5oNhmeg1kbNER3k63ApyuULwR0yDPmB9Pd/CFJJMH3W43LTLa4gUPxhY6gPD?= =?us-ascii?Q?Z/tha1JxZ1rr2AylFbrdxiI=3D?= Content-Type: multipart/alternative; boundary="_000_BL0PR01MB4148FDEC6C7E711E71279D708A7C9BL0PR01MB4148prod_" MIME-Version: 1.0 X-OriginatorOrg: cchmc.org X-MS-Exchange-CrossTenant-AuthAs: Internal X-MS-Exchange-CrossTenant-AuthSource: BL0PR01MB4148.prod.exchangelabs.com X-MS-Exchange-CrossTenant-Network-Message-Id: a78da6c6-506b-4a92-cd79-08d9c487c308 X-MS-Exchange-CrossTenant-originalarrivaltime: 21 Dec 2021 13:42:41.9524 (UTC) X-MS-Exchange-CrossTenant-fromentityheader: Hosted X-MS-Exchange-CrossTenant-id: 680254d4-278b-4aa1-aca8-c2600f79c533 X-MS-Exchange-CrossTenant-mailboxtype: HOSTED X-MS-Exchange-CrossTenant-userprincipalname: RTHkYkpn73NcdyAhiTiPLAfcSzvfpX52+LPeFvEu+cNLSHZF8c/hdFdTsnv8bXJCa01zjmXf4CvdLSyno0pmMw== X-MS-Exchange-Transport-CrossTenantHeadersStamped: BL3PR01MB7177 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --_000_BL0PR01MB4148FDEC6C7E711E71279D708A7C9BL0PR01MB4148prod_ Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable We provide a PostgreSQL instance that we configure ourselves. An applicatio= n is now needing the uuid-ossp extension which requires the -with-uuid=3Dos= sp 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 --s= ysconfdir=3D${POSTGRES_DIR}/etc --libdir=3D${POSTGRES_DIR}/lib --includedir= =3D${POSTGRES_DIR}/include --datadir=3D${POSTGRES_DIR}/data --mandir=3D${PO= STGRES_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 uui= d-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 513.803.5370 --_000_BL0PR01MB4148FDEC6C7E711E71279D708A7C9BL0PR01MB4148prod_ Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

We provide a PostgreSQL instance that we configure o= urselves. An application is now needing the uuid-ossp extension which requi= res the –with-uuid=3Dossp flag added to the configuration. When we di= d the original configuration, we did the entire world which means the libraries are available. Is there any way to add thi= s to the configuration without having to re-run the make and installs? Or i= s there a way around this like copying the .sql and .lib files to the appro= priate 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${PO= STGRES_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${POSTGRE= S_DIR}/doc --pdfdir=3D${POSTGRES_DIR}/doc --psdir=3D${POSTGRES_DIR}/doc --w= ith-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-os= sp>ls

expected/  Makefile  sql/  uuid-ossp-= -1.0--1.1.sql  uuid-ossp--1.1.sql  uuid-ossp.c  uuid-ossp.co= ntrol  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

513.803.5370

 

--_000_BL0PR01MB4148FDEC6C7E711E71279D708A7C9BL0PR01MB4148prod_--