Content-Type: multipart/alternative;
 boundary="------------eVdDT0uSXDMnhDRbrIn4zpMT"
Message-ID: <f6abcd80-8c6f-480c-a3cd-b6e9b4c19d21@dunslane.net>
Date: Wed, 31 Jul 2024 12:16:37 -0400
MIME-Version: 1.0
User-Agent: Mozilla Thunderbird
Subject: Re: BUG #18561: postgresql16-devel rpm cannot be installed due to
 missing Perl-IPC-Run
To: tim@dysinger.net, pgsql-bugs@lists.postgresql.org
References: <18561-07747d3320525e48@postgresql.org>
From: Andrew Dunstan <andrew@dunslane.net>
Content-Language: en-US
Autocrypt: addr=andrew@dunslane.net; keydata=
 xsBNBE7KWFkBCAClridxur2AIc7eW2AR7izbfp3EnNefie2HbLF0izW5Ik5UjX2HBXBx4syI
 gY6b0ugohXrr274+baoAlvSbq6cAoQuEVrk5IZFzt20b1Xkx65FwGSEj526yiKLocqkJceSq
 Xr9xcA5SGY+FZv441chh5SU92v4q6z+6LPpoHOh97ptAVXZYNTtU0LevyvD5lja0TzbvJm6C
 eFXitJfnm1pLEr0DGJCR/iUOl/N62Kh4855zZC7NHIjQHPOvV5Stz/l5ilDhvGVk+xkXFPys
 SjZoUr1rXhYLpiyi5sR0X9FHXT0KnGuz1F5ERO7ZTLSSQ6fJwPj6gOk9K+vvoKvoeql5ABEB
 AAHNJEFuZHJldyBEdW5zdGFuIDxhbmRyZXdAZHVuc2xhbmUubmV0PsLAmwQTAQgARQIbAwIX
 gAIZAQULCQgHAgMiAgEGFQoJCAsCBBYCAwECHgcWIQTkPlhGHfx8v0RpFaWZ+n/LWfw7gQUC
 ZFlxxwUJGVGAbgAKCRCZ+n/LWfw7gXikB/9ZdcUy6CTBFIIuL/bVsc1eLEW/gJBjJBF6HxNY
 xgEkAgXAp4Lg4A5U+QB9GouFr7+GYxF0BU4hzoGhNPUWltxnHdMWP8nC/38LAqgMi8L/bbsm
 HW5YPBdWYaAZAPJQVfOAgjTbRUb26KSprpyrrJKW0ZmrZfjhNPcQ72jpWzoPLQqx2X6B0fru
 1jq+cBh8lb6r1mJTim1T3JIn+F/v5VpdQS+EL8xqsHkfzKjIPsW3CIXpkypSk6saA55Rkkbl
 26AW8ftPVB0Q6Lnn6FLt9CP0MGNixBQ55yq8r1K+nCBvCCjvQjM8RDm0UUum0WNl+ifQgTLO
 E8TWEnwVtkBf+3QWzsBNBE7KWFkBCADRnOM0FCzsYW6jtncg+dWIagjUZpvaClmqn/sJluLa
 Q3v1VXMQJzYs3eC1gh386W+XBwLRpDj3jzH81lX+p73Re3d3oJW7X+ffsxuzu5ZVdMUkqBYo
 nkAbKxr6gyJ12F/+JkUVzLcoTN+d/7YsQvUVi7NaKH8mJgjz112O4fUe3p9wfAaFa0RXHc5S
 GPzRTYRRlv/XZBIho4J2tkZOnteZJZ+GbxQVlINt6fd8P6al3MWOvpP/ExJPguEfjOsO6Njy
 xjo3WfpD4lHMOR/Oc3/8mScEF84rF2jXbsFgelWnbPWAvXY+pD0dXOFRkagGmC/viwBDqq5b
 5tk76kKmUbZxABEBAAHCwHwEGAEIACYCGwwWIQTkPlhGHfx8v0RpFaWZ+n/LWfw7gQUCZFlx
 5wUJGVGAjgAKCRCZ+n/LWfw7gf+iB/4g8CPY5jihf5r/8EsoIGe2H+dpVmpPF8YGBzTIvCz/
 fQoOq8AX/pE76QEuFnFZWfjw+wgBXgCVmkox2Eflkk6z4ND3pcwGZ6CfCxTQCDk/dij+2DQ4
 6bmDCy/sBgcbz9mTpoLC11HLoPae6YN9nBNQRZDcEFEu54OaVOqlIdbA6m+POIBCXZdHOFc0
 WoDTgxHRzC1jgQNidyd6tKqcsVJs0dzF0oKTmFFmUAqTdJO12LBuNA1rlqrR3EtpYk8B/wtS
 5dIMD7Q8hwQpL+4C6GNpb6ZKnPkLi47pDOLhz2qBrqN+rqUEsT3YnExYpzj5yOBi+FlmV1Hw
 49QYe1sn2ZPs
In-Reply-To: <18561-07747d3320525e48@postgresql.org>
Archived-At: 
 <https://www.postgresql.org/message-id/f6abcd80-8c6f-480c-a3cd-b6e9b4c19d21%40dunslane.net>
