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 1qtZEM-00CwzI-Ho for pgsql-admin@arkaria.postgresql.org; Thu, 19 Oct 2023 20:02:54 +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 1qtZEK-006jcU-4d for pgsql-admin@arkaria.postgresql.org; Thu, 19 Oct 2023 20:02:52 +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 1qtZEJ-006jbm-OU for pgsql-admin@lists.postgresql.org; Thu, 19 Oct 2023 20:02:52 +0000 Received: from mail-yw1-x112c.google.com ([2607:f8b0:4864:20::112c]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1qtZEF-001bDW-Ro for pgsql-admin@lists.postgresql.org; Thu, 19 Oct 2023 20:02:51 +0000 Received: by mail-yw1-x112c.google.com with SMTP id 00721157ae682-5a7ab31fb8bso234397b3.1 for ; Thu, 19 Oct 2023 13:02:48 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1697745767; x=1698350567; darn=lists.postgresql.org; h=in-reply-to:from:references:to:content-language:subject:user-agent :mime-version:date:message-id:from:to:cc:subject:date:message-id :reply-to; bh=5fZmpBpHUb873gSZ6DieSqBlhgAcLpTQeP86r+X1P0w=; b=VojuCp5QGFlSEZGR30PX0V0XkP/6QyXzkbhhI1Ztt7NqLZsgFlpWKA1+mQpxplo3xx yqG46hdcXJwe7lYX89jVi5GeH/uIIfxSl0yOhqWBSMMU+GPsNlwv/hTwRcbNCZg2vsKD 9WXUJtr8s1usAHpv2ukze7MQLAxkNZ9Ql2XFU0UKiW7zbqh7GAN3eD0hcZc/lQAZHP1F aZ7/NOva9GbH5mfhjVtD63QMjHtIEe7aeAL+hOnppvwllbbn1ZZr5kgK2T8vMiNMlGZ3 0ydbEswxjA+zyz4mm4ArOmg+Iws/0GtcDBPW39adOAU3PeshtDLZOQsyHo7bopVYS27s KQXQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1697745767; x=1698350567; h=in-reply-to:from:references:to:content-language:subject:user-agent :mime-version:date:message-id:x-gm-message-state:from:to:cc:subject :date:message-id:reply-to; bh=5fZmpBpHUb873gSZ6DieSqBlhgAcLpTQeP86r+X1P0w=; b=RG7VLT4Vl0wPzny3+A52z+15sfs38mwAhtJyxw4WQbsu4rPSKTb8gUNB+PjbXbsBqe cPrNgmPnOiUW7draE+P753Sd8V8kB92HoKzWbfK3KWr3Q+oSHDnljHXJU/OK4pjPMZXN 8oTAuUjZ4c9bZM3Tn7H6g8pnXd7QaP3I76pcUucftSgV3nWYwxbyZeaYyMygmKP7aewr ZkLtLu3OA83jIfwv7Eez9tjLA2b/MVZ4BQ4uZuIynnRj/f0uZOeLyljcULAIV3hjPB26 r5+RGSq079toqHpx/jx4Y8fzdT0eA6vI8XzwGYb7CSiV3zrL8m/ExS/obDu/GbQdh712 ABaw== X-Gm-Message-State: AOJu0YwC0P9dMOq6/EJl3ZhWbvqFu5m50wNiFLMi46/PPpKUlV8p//sS ZXnjTqZP2jh7F3pwvUGOyaa0aaii5f8= X-Google-Smtp-Source: AGHT+IHDQJRkgCLXaI0mi6gtkTkLeNmgZkKMKGqq7fK7E9+nIIYNeWkwRiPrnP/RZsEna3v89WmyRA== X-Received: by 2002:a25:aaeb:0:b0:d9b:b6:ad72 with SMTP id t98-20020a25aaeb000000b00d9b00b6ad72mr3705382ybi.50.1697745766567; Thu, 19 Oct 2023 13:02:46 -0700 (PDT) Received: from ?IPV6:2600:1700:bd2c:b810:d509:606b:cffe:5a41? ([2600:1700:bd2c:b810:d509:606b:cffe:5a41]) by smtp.googlemail.com with ESMTPSA id n22-20020a25da16000000b00d9caecd5c86sm40966ybf.62.2023.10.19.13.02.46 for (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Thu, 19 Oct 2023 13:02:46 -0700 (PDT) Content-Type: multipart/alternative; boundary="------------BRd6ABGR4aZxxxJEfTC8Lg0N" Message-ID: Date: Thu, 19 Oct 2023 15:02:45 -0500 MIME-Version: 1.0 User-Agent: Mozilla Thunderbird Subject: Re: Binaries for EOL version? Content-Language: en-US To: pgsql-admin@lists.postgresql.org References: <0aeb11d2-039b-edff-1514-299652e73936@gmx.net> <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> From: Ron In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk This is a multi-part message in MIME format. --------------BRd6ABGR4aZxxxJEfTC8Lg0N Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 8bit 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. --------------BRd6ABGR4aZxxxJEfTC8Lg0N Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: 8bit 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.
--------------BRd6ABGR4aZxxxJEfTC8Lg0N--