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 1qtYM8-00Cs7O-9W for pgsql-admin@arkaria.postgresql.org; Thu, 19 Oct 2023 19:06:52 +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 1qtYM4-0065de-9u for pgsql-admin@arkaria.postgresql.org; Thu, 19 Oct 2023 19:06:48 +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 1qtYM3-0065dW-Tj for pgsql-admin@lists.postgresql.org; Thu, 19 Oct 2023 19:06:48 +0000 Received: from mail-yb1-xb2d.google.com ([2607:f8b0:4864:20::b2d]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1qtYM0-001ark-4Q for pgsql-admin@lists.postgresql.org; Thu, 19 Oct 2023 19:06:48 +0000 Received: by mail-yb1-xb2d.google.com with SMTP id 3f1490d57ef6-d84c24a810dso33410276.2 for ; Thu, 19 Oct 2023 12:06:44 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1697742403; x=1698347203; 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=0Sz65NFWZRYyeCBSDkeWBSn17TRzit4LFNDq+aTFXR8=; b=MLYrAB0b3+7gu2BoxsOzCb8Wezm0ajQA+624AQOm3jTpem6SJ7+bSCJtD82b1TflWT Qkq1Gz/dD6zbPJ4XE/7IvKsgcLzRToMxhnYCz+uMBrjjjOa8KJUYVTKeSfLpZqq7jseG YWFhw3HjZARaSnMmPudkMTYxtzWLRU4pPVdeABbFUftKoK/DkFcutqZee46d9A29ztzf MQsOSE9sg/IPhQSxElOLR7g+MOkpxb7Xu6idO8rDQDRIgjTplt/OGSM9hI9B8sZqFFX9 5ZqjwKrm4DmKVK836FdTBhEl4VtVzF8X0pKAO5K/yQ7qNzbFUHcYNTomMgrccEZu2ztC vTDQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1697742403; x=1698347203; 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=0Sz65NFWZRYyeCBSDkeWBSn17TRzit4LFNDq+aTFXR8=; b=SWi2uC1yupajWgMCAs2tFY4xgW9YXKfof9W/Q9e1oR1eJW+yIUTETbttHyVq5Zzjhh SU1AcftSPqm5zC48a/K7Csuy/MAxfpLd2flBsDgkfQRoObwhTM3RD/UHNT2TS2zsF/5y HHRMWLQc6/D7KprdX+xTL7dTvfz+MVZqF8ncQMUoqzqNXO+xoZxMPRficJl32XAs1rqc uHWiNpBU+lqhxEX8ebGIzHWrFlgHKoDXDuRNRfseOmMk8Vpf3sWQIcF46DzSvTvZV4Yn DptlPBzrbsHC+3MhcgpvTcbG47FFw6sizZgsWptwRSD+Bu293JJxLiYKZi1QkdjXGihj QK4g== X-Gm-Message-State: AOJu0YwFJot8Mn4ecmBOGrThKwHALx0p696JsHyPLe8LZaOQJNdeJ+kW oN7Xsd0JbWbXvXu0zt2P1XjLOOiA7Vg= X-Google-Smtp-Source: AGHT+IFuUOt2FRHc29aoqR4WHx1THU8Os7lKmPYlVdgHw4dXIhezStHiLymeMXxYzhuxq0cODUlU6A== X-Received: by 2002:a5b:52:0:b0:d9a:568b:b7c5 with SMTP id e18-20020a5b0052000000b00d9a568bb7c5mr3346568ybp.29.1697742402940; Thu, 19 Oct 2023 12:06:42 -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 205-20020a2505d6000000b00d814d8dfd69sm16395ybf.27.2023.10.19.12.06.42 for (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Thu, 19 Oct 2023 12:06:42 -0700 (PDT) Content-Type: multipart/alternative; boundary="------------060oD5dunflGHvSZWDNT0Gyt" Message-ID: <1dac15f4-51b3-4aac-bd5c-bf773b64e189@gmail.com> Date: Thu, 19 Oct 2023 14:06:42 -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> From: Ron In-Reply-To: <52456b74-c817-42b3-91f9-6c656d9413c5@uvic.ca> 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. --------------060oD5dunflGHvSZWDNT0Gyt Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 8bit 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: >> Notice: This message was sent from outside the University of Victoria >> email system. Please be cautious with links and sensitive information. >> >> 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. > > > -- > Evan Rempel 250.721.7691 > Senior Systems Administratorerempel@uvic.ca > Data Centre Services, University Systems, University of Victoria -- Born in Arizona, moved to Babylonia. --------------060oD5dunflGHvSZWDNT0Gyt Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: 8bit 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:
Notice: This message was sent from outside the University of Victoria email system. Please be cautious with links and sensitive information.

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.


-- 
Evan Rempel                                         250.721.7691
Senior Systems Administrator                     erempel@uvic.ca
Data Centre Services, University Systems, University of Victoria

--
Born in Arizona, moved to Babylonia.
--------------060oD5dunflGHvSZWDNT0Gyt--