Precedence: bulk

This is a multi-part message in MIME format.
--------------eVdDT0uSXDMnhDRbrIn4zpMT
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 8bit


On 2024-07-31 We 11:16 AM, PG Bug reporting form wrote:
> The following bug has been logged on the website:
>
> Bug reference:      18561
> Logged by:          Tim Dysinger
> Email address:tim@dysinger.net
> PostgreSQL version: 16.3
> Operating system:   RedHat 9, Alma Linux 9, Rocky Linux 9
> Description:
>
> If you grab a fresh RedHat 9 image and try to install PGDG rpms from your
> repository like so:
>
> dnf install -y
> https://download.postgresql.org/pub/repos/yum/reporpms/EL-9-x86_64/pgdg-redhat-repo-latest.noarch.rpm
> dnf install -y postgresql16-server postgresql16-devel
>
> It fails with a missing Perl IPC Run which is not available anywhere in the
> RedHat ecosystem as far as I can tell. I'm trying to create custom postgres
> extensions and package them as RPMs for distribution. For that to work I
> need to match against the official PGDG packages. I can't even compile the
> extensions against PGDG's RedHat packages right now. Please advise.
>
> ```
> 25.67 Error:
> 25.67  Problem: cannot install the best candidate for the job
> 25.67   - nothing provides perl(IPC::Run) needed by
> postgresql16-devel-16.3-1PGDG.rhel9.x86_64 from pgdg16
> 25.67 (try to add '--skip-broken' to skip uninstallable packages or
> '--nobest' to use not only best candidate packages)
> ```
>
> Thank you for your advice and help.


You need to enable Rocky's Code Ready Builder repo like this:

|    dnf config-manager --set-enabled crb|


Not sure what the answer is for Alma/RH


cheers

andrew

--
Andrew Dunstan
EDB:https://www.enterprisedb.com

--------------eVdDT0uSXDMnhDRbrIn4zpMT
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: 8bit

<!DOCTYPE html>
<html>
  <head>
    <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
  </head>
  <body>
    <p><br>
    </p>
    <div class="moz-cite-prefix">On 2024-07-31 We 11:16 AM, PG Bug
      reporting form wrote:<br>
    </div>
    <blockquote type="cite"
      cite="mid:18561-07747d3320525e48@postgresql.org">
      <pre class="moz-quote-pre" wrap="">The following bug has been logged on the website:

Bug reference:      18561
Logged by:          Tim Dysinger
Email address:      <a class="moz-txt-link-abbreviated" href="mailto:tim@dysinger.net">tim@dysinger.net</a>
PostgreSQL version: 16.3
Operating system:   RedHat 9, Alma Linux 9, Rocky Linux 9
Description:        

If you grab a fresh RedHat 9 image and try to install PGDG rpms from your
repository like so:

dnf install -y
<a class="moz-txt-link-freetext" href="https://download.postgresql.org/pub/repos/yum/reporpms/EL-9-x86_64/pgdg-redhat-repo-latest.noarch.rpm">https://download.postgresql.org/pub/repos/yum/reporpms/EL-9-x86_64/pgdg-redhat-repo-latest.noarch.rpm</a>
dnf install -y postgresql16-server postgresql16-devel

It fails with a missing Perl IPC Run which is not available anywhere in the
RedHat ecosystem as far as I can tell. I'm trying to create custom postgres
extensions and package them as RPMs for distribution. For that to work I
need to match against the official PGDG packages. I can't even compile the
extensions against PGDG's RedHat packages right now. Please advise.

```
25.67 Error:
25.67  Problem: cannot install the best candidate for the job
25.67   - nothing provides perl(IPC::Run) needed by
postgresql16-devel-16.3-1PGDG.rhel9.x86_64 from pgdg16
25.67 (try to add '--skip-broken' to skip uninstallable packages or
'--nobest' to use not only best candidate packages)
```

Thank you for your advice and help.
</pre>
    </blockquote>
    <p><br>
    </p>
    <p><span style="white-space: pre-wrap">
</span></p>
    <p><span style="white-space: pre-wrap">You need to enable Rocky's Code Ready Builder repo like this:</span></p>
    <p><span style="white-space: pre-wrap">
</span></p>
    <p><code>    dnf config-manager --set-enabled crb</code></p>
    <p><br>
    </p>
    <p>Not sure what the answer is for Alma/RH</p>
    <p><br>
    </p>
    <p><span style="white-space: pre-wrap">cheers</span></p>
    <p><span style="white-space: pre-wrap">
</span></p>
    <p><span style="white-space: pre-wrap">andrew	
</span></p>
    <pre class="moz-signature"
    signature-switch-id="d0437855-2267-4610-80b3-83167ec45b0b" cols="72">--
Andrew Dunstan
EDB: <a class="moz-txt-link-freetext" href="https://www.enterprisedb.com">https://www.enterprisedb.com</a>
</pre>
  </body>
</html>

--------------eVdDT0uSXDMnhDRbrIn4zpMT--