Обсуждение: Binaries for EOL version?

Поиск
Список
Период
Сортировка

Binaries for EOL version?

От
Ron
Дата:

I might need to install amcheck on a RHEL 6 server running Pg 9.6.24.  (Yes, I know... don't say it.)

However, I don't see anything older than 11 in https://yum.postgresql.org.  Example:
https://yum.postgresql.org/11/redhat/rhel-6-x86_64/repoview/

Have the binaries been deleted or are they in some publicly available, but not publicized, archive?

--
Born in Arizona, moved to Babylonia.

RE: Binaries for EOL version?

От
HALAT-PRUVOT SYLVIE
Дата:

Hi Ron,

 

Maybe you will find packages … 

 

https://yum.postgresql.org/repopackages/#pgredhatoldrepos

 

S. Halat

 

 

De : Ron <ronljohnsonjr@gmail.com>
Envoyé : jeudi 19 octobre 2023 17:42
À : pgsql-admin <pgsql-admin@postgresql.org>
Objet : Binaries for EOL version?

 


I might need to install amcheck on a RHEL 6 server running Pg 9.6.24.  (Yes, I know... don't say it.)

However, I don't see anything older than 11 in https://yum.postgresql.org.  Example:
https://yum.postgresql.org/11/redhat/rhel-6-x86_64/repoview/

Have the binaries been deleted or are they in some publicly available, but not publicized, archive?

--
Born in Arizona, moved to Babylonia.

Re: Binaries for EOL version?

От
Ron
Дата:
That should be what I want (thank you!), but, for example, browsing to https://yum-archive.postgresql.org/9.6/redhat/rhel-6-x86_64 returns Access Denied.

<Error>
<Code>AccessDenied</Code>
<Message>Access Denied</Message>
<RequestId>DAVE3W4HG6Y2JBD2</RequestId>
<HostId>oEFzdpmkJwgR0JgTK9MMI29eWBHSw0mpTFlxDtdOUpJAxcVq3oRj0aXQFQoK9dhXU/ksMoxFwF0=</HostId>
</Error>


On 10/19/23 10:57, HALAT-PRUVOT SYLVIE wrote:
@font-face {font-family:"Cambria Math"; panose-1:2 4 5 3 5 4 6 3 2 4;}@font-face {font-family:Calibri; panose-1:2 15 5 2 2 2 4 3 2 4;}p.MsoNormal, li.MsoNormal, div.MsoNormal {margin:0cm; margin-bottom:.0001pt; font-size:12.0pt; font-family:"Times New Roman",serif;}a:link, span.MsoHyperlink {mso-style-priority:99; color:blue; text-decoration:underline;}a:visited, span.MsoHyperlinkFollowed {mso-style-priority:99; color:purple; text-decoration:underline;}p.msonormal0, li.msonormal0, div.msonormal0 {mso-style-name:msonormal; mso-margin-top-alt:auto; margin-right:0cm; mso-margin-bottom-alt:auto; margin-left:0cm; font-size:12.0pt; font-family:"Times New Roman",serif;}span.EmailStyle18 {mso-style-type:personal-reply; font-family:"Calibri",sans-serif; color:#1F497D;}.MsoChpDefault {mso-style-type:export-only; font-size:10.0pt;}div.WordSection1 {page:WordSection1;}

Hi Ron,

 

Maybe you will find packages … 

 

https://yum.postgresql.org/repopackages/#pgredhatoldrepos

 

S. Halat

 

 

De : Ron <ronljohnsonjr@gmail.com>
Envoyé : jeudi 19 octobre 2023 17:42
À : pgsql-admin <pgsql-admin@postgresql.org>
Objet : Binaries for EOL version?

 


I might need to install amcheck on a RHEL 6 server running Pg 9.6.24.  (Yes, I know... don't say it.)

However, I don't see anything older than 11 in https://yum.postgresql.org.  Example:
https://yum.postgresql.org/11/redhat/rhel-6-x86_64/repoview/

Have the binaries been deleted or are they in some publicly available, but not publicized, archive?

--
Born in Arizona, moved to Babylonia.


--
Born in Arizona, moved to Babylonia.

Re: Binaries for EOL version?

От
Thomas Kellerer
Дата:
Ron schrieb am 19.10.2023 um 17:41:
>
> I might need to install amcheck on a RHEL 6 server running Pg 9.6.24.  (Yes, I know... don't say it.)
>
> However, I don't see anything older than 11 in https://yum.postgresql.org.  Example:
> https://yum.postgresql.org/11/redhat/rhel-6-x86_64/repoview/
>
> Have the binaries been /deleted/ or are they in some publicly available, but not publicized, archive?

EDB keeps binaries around

https://www.enterprisedb.com/download-postgresql-binaries





Re: Binaries for EOL version?

От
Ron
Дата:
On 10/19/23 11:22, Thomas Kellerer wrote:
> Ron schrieb am 19.10.2023 um 17:41:
>>
>> I might need to install amcheck on a RHEL 6 server running Pg 9.6.24.  
>> (Yes, I know... don't say it.)
>>
>> However, I don't see anything older than 11 in 
>> https://yum.postgresql.org.  Example:
>> https://yum.postgresql.org/11/redhat/rhel-6-x86_64/repoview/
>>
>> Have the binaries been /deleted/ or are they in some publicly available, 
>> but not publicized, archive?
>
> EDB keeps binaries around
>
> https://www.enterprisedb.com/download-postgresql-binaries

Thanks.  postgresql-9.6.24-1-linux-x64-binaries.tar.gz doesn't seem to have 
amcheck, though.

-- 
Born in Arizona, moved to Babylonia.



Re: Binaries for EOL version?

От
Tom Lane
Дата:
Ron <ronljohnsonjr@gmail.com> writes:
> Thanks.  postgresql-9.6.24-1-linux-x64-binaries.tar.gz doesn't seem to have
> amcheck, though.

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 - maybe github? -
and very likely compile from source.

            regards, tom lane



Re: Binaries for EOL version?

От
Ron
Дата:
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.

Re: Binaries for EOL version?

От
Evan Rempel
Дата:
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

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

Re: Binaries for EOL version?

От
Ron
Дата:
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

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.

Re: Binaries for EOL version?

От
Evan Rempel
Дата:
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

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.

Re: Binaries for EOL version?

От
Ron
Дата:
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

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.

Re: Binaries for EOL version?

От
Evan Rempel
Дата:
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

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.

Re: Binaries for EOL version?

От
Ron
Дата:
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

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.

Re: Binaries for EOL version?

От
Evan Rempel
Дата:
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.

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.

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

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.

Re: Binaries for EOL version?

От
Ron
Дата:
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

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.