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 1r2R5T-00GfHY-QP for pgsql-pkg-yum@arkaria.postgresql.org; Mon, 13 Nov 2023 07:10:23 +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 1r2R5R-00DXGu-Jd for pgsql-pkg-yum@arkaria.postgresql.org; Mon, 13 Nov 2023 07:10:21 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1r2R5R-00DXDg-8M for pgsql-pkg-yum@lists.postgresql.org; Mon, 13 Nov 2023 07:10:21 +0000 Received: from mail-qk1-x72f.google.com ([2607:f8b0:4864:20::72f]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1r2R5N-005KDr-Qa for pgsql-pkg-yum@lists.postgresql.org; Mon, 13 Nov 2023 07:10:19 +0000 Received: by mail-qk1-x72f.google.com with SMTP id af79cd13be357-778a6c440faso207801785a.3 for ; Sun, 12 Nov 2023 23:10:17 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=pcorp-us.20230601.gappssmtp.com; s=20230601; t=1699859417; x=1700464217; darn=lists.postgresql.org; h=content-language:thread-index:content-transfer-encoding :mime-version:message-id:date:subject:in-reply-to:references:to:from :from:to:cc:subject:date:message-id:reply-to; bh=91wBMjrg8v9KKjR9bF04Tcwo4oWnO8Nv0jPnM7c/4vg=; b=NUBtaeUjXvSm1JVgdeKUPf4++ydeJzyTMw9lLT40U4zj6bWXh9qL9r6o8hOV1vFqhE PYhbsOasWWM/AuqGqJYnI2KFeqYomCL1voHcbhE6ZbsJSHiJB7NZBs7N3FTEslVF4FgW hnkOgzNojs2j2KALmMDiW98rcL0sdCIg0EHGxp1CaudlShMw1zd56fG4Y8367KrNK6ht FXItl/qjWBcxwkKpZM6JdCh7mKlydizqaxmjOVZntZHw2DjIsRdGZ/c4p5p+WuLO9ZMP im7V57qgaDzjklQB9Ruow78io4jfVpZYtxzHu+rmzgxG56D9zOr2UaEnoxzR7c6RNE7N NhFA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1699859417; x=1700464217; h=content-language:thread-index:content-transfer-encoding :mime-version:message-id:date:subject:in-reply-to:references:to:from :x-gm-message-state:from:to:cc:subject:date:message-id:reply-to; bh=91wBMjrg8v9KKjR9bF04Tcwo4oWnO8Nv0jPnM7c/4vg=; b=Sfvk6bpBniObFODWKYhKrkuGV9alRXi2bi2KmpZG9yYf2F4z+LraVHy7KH7we8qg2R T6E6SLt5g2MfBV3Hq/GOY2UPyqoQSpM0TepPYBLsHltkinwjhoUtnF+vSh3qMs1UGPOv 9pkmzUL0ydYn4J858sxISR50DNXkcUmg5VlICvK/IPTWTx/M0EBLwZWwL8giSUVGRk2V d5reGP8IrASmMtOyPqmGp3hoNEoK7diVtDn4OTE/zbBl+JRS/HM8x4onkWsj5hfuHmvY EPnSB8LjYyEtkJ4xc8uuA8ZC2YARY1YaWdqH8YNDZdChHAapo4nY9E8vJ5RaPiVJM7pQ KhWQ== X-Gm-Message-State: AOJu0Yw4iznGN0KOm+teIltqDOFm7t6hrAb1Poj5AnKy4JLZt7tVA9H2 pRJ98WeJME/4arvwcEyK5bUo8XqAhaPDGFe8swo= X-Google-Smtp-Source: AGHT+IHGRVZEsqxRVjpmeZOhqW1QVaw0xf+EQnMMXPCwTadLsNNVfzphxLwKpsaS5idpY/EqFcSTkw== X-Received: by 2002:a05:620a:28d0:b0:775:7535:3ed9 with SMTP id l16-20020a05620a28d000b0077575353ed9mr6149533qkp.40.1699859416880; Sun, 12 Nov 2023 23:10:16 -0800 (PST) Received: from R (50-78-240-110-static.hfc.comcastbusiness.net. [50.78.240.110]) by smtp.gmail.com with ESMTPSA id d5-20020a05620a158500b007756e75b91bsm1670704qkk.78.2023.11.12.23.10.16 (version=TLS1_2 cipher=ECDHE-ECDSA-AES128-GCM-SHA256 bits=128/128); Sun, 12 Nov 2023 23:10:16 -0800 (PST) From: "Regina Obe" To: "'Simon Connah'" , References: In-Reply-To: Subject: RE: PostgreSQL 16 and PostGIS Date: Mon, 13 Nov 2023 02:10:19 -0500 Message-ID: <001401da1600$76249150$626db3f0$@pcorp.us> MIME-Version: 1.0 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable X-Mailer: Microsoft Outlook 16.0 Thread-Index: AQKQPkIV8kUguWK45CrP2qWt1eMoDK8Lg6XA Content-Language: en-us List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk > Hi, >=20 > I originally posted in the PostgreSQL novice list that I had installed = PostgreSQL > 16 on Rocky Linux 9 using this method: >=20 > https://www.postgresql.org/download/linux/redhat/ >=20 > and it works perfectly. But when I try and install PostGIS I ended up = getting this > error: >=20 > [root@139-162-197-226 simon]# dnf update Last metadata expiration = check: > 1:11:27 ago on Mon 13 Nov 2023 05:02:27 AM UTC. > Dependencies resolved. > Nothing to do. > Complete! > [root@139-162-197-226 simon]# dnf install postgis34_16 Last metadata > expiration check: 1:11:40 ago on Mon 13 Nov 2023 05:02:27 AM UTC. > Error: > Problem: package postgis34_16-3.4.0-1PGDG.rhel9.x86_64 requires = gdal36- > libs >=3D 3.6.3, but none of the providers can be installed > - package postgis34_16-3.4.0-1PGDG.rhel9.x86_64 requires > libgdal.so.32()(64bit), but none of the providers can be installed > - conflicting requests > - nothing provides libqhull_r.so.7()(64bit) needed by = gdal36-libs-3.6.4- > 4PGDG.rhel9.x86_64 > - nothing provides libqhull_r.so.7()(64bit) needed by = gdal36-libs-3.6.4- > 5PGDG.rhel9.x86_64 > (try to add '--skip-broken' to skip uninstallable packages or = '--nobest' to use > not only best candidate packages) >=20 > Is there any fix to this at all? >=20 > Thank you. >=20 > Simon. I think you might be missing the=20 crb enable step that Devrim mentioned in an email thread. FWIW, I've updated the Yum instructions on postgis.net t o include that. https://postgis.net/documentation/getting_started/install_red_hat/ Let me know if all that works for you or if I missed anything. Those worked for me, but I was testing with Rocky8=20