From: Ron <ronljohnsonjr@gmail.com>
To: pgsql-admin@lists.postgresql.org
Subject: Re: Binaries for EOL version?
Date: Thu, 19 Oct 2023 21:58:12 -0500
Message-ID: <0b63f7bb-01dc-4c96-8179-8039fa608b71@gmail.com> (raw)
In-Reply-To: <119cb52d-782c-413f-bd77-e0571abf5161@uvic.ca>
References: <b2c6c214-14f9-4d03-9b5b-f6cf6224bfdb@gmail.com>
<0aeb11d2-039b-edff-1514-299652e73936@gmx.net>
<e828e7b1-918d-47e2-9ee6-b5abfc7b0a64@gmail.com>
<3368392.1697736614@sss.pgh.pa.us>
<40e90793-744f-4d8a-8b86-82495bc154ce@gmail.com>
<52456b74-c817-42b3-91f9-6c656d9413c5@uvic.ca>
<1dac15f4-51b3-4aac-bd5c-bf773b64e189@gmail.com>
<e0fae254-6237-4454-8565-f5d80b8748e2@uvic.ca>
<dceab5c2-c6bc-4ef8-9cfc-fb3f8a5c2835@gmail.com>
<c560e3a1-9a47-48f6-bb26-ce3bbd2b445e@uvic.ca>
<a244a596-d53b-473b-b76f-666994e8cbe6@gmail.com>
<119cb52d-782c-413f-bd77-e0571abf5161@uvic.ca>
On 10/19/23 16:12, Evan Rempel wrote:
> I'm not arguing if the yum-archive.postgresql.org should or should not
> permit browsing. I'm trying to give you a solution that you can implement
> today to acquire the packages that you need.
As if I haven't considered that (and instantly dismissed it, since Ubuntu
and Windows).
>
> IMHO I applaud the fact that these packages are more difficult to get than
> the currently supported and tested versions. I can't see a reason why
> anyone would want to still be running them, but lets give credit where
> credit is due. The packages are still available even if I can't see a
> reason to run them.
If someone needs to install another package in an existing EOL system,
they'd need to download that package from the archive.
>
> Evan.
>
> On 2023-10-19 14:05, Ron wrote:
>>
>> A repository is a bunch of web pages. I can curl every package under
>> download.postgresql.org/pub, so why can't we curl every package under
>> yum-archive.postgresql.org?
>>
>> On 10/19/23 15:21, Evan Rempel wrote:
>>> No. The original request was for the RPMs from a yum repository. You
>>> have to use a yum capable system.
>>>
>>>
>>> On 2023-10-19 13:02, Ron wrote:
>>>>
>>>> Even Ubuntu and Windows?
>>>>
>>>> On 10/19/23 14:44, Evan Rempel wrote:
>>>>> You can do that on any host and use the yum download only or if you
>>>>> want it all use reposync.
>>>>> Then you can copy the actual RPMS anywhere you want.
>>>>>
>>>>> Evan.
>>>>>
>>>>> On 2023-10-19 12:06, Ron wrote:
>>>>>>
>>>>>> Ah. But I can't do that, since the server is behind many firewalls,
>>>>>> and only has access to an internal RHEL mirror.
>>>>>>
>>>>>> The "current" binaries are all accessible via web browser (and curl),
>>>>>> so it puzzles me why yum-archive isn't.
>>>>>>
>>>>>> I opened Redmine issue 7892 to make them available.
>>>>>>
>>>>>> On 10/19/23 13:38, Evan Rempel wrote:
>>>>>>> The packages you need are definitely on the postgresql yum server.
>>>>>>> The repository can not be browsed, but if you add the yum repository
>>>>>>> definition file as documented at the bottom of the page
>>>>>>> https://yum.postgresql.org/repopackages/#pgredhatoldrepos
>>>>>>>
>>>>>>> you will be able to do a "yum install amcheck_next96" easily.
>>>>>>>
>>>>>>> cat << EOF > /etc/yum.repos.d/pgdg-96.repo
>>>>>>> [pgdg96]
>>>>>>> name=PostgreSQL 9.6 RPMs for RHEL/CentOS 6
>>>>>>> baseurl=https://yum-archive.postgresql.org/9.6/redhat/rhel-6-x86_64
>>>>>>> enabled=1
>>>>>>> gpgcheck=0
>>>>>>> gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-PGDG
>>>>>>> EOF
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>> On 2023-10-19 10:54, Ron wrote:
>>>>>>>>
>>>>>>>> On 10/19/23 12:30, Tom Lane wrote:
>>>>>>>> [snip]
>>>>>>>>> amcheck was not part of the Postgres source tree until v10.
>>>>>>>>> It might exist in some form for 9.6, but you'd have to look
>>>>>>>>> outside the standard distribution channels
>>>>>>>>
>>>>>>>> amcheck_next96 binary RPM were absolutely distributed by
>>>>>>>> download.postgresql.org/pub/repos/yum/9.6/redhat/rhel-6.
>>>>>>>>
>>>>>>>> I downloaded amcheck_next96-1.4.1 when I downloaded 9.6.22, but did
>>>>>>>> not download amcheck_next96-1.4.5 with 9.6.24.
>>>>>>>>
>>>>>>>> If push comes to shove, I can probably install the 1.4.1 RPM along
>>>>>>>> side 9.6.24.
>>>>>>>>
>>>>>>>> --
>>>>>>>> Born in Arizona, moved to Babylonia.
>>>>>
>>>>
>>>> --
>>>> Born in Arizona, moved to Babylonia.
>>>
>>
>> --
>> Born in Arizona, moved to Babylonia.
>
--
Born in Arizona, moved to Babylonia.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: ronljohnsonjr@gmail.com, pgsql-admin@lists.postgresql.org
Subject: Re: Binaries for EOL version?
In-Reply-To: <0b63f7bb-01dc-4c96-8179-8039fa608b71@gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox