Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1tmj9d-009mdn-28 for pgsql-pkg-yum@arkaria.postgresql.org; Tue, 25 Feb 2025 00:50:33 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1tmj8d-00BQ5d-Qn for pgsql-pkg-yum@arkaria.postgresql.org; Tue, 25 Feb 2025 00:49:31 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1tmj8d-00BQ5V-GG for pgsql-pkg-yum@lists.postgresql.org; Tue, 25 Feb 2025 00:49:31 +0000 Received: from mail-japaneastazon11021092.outbound.protection.outlook.com ([52.101.125.92] helo=TYVP286CU001.outbound.protection.outlook.com) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1tmj8Z-000dZi-39 for pgsql-pkg-yum@lists.postgresql.org; Tue, 25 Feb 2025 00:49:30 +0000 ARC-Seal: i=1; a=rsa-sha256; s=arcselector10001; d=microsoft.com; cv=none; b=I47NGcGWHE74elWlyZcNItTXu9Y1z/3c4AlAKaUmu6VhKpjduqLchf3jC+tLhvFftEKrUK80/TQ9jGRrvRUGJ8uoZUIO4ZzVAwy5Gm3Zj7d0PpQ655UPfyMR8h+e7NOYJI54a6N+YWYd6iVXT5xRDR10iuhAp2t1k25fPTkvtCZ6OkSTgHLeDi/fNrs2nTmVjIfOmogRdcNdrfCSqNyF78vW8j8e3NsqN8PXKjVEaZRHHwXRg5qcSwFI1gJpdieFT7OOl5AlD9gRSN68C584eGSYcMC91pcvcLUPIMKKdjuxK7veW3twcHJm8bC93fyv8xhF1EtvcHj2KCM1F9QbXw== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=microsoft.com; s=arcselector10001; 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=2hjS46F7wApXHeCg3SoKCIW6XE4dclP3SNRZKBYPZdM=; b=YmguOjaYVvL+uzPJyG4QgJ/otTMO53xL7nGTy9NuwhQW3GDOpC68b1nld0IPzJgLSXz5HAUNCGtetiYWH4MxjXWBzMyjKaPq2weK+0j48tjGXF86gtFmXBEEIsdRxMPxPCGZ1nfq+l3UfAoC0G4AsWGYHEEF6T6xwLsAoMLhVlHHOSnsw9tOfVKYiZ9kjqB5aYKJ0JZx62ahe/QiPSsTqSXWy0Wg2EEk30kLRA4lq7jmF5DyV0JcRTVKQBuUtf7A7Fm/C6JMCdBd5RQFIiszowP2+HG/H5usNgGdhJLYhdUCUgXDHPjZOsYMDjXSVlT2v4evUU8zFTTkPJFYpfDHmg== ARC-Authentication-Results: i=1; mx.microsoft.com 1; spf=pass smtp.mailfrom=sraoss.co.jp; dmarc=pass action=none header.from=sraoss.co.jp; dkim=pass header.d=sraoss.co.jp; arc=none DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=sraoss.co.jp; s=selector1; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version:X-MS-Exchange-SenderADCheck; bh=2hjS46F7wApXHeCg3SoKCIW6XE4dclP3SNRZKBYPZdM=; b=li/9ci9pFdPJqhclrNknF+ksagp3RP5U0YOF1jzuynfr3zyVhUfXD34ZnogFtqN88HHUHwF4eoooYbIF6G/x4sLyeRgG1GUzuQHy+cfbMe/9OClI59kWxl3XkJ6BhA+GcUgOTr9qQs2NtypLwL9Dp04psW7/B3CfX/rUgBLguSES/XtKNe6jfqlGdN5dMdpSun0uFs6U1ELQ0l4tqwsFmy5gFAWk6QRlfXoH97ndfKj69Fmhhx07pLbyfvl8u+LuP5GQwkLwRufVqR/xyNYXo8sQckXYi/vJ/jL4FzVJY+SRrhykOiMTVjDuBvvAyDPGQQKP9JNecREwaVjrFWRSpw== Authentication-Results: dkim=none (message not signed) header.d=none;dmarc=none action=none header.from=sraoss.co.jp; Received: from TY3P286MB2691.JPNP286.PROD.OUTLOOK.COM (2603:1096:400:256::7) by OS9P286MB4699.JPNP286.PROD.OUTLOOK.COM (2603:1096:604:2f9::12) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.20.8466.20; Tue, 25 Feb 2025 00:49:22 +0000 Received: from TY3P286MB2691.JPNP286.PROD.OUTLOOK.COM ([fe80::60b3:c83c:40ea:52d8]) by TY3P286MB2691.JPNP286.PROD.OUTLOOK.COM ([fe80::60b3:c83c:40ea:52d8%6]) with mapi id 15.20.8466.016; Tue, 25 Feb 2025 00:49:21 +0000 Date: Tue, 25 Feb 2025 09:49:17 +0900 From: Tomoaki Sato To: Devrim =?UTF-8?B?R8O8bmTDvHo=?= Cc: pgsql-pkg-yum Subject: Re: Installing and Configuring PostgreSQL Extensions via RPMs Message-Id: <20250225094917.97cde5026068b11bebe34b21@sraoss.co.jp> In-Reply-To: <9c0137a3d349d8def7018d930a53cc8e21ce98e6.camel@gunduz.org> References: <9c0137a3d349d8def7018d930a53cc8e21ce98e6.camel@gunduz.org> X-Mailer: Sylpheed 3.8.0beta1 (GTK+ 2.24.30; i686-pc-mingw32) Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 8bit X-ClientProxiedBy: TYCP286CA0130.JPNP286.PROD.OUTLOOK.COM (2603:1096:400:2b6::12) To TY3P286MB2691.JPNP286.PROD.OUTLOOK.COM (2603:1096:400:256::7) MIME-Version: 1.0 X-MS-PublicTrafficType: Email X-MS-TrafficTypeDiagnostic: TY3P286MB2691:EE_|OS9P286MB4699:EE_ X-MS-Office365-Filtering-Correlation-Id: 7a340b74-6541-4da5-db92-08dd55363c8c X-MS-Exchange-SenderADCheck: 1 X-MS-Exchange-AntiSpam-Relay: 0 X-Microsoft-Antispam: BCL:0;ARA:13230040|376014|1800799024|366016|7053199007; X-Microsoft-Antispam-Message-Info: =?utf-8?B?NDNsSWhHYTE2bzZNalB4YWhPbmVTaFZOekNYSXJ4OThXczJwUlZVemthOFFq?= =?utf-8?B?NzNubk4xQzFkdHhVWXpqVERyYzFSeEZrVysvSnJUczJoNFNpVmVBamZWS1p4?= =?utf-8?B?QzgzK1VkMnJvaEh0VTE4VW10WDNZWlNYV1lyOHEvTS9qTkdCc3FET21URVJn?= =?utf-8?B?U0NHVEU2U0dla1BmZERCNU5rVCtMUWRMaEpVOTVxVzQ5WjVxbVFmdUlmWnB2?= =?utf-8?B?T216bWJKZ25jSmFCUmtLN2hmZWFlaVJoV3NvL09lSEY3SFFiZnlYYmRVTFpH?= =?utf-8?B?alJ4NVNmRnp0Z2RURU1QWHNDb0FtTnQzZXRHUDNWUVlqNGFqd010Y1ZpUXAz?= =?utf-8?B?Qkk3VDBTM2Z2ck9FN2NkbjVzbitmblZxek5sNzlORzBsYnd1WlJzWDJBaEhR?= =?utf-8?B?eGlVaWFESnJrVUpLSkUzem5WcFloWktPd3lmNXJtQTVXQ2hvcnpmcS9uVnE3?= =?utf-8?B?cTFjcWhiN1VMVjMrQW9iNE1hUHV3U1dub093VHRWSFByT0ZIbjlFQWxVa2x6?= =?utf-8?B?cHpvb1JlU2k3UVVUY1pid3Jzcys5VzRsMzg5dlpTVzBCU1lrL0YxRWJDRzZR?= =?utf-8?B?UHUyZ2lWR1ZhRFQ2bjN3bEFoUzA0Qkc4N29QSncxUCtsSjRubGU3YXpGNlJK?= =?utf-8?B?bzZOcmIxOVA2aVEzSlQ2SFhPQzdhSVZtMzVkWktFUFRySG9zZ2prYldLWFRC?= =?utf-8?B?bEFJc3F2VStOb01sUnk0OG4wTFc0OEw5SzR5M0p2QlRXWkdHcGY3RXpHak1X?= =?utf-8?B?WFhyRjBJU1BUUlpIeks0citKcE5VQ1dTK1E2WllJV3h2enZpVDl2MjNHcmxo?= =?utf-8?B?Y0xTMmVpYnFKM1hxdDNWOUZ0Z21RUTVINUdtT0RtNmo4eXI1WVI1TVArMmRV?= =?utf-8?B?RENMaUptSnl6V3k3MC9vVEVmWDRmSytlbHkyakNob2FaOXZreCtaQ0VjZFFL?= =?utf-8?B?NWFPZXZYQWFzY1BobEJHVVRpVzVOMit3dlFwdzNtZWt6OXBUUEpOZUdvY2dY?= =?utf-8?B?Yi9Bc1drcTZZdnlYOXhUOWZNMjc1VjBHQXFLcTZhcTFscXNqdGJwMXhJelBV?= =?utf-8?B?STl3K2V5ZHgzRzBkMXo3QzBUV2tINjRNNmJjSEdZUEIvYmxEMEI1aC9PMnF0?= =?utf-8?B?UDVGYkw2T0t3bHhGeVBDZ0ZIWm1oeFZTSVZhTGM1eVQwWENGN1BwaFBJSkhj?= =?utf-8?B?QkFKVzA0L3Nnandoek5IZTM3Si9pOGJaZnNHNDREU1NlMGE3UE01bTFqMDRV?= =?utf-8?B?c0FtY3ZtR2JIeDFlRlZ5WkRONkwyM3FBMkwvMFZGVmg1MUU3M0VFM1dtdUZl?= =?utf-8?B?clBPRHJtNzNXUXRYNFJQUnZjUC9GY0Uyem42MkdPa3lad2RvYlBGWEcxS0wz?= =?utf-8?B?WjB5a21VcUJWYnBmdkZXQ2RjQkI4TmZiQUVIalUrMktzVE9TbnUzL2JXZWov?= =?utf-8?B?QUI3VE5uUzZXR2F3eWJYazRYRXBINXk3ckJyL3BHbGYrYk1JU1lVMzBtMVd0?= =?utf-8?B?NUNrVzQvOXo3WWlwRDNwVFVPb2tGR1JHQjhveFJNVitNR3JTU0FFaEdjOGN1?= =?utf-8?B?b3FSRWxURjVvcmUybG14UGp6cFNBQWtWWVNxM2J5b3EyWkp1NVI3UXBUS0Qy?= =?utf-8?B?Q09MM0VyemJsMzRjRDJEN0JHWDVPZVVnUHRhZGtSS3YvWUw1Y0NwaG5jT0VJ?= =?utf-8?B?amYxd3QzQnEyODF6MzF2dGtuTGdmS3hLZzg5ektRbGI0M1NyY0RVbjFlQVlw?= =?utf-8?B?SzFXamtzR1M1WDMwbzl2V1l0OHlXeGNRanBHak0yMDZUWGhWWGpGUkpWL09k?= =?utf-8?B?ak52Rm5uN1hkM21yZjJwQT09?= X-Forefront-Antispam-Report: CIP:255.255.255.255;CTRY:;LANG:en;SCL:1;SRV:;IPV:NLI;SFV:NSPM;H:TY3P286MB2691.JPNP286.PROD.OUTLOOK.COM;PTR:;CAT:NONE;SFS:(13230040)(376014)(1800799024)(366016)(7053199007);DIR:OUT;SFP:1102; X-MS-Exchange-AntiSpam-MessageData-ChunkCount: 1 X-MS-Exchange-AntiSpam-MessageData-0: =?utf-8?B?L1JHN00yUlNMdTZwSURla2ZzbEd5RXZzUTVSRFVlYU5vVHYyTmU4U1hnU3Vv?= =?utf-8?B?TkZ5c0RHMUNNdTNYNVFGcXdmbU1ucWpPSkp4a2ZaMXBiN1JpcGdTeTFuYTBp?= =?utf-8?B?QjVrNURXV3pPTFdYUHo2YjBuZWJzSGFHN2lqWXFjVGgycUlZa3lFQjJrMXhx?= =?utf-8?B?MFZFbUFZc3RhVktWenJSM0RkMzVnbGZzTmtIUnhFNGw2R3dBNUZsVUlVQU1l?= =?utf-8?B?SzlHeVhPM1VLSEtDUVlESUhySnhPTTRUUFhlWGZQWVJxVnk3SGVaaCsraXY0?= =?utf-8?B?MXFSeSsrZE04bm1yc1Yvcm5adHdHUUsvY2s4akhQMDM2V1UwK05mSHdFcnEr?= =?utf-8?B?MUlHTjVFdUhKTWh5UzZQdXMxMU1UMUVkaWN4eFVjd1FTYkJwbit3TC9MM2pE?= =?utf-8?B?MnRMS2RsRFNNL3pHNVNwb05RRTBZNmZ1UGxGb3pTeDF3bTdOa0FWRThZdS9M?= =?utf-8?B?aW1lNlQwL2RDZUt6aHBPb3FCakkvNEMxVWsvYlUvNzQ3RVpSOTUzQ3JvQXg2?= =?utf-8?B?YzZUdVVuRXo5MTRQTGw1N1BrWDc1K1kycGRoMGlnQUx0VUdjOWJZR2JRTGZQ?= =?utf-8?B?OVNLRlhKYjgxZXhJVlZHeVByZ2tEQWZTT3ZuVEVLNWd3cGREZklEak93S3Bk?= =?utf-8?B?SHhWc04zOXBqcmxybnFqek1aeXlzdHAwR0w1RTFPSlJwSU5NeGp2dUVJUTQ0?= =?utf-8?B?c1R6SGdCR1hZZVJ4b3IxRngyeCtPT1dMZGNnWGJobkl3L0JrbnVJM0FZSXpk?= =?utf-8?B?VGozRjRlb1VWRFRRemIzUCtWaktYVDdpbW9hejhoQWQwdkx4UHNPY201eWZi?= =?utf-8?B?TVUwSW4rMHU3cEhCWlRMbUVpQjVEM2tybzJwSHYvdmpDbHVtdUZQalM3cWlw?= =?utf-8?B?KzBkYXpyUWtraFAwVVFNcVJRVUt3aUR0c2dVc0dkZUxOTXZLc3pjVW14ODJO?= =?utf-8?B?ZnpRcGFzd1VibTVPQlFpNW9iRVJOREFGMThRWEpRMzgyc05mQm50eWRVT2lv?= =?utf-8?B?MEpTM1lPVlQ3YmE0YlViVExtM0Z6TndPVnh0SUErZGdmWllRZDNIUDZIWmpm?= =?utf-8?B?TWxtQ2RUenhQNXVDcGRqVWwrU2hhejhzUzlvbjFFdnBrVjcrZnBGbkJNaDNa?= =?utf-8?B?YkIyckt5UnFTYklLc1hSWkxBV0pFWHJFMHV0aG5kZFlJVzBJL1IxS1dzSVFO?= =?utf-8?B?dzBGSDVqZTBYTFpta2hEcHVNT2h5Z2NnRnRSWE1NcVo0ZDBubDBtV2dBTFNW?= =?utf-8?B?S3dmSXJDWkJZQ0VSSEhjeU0yQkpuZjZpMW1NUVBXSWpQUnhSc3dvRHB1YXBE?= =?utf-8?B?UlBublNJTFRBVkR0cFpQenJYdzNjT2V4cGhrOWtSWituZi8zK3RpN0pWVEZz?= =?utf-8?B?OFgwNHZnV01lYlFBMkFDSlhSM0NLZCtaVkh6QXVOd1c2UEQ1OUtaRk95T2RD?= =?utf-8?B?UmsyTnBMaDdKZVJxR1BzK2lsaUM1cWNLeDBXbW9YNm9jazYwZWhZNC95RVNx?= =?utf-8?B?YWtHZThGaTlQREdPRnZub3NhQ2lLL1pxdEZEUkc3dEVmMzhvczd2OENvVlYr?= =?utf-8?B?aTBHQ3VZLzZkOVl2ZGNESExkazhjSGFmTmVPNDFQZjFKQjhKVzNqTjlGMFRD?= =?utf-8?B?Y0NLZE9ha0ZEZTA0cWlpdnpxUW92ZTdxM2hUSmM0VnFTU21ram5aUVk3dTBv?= =?utf-8?B?QjZGaWx2bktaelVYZGRZdzVVMXAzSkpKTGNZRTZJT3NNVmw4TjBqaW50Rmx3?= =?utf-8?B?N0hpS0diVmd2ZS8wK3h5WXN1RC9CUDdPN3A5Tm9pS1k3a0ZlSnFnWFp4Mitq?= =?utf-8?B?YnFDWU81ei9hTGVOZzFyMGV4RS8waWIwd0h3MXZldFUyT24zbEtPbTVCeFdU?= =?utf-8?B?TEsrRzhQZXhvN1I5WVRld3NJTGpsd0U5UCtPWGNodXJ6cno5a0RPQ2svcUVU?= =?utf-8?B?dHRwYVBMNGRINDNIT2M1V2dFNWdDckxEZTVzdkluZmFUK2R4cnFjWlVHNVhn?= =?utf-8?B?UGw4YzFTNEpiZmJOSS81bU5JZnlIdHp2UHVockVsZ0dXTUZVcE9GbUlEK0lT?= =?utf-8?B?cDhIWUdaNVpmb010ODMyMVFHL2o3N25Sc1YwQ0I4dW02Z3BwQ0JGMHVOaDc4?= =?utf-8?Q?5laZJO8LQwcbHUYDfew14tC6B?= X-OriginatorOrg: sraoss.co.jp X-MS-Exchange-CrossTenant-Network-Message-Id: 7a340b74-6541-4da5-db92-08dd55363c8c X-MS-Exchange-CrossTenant-AuthSource: TY3P286MB2691.JPNP286.PROD.OUTLOOK.COM X-MS-Exchange-CrossTenant-AuthAs: Internal X-MS-Exchange-CrossTenant-OriginalArrivalTime: 25 Feb 2025 00:49:20.3927 (UTC) X-MS-Exchange-CrossTenant-FromEntityHeader: Hosted X-MS-Exchange-CrossTenant-Id: 75db6c32-352e-4063-ae79-cafb8623f6db X-MS-Exchange-CrossTenant-MailboxType: HOSTED X-MS-Exchange-CrossTenant-UserPrincipalName: HiWeaV0+8JV/yZL2CogHjcywnGHmdRtzm4O2lJGuRA+EJ8KETfrTXpSxl/pBRf51zjdMMy1winDdIc1nUQqBaA== X-MS-Exchange-Transport-CrossTenantHeadersStamped: OS9P286MB4699 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Hi, Thanks for sharing this! Really appreciate the effort you and the team put into creating such a detailed guide. I checked the page and found it very helpful. I also noticed a few small typos: pg_repack : emove bloat from tables and indexes, and optionally restore the physical order of clustered indexes without holding an exclusive lock emove -> Remove sslutils : Provides SSL certicate generation functions to Postgres certicate -> certificate pgauditlogtofile : Aaddon to pgAudit than will redirect audit log lines to an independent file, instead of using PostgreSQL server logger Aaddon -> Addon pointcloud : ostgreSQL extension for storing point cloud (LIDAR) data ostgreSQL -> PostgreSQL Hope this helps. Thanks again for the great work! Regards, On Fri, 21 Feb 2025 11:24:56 +0300 Devrim Gündüz wrote: > I’m excited to introduce a new community project: "Installing and > Configuring PostgreSQL Extensions via RPMs"! > > https://yum.postgresql.org/extensions/ > > This document provides detailed guidance on installing and configuring > PostgreSQL extensions on RPM-based systems. It goes beyond just running > dnf install—covering essential pre-installation steps, configuration > options (including GUC settings), and best practices to ensure a smooth > setup. > > A big thank you to Tom Kincaid and EDB for supporting my time on this > project! I'd also like to extend this to Magnus Hagander for giving me > design ideas and Matthias van de Meent for helping me to categorise the > extensions! > > Please let me know if you find any issues. ---- Tomoaki Sato SRA OSS K.K.