pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedBinaries for EOL version?
15+ messages / 5 participants
[nested] [flat]
* Binaries for EOL version?
@ 2023-10-19 15:41 Ron <ronljohnsonjr@gmail.com>
2023-10-19 15:57 ` RE: Binaries for EOL version? HALAT-PRUVOT SYLVIE <sylvie.halat-pruvot@region-academique-occitanie.fr>
2023-10-19 16:22 ` Re: Binaries for EOL version? Thomas Kellerer <shammat@gmx.net>
0 siblings, 2 replies; 15+ messages in thread
From: Ron @ 2023-10-19 15:41 UTC (permalink / raw)
To: pgsql-admin
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.
^ permalink raw reply [nested|flat] 15+ messages in thread
* RE: Binaries for EOL version?
2023-10-19 15:41 Binaries for EOL version? Ron <ronljohnsonjr@gmail.com>
@ 2023-10-19 15:57 ` HALAT-PRUVOT SYLVIE <sylvie.halat-pruvot@region-academique-occitanie.fr>
2023-10-19 16:13 ` Re: Binaries for EOL version? Ron <ronljohnsonjr@gmail.com>
1 sibling, 1 reply; 15+ messages in thread
From: HALAT-PRUVOT SYLVIE @ 2023-10-19 15:57 UTC (permalink / raw)
To: Ron <ronljohnsonjr@gmail.com>; +Cc: pgsql-admin
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.
^ permalink raw reply [nested|flat] 15+ messages in thread
* Re: Binaries for EOL version?
2023-10-19 15:41 Binaries for EOL version? Ron <ronljohnsonjr@gmail.com>
2023-10-19 15:57 ` RE: Binaries for EOL version? HALAT-PRUVOT SYLVIE <sylvie.halat-pruvot@region-academique-occitanie.fr>
@ 2023-10-19 16:13 ` Ron <ronljohnsonjr@gmail.com>
0 siblings, 0 replies; 15+ messages in thread
From: Ron @ 2023-10-19 16:13 UTC (permalink / raw)
To: pgsql-admin
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:
>
> 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.
^ permalink raw reply [nested|flat] 15+ messages in thread
* Re: Binaries for EOL version?
2023-10-19 15:41 Binaries for EOL version? Ron <ronljohnsonjr@gmail.com>
@ 2023-10-19 16:22 ` Thomas Kellerer <shammat@gmx.net>
2023-10-19 17:03 ` Re: Binaries for EOL version? Ron <ronljohnsonjr@gmail.com>
1 sibling, 1 reply; 15+ messages in thread
From: Thomas Kellerer @ 2023-10-19 16:22 UTC (permalink / raw)
To: pgsql-admin@lists.postgresql.org
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
^ permalink raw reply [nested|flat] 15+ messages in thread
* Re: Binaries for EOL version?
2023-10-19 15:41 Binaries for EOL version? Ron <ronljohnsonjr@gmail.com>
2023-10-19 16:22 ` Re: Binaries for EOL version? Thomas Kellerer <shammat@gmx.net>
@ 2023-10-19 17:03 ` Ron <ronljohnsonjr@gmail.com>
2023-10-19 17:30 ` Re: Binaries for EOL version? Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 1 reply; 15+ messages in thread
From: Ron @ 2023-10-19 17:03 UTC (permalink / raw)
To: pgsql-admin@lists.postgresql.org
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.
^ permalink raw reply [nested|flat] 15+ messages in thread
* Re: Binaries for EOL version?
2023-10-19 15:41 Binaries for EOL version? Ron <ronljohnsonjr@gmail.com>
2023-10-19 16:22 ` Re: Binaries for EOL version? Thomas Kellerer <shammat@gmx.net>
2023-10-19 17:03 ` Re: Binaries for EOL version? Ron <ronljohnsonjr@gmail.com>
@ 2023-10-19 17:30 ` Tom Lane <tgl@sss.pgh.pa.us>
2023-10-19 17:54 ` Re: Binaries for EOL version? Ron <ronljohnsonjr@gmail.com>
0 siblings, 1 reply; 15+ messages in thread
From: Tom Lane @ 2023-10-19 17:30 UTC (permalink / raw)
To: Ron <ronljohnsonjr@gmail.com>; +Cc: pgsql-admin@lists.postgresql.org
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
^ permalink raw reply [nested|flat] 15+ messages in thread
* Re: Binaries for EOL version?
2023-10-19 15:41 Binaries for EOL version? Ron <ronljohnsonjr@gmail.com>
2023-10-19 16:22 ` Re: Binaries for EOL version? Thomas Kellerer <shammat@gmx.net>
2023-10-19 17:03 ` Re: Binaries for EOL version? Ron <ronljohnsonjr@gmail.com>
2023-10-19 17:30 ` Re: Binaries for EOL version? Tom Lane <tgl@sss.pgh.pa.us>
@ 2023-10-19 17:54 ` Ron <ronljohnsonjr@gmail.com>
2023-10-19 18:38 ` Re: Binaries for EOL version? Evan Rempel <erempel@uvic.ca>
0 siblings, 1 reply; 15+ messages in thread
From: Ron @ 2023-10-19 17:54 UTC (permalink / raw)
To: pgsql-admin@lists.postgresql.org
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.
^ permalink raw reply [nested|flat] 15+ messages in thread
* Re: Binaries for EOL version?
2023-10-19 15:41 Binaries for EOL version? Ron <ronljohnsonjr@gmail.com>
2023-10-19 16:22 ` Re: Binaries for EOL version? Thomas Kellerer <shammat@gmx.net>
2023-10-19 17:03 ` Re: Binaries for EOL version? Ron <ronljohnsonjr@gmail.com>
2023-10-19 17:30 ` Re: Binaries for EOL version? Tom Lane <tgl@sss.pgh.pa.us>
2023-10-19 17:54 ` Re: Binaries for EOL version? Ron <ronljohnsonjr@gmail.com>
@ 2023-10-19 18:38 ` Evan Rempel <erempel@uvic.ca>
2023-10-19 19:06 ` Re: Binaries for EOL version? Ron <ronljohnsonjr@gmail.com>
0 siblings, 1 reply; 15+ messages in thread
From: Evan Rempel @ 2023-10-19 18:38 UTC (permalink / raw)
To: pgsql-admin@lists.postgresql.org
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
^ permalink raw reply [nested|flat] 15+ messages in thread
* Re: Binaries for EOL version?
2023-10-19 15:41 Binaries for EOL version? Ron <ronljohnsonjr@gmail.com>
2023-10-19 16:22 ` Re: Binaries for EOL version? Thomas Kellerer <shammat@gmx.net>
2023-10-19 17:03 ` Re: Binaries for EOL version? Ron <ronljohnsonjr@gmail.com>
2023-10-19 17:30 ` Re: Binaries for EOL version? Tom Lane <tgl@sss.pgh.pa.us>
2023-10-19 17:54 ` Re: Binaries for EOL version? Ron <ronljohnsonjr@gmail.com>
2023-10-19 18:38 ` Re: Binaries for EOL version? Evan Rempel <erempel@uvic.ca>
@ 2023-10-19 19:06 ` Ron <ronljohnsonjr@gmail.com>
2023-10-19 19:44 ` Re: Binaries for EOL version? Evan Rempel <erempel@uvic.ca>
0 siblings, 1 reply; 15+ messages in thread
From: Ron @ 2023-10-19 19:06 UTC (permalink / raw)
To: pgsql-admin@lists.postgresql.org
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.
^ permalink raw reply [nested|flat] 15+ messages in thread
* Re: Binaries for EOL version?
2023-10-19 15:41 Binaries for EOL version? Ron <ronljohnsonjr@gmail.com>
2023-10-19 16:22 ` Re: Binaries for EOL version? Thomas Kellerer <shammat@gmx.net>
2023-10-19 17:03 ` Re: Binaries for EOL version? Ron <ronljohnsonjr@gmail.com>
2023-10-19 17:30 ` Re: Binaries for EOL version? Tom Lane <tgl@sss.pgh.pa.us>
2023-10-19 17:54 ` Re: Binaries for EOL version? Ron <ronljohnsonjr@gmail.com>
2023-10-19 18:38 ` Re: Binaries for EOL version? Evan Rempel <erempel@uvic.ca>
2023-10-19 19:06 ` Re: Binaries for EOL version? Ron <ronljohnsonjr@gmail.com>
@ 2023-10-19 19:44 ` Evan Rempel <erempel@uvic.ca>
2023-10-19 20:02 ` Re: Binaries for EOL version? Ron <ronljohnsonjr@gmail.com>
0 siblings, 1 reply; 15+ messages in thread
From: Evan Rempel @ 2023-10-19 19:44 UTC (permalink / raw)
To: pgsql-admin@lists.postgresql.org
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.
^ permalink raw reply [nested|flat] 15+ messages in thread
* Re: Binaries for EOL version?
2023-10-19 15:41 Binaries for EOL version? Ron <ronljohnsonjr@gmail.com>
2023-10-19 16:22 ` Re: Binaries for EOL version? Thomas Kellerer <shammat@gmx.net>
2023-10-19 17:03 ` Re: Binaries for EOL version? Ron <ronljohnsonjr@gmail.com>
2023-10-19 17:30 ` Re: Binaries for EOL version? Tom Lane <tgl@sss.pgh.pa.us>
2023-10-19 17:54 ` Re: Binaries for EOL version? Ron <ronljohnsonjr@gmail.com>
2023-10-19 18:38 ` Re: Binaries for EOL version? Evan Rempel <erempel@uvic.ca>
2023-10-19 19:06 ` Re: Binaries for EOL version? Ron <ronljohnsonjr@gmail.com>
2023-10-19 19:44 ` Re: Binaries for EOL version? Evan Rempel <erempel@uvic.ca>
@ 2023-10-19 20:02 ` Ron <ronljohnsonjr@gmail.com>
2023-10-19 20:21 ` Re: Binaries for EOL version? Evan Rempel <erempel@uvic.ca>
0 siblings, 1 reply; 15+ messages in thread
From: Ron @ 2023-10-19 20:02 UTC (permalink / raw)
To: pgsql-admin@lists.postgresql.org
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.
^ permalink raw reply [nested|flat] 15+ messages in thread
* Re: Binaries for EOL version?
2023-10-19 15:41 Binaries for EOL version? Ron <ronljohnsonjr@gmail.com>
2023-10-19 16:22 ` Re: Binaries for EOL version? Thomas Kellerer <shammat@gmx.net>
2023-10-19 17:03 ` Re: Binaries for EOL version? Ron <ronljohnsonjr@gmail.com>
2023-10-19 17:30 ` Re: Binaries for EOL version? Tom Lane <tgl@sss.pgh.pa.us>
2023-10-19 17:54 ` Re: Binaries for EOL version? Ron <ronljohnsonjr@gmail.com>
2023-10-19 18:38 ` Re: Binaries for EOL version? Evan Rempel <erempel@uvic.ca>
2023-10-19 19:06 ` Re: Binaries for EOL version? Ron <ronljohnsonjr@gmail.com>
2023-10-19 19:44 ` Re: Binaries for EOL version? Evan Rempel <erempel@uvic.ca>
2023-10-19 20:02 ` Re: Binaries for EOL version? Ron <ronljohnsonjr@gmail.com>
@ 2023-10-19 20:21 ` Evan Rempel <erempel@uvic.ca>
2023-10-19 21:05 ` Re: Binaries for EOL version? Ron <ronljohnsonjr@gmail.com>
0 siblings, 1 reply; 15+ messages in thread
From: Evan Rempel @ 2023-10-19 20:21 UTC (permalink / raw)
To: pgsql-admin@lists.postgresql.org
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.
^ permalink raw reply [nested|flat] 15+ messages in thread
* Re: Binaries for EOL version?
2023-10-19 15:41 Binaries for EOL version? Ron <ronljohnsonjr@gmail.com>
2023-10-19 16:22 ` Re: Binaries for EOL version? Thomas Kellerer <shammat@gmx.net>
2023-10-19 17:03 ` Re: Binaries for EOL version? Ron <ronljohnsonjr@gmail.com>
2023-10-19 17:30 ` Re: Binaries for EOL version? Tom Lane <tgl@sss.pgh.pa.us>
2023-10-19 17:54 ` Re: Binaries for EOL version? Ron <ronljohnsonjr@gmail.com>
2023-10-19 18:38 ` Re: Binaries for EOL version? Evan Rempel <erempel@uvic.ca>
2023-10-19 19:06 ` Re: Binaries for EOL version? Ron <ronljohnsonjr@gmail.com>
2023-10-19 19:44 ` Re: Binaries for EOL version? Evan Rempel <erempel@uvic.ca>
2023-10-19 20:02 ` Re: Binaries for EOL version? Ron <ronljohnsonjr@gmail.com>
2023-10-19 20:21 ` Re: Binaries for EOL version? Evan Rempel <erempel@uvic.ca>
@ 2023-10-19 21:05 ` Ron <ronljohnsonjr@gmail.com>
2023-10-19 21:12 ` Re: Binaries for EOL version? Evan Rempel <erempel@uvic.ca>
0 siblings, 1 reply; 15+ messages in thread
From: Ron @ 2023-10-19 21:05 UTC (permalink / raw)
To: pgsql-admin@lists.postgresql.org
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.
^ permalink raw reply [nested|flat] 15+ messages in thread
* Re: Binaries for EOL version?
2023-10-19 15:41 Binaries for EOL version? Ron <ronljohnsonjr@gmail.com>
2023-10-19 16:22 ` Re: Binaries for EOL version? Thomas Kellerer <shammat@gmx.net>
2023-10-19 17:03 ` Re: Binaries for EOL version? Ron <ronljohnsonjr@gmail.com>
2023-10-19 17:30 ` Re: Binaries for EOL version? Tom Lane <tgl@sss.pgh.pa.us>
2023-10-19 17:54 ` Re: Binaries for EOL version? Ron <ronljohnsonjr@gmail.com>
2023-10-19 18:38 ` Re: Binaries for EOL version? Evan Rempel <erempel@uvic.ca>
2023-10-19 19:06 ` Re: Binaries for EOL version? Ron <ronljohnsonjr@gmail.com>
2023-10-19 19:44 ` Re: Binaries for EOL version? Evan Rempel <erempel@uvic.ca>
2023-10-19 20:02 ` Re: Binaries for EOL version? Ron <ronljohnsonjr@gmail.com>
2023-10-19 20:21 ` Re: Binaries for EOL version? Evan Rempel <erempel@uvic.ca>
2023-10-19 21:05 ` Re: Binaries for EOL version? Ron <ronljohnsonjr@gmail.com>
@ 2023-10-19 21:12 ` Evan Rempel <erempel@uvic.ca>
2023-10-20 02:58 ` Re: Binaries for EOL version? Ron <ronljohnsonjr@gmail.com>
0 siblings, 1 reply; 15+ messages in thread
From: Evan Rempel @ 2023-10-19 21:12 UTC (permalink / raw)
To: pgsql-admin@lists.postgresql.org
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
>>>>>> 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.
^ permalink raw reply [nested|flat] 15+ messages in thread
* Re: Binaries for EOL version?
2023-10-19 15:41 Binaries for EOL version? Ron <ronljohnsonjr@gmail.com>
2023-10-19 16:22 ` Re: Binaries for EOL version? Thomas Kellerer <shammat@gmx.net>
2023-10-19 17:03 ` Re: Binaries for EOL version? Ron <ronljohnsonjr@gmail.com>
2023-10-19 17:30 ` Re: Binaries for EOL version? Tom Lane <tgl@sss.pgh.pa.us>
2023-10-19 17:54 ` Re: Binaries for EOL version? Ron <ronljohnsonjr@gmail.com>
2023-10-19 18:38 ` Re: Binaries for EOL version? Evan Rempel <erempel@uvic.ca>
2023-10-19 19:06 ` Re: Binaries for EOL version? Ron <ronljohnsonjr@gmail.com>
2023-10-19 19:44 ` Re: Binaries for EOL version? Evan Rempel <erempel@uvic.ca>
2023-10-19 20:02 ` Re: Binaries for EOL version? Ron <ronljohnsonjr@gmail.com>
2023-10-19 20:21 ` Re: Binaries for EOL version? Evan Rempel <erempel@uvic.ca>
2023-10-19 21:05 ` Re: Binaries for EOL version? Ron <ronljohnsonjr@gmail.com>
2023-10-19 21:12 ` Re: Binaries for EOL version? Evan Rempel <erempel@uvic.ca>
@ 2023-10-20 02:58 ` Ron <ronljohnsonjr@gmail.com>
0 siblings, 0 replies; 15+ messages in thread
From: Ron @ 2023-10-20 02:58 UTC (permalink / raw)
To: pgsql-admin@lists.postgresql.org
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.
^ permalink raw reply [nested|flat] 15+ messages in thread
end of thread, other threads:[~2023-10-20 02:58 UTC | newest]
Thread overview: 15+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2023-10-19 15:41 Binaries for EOL version? Ron <ronljohnsonjr@gmail.com>
2023-10-19 15:57 ` HALAT-PRUVOT SYLVIE <sylvie.halat-pruvot@region-academique-occitanie.fr>
2023-10-19 16:13 ` Ron <ronljohnsonjr@gmail.com>
2023-10-19 16:22 ` Thomas Kellerer <shammat@gmx.net>
2023-10-19 17:03 ` Ron <ronljohnsonjr@gmail.com>
2023-10-19 17:30 ` Tom Lane <tgl@sss.pgh.pa.us>
2023-10-19 17:54 ` Ron <ronljohnsonjr@gmail.com>
2023-10-19 18:38 ` Evan Rempel <erempel@uvic.ca>
2023-10-19 19:06 ` Ron <ronljohnsonjr@gmail.com>
2023-10-19 19:44 ` Evan Rempel <erempel@uvic.ca>
2023-10-19 20:02 ` Ron <ronljohnsonjr@gmail.com>
2023-10-19 20:21 ` Evan Rempel <erempel@uvic.ca>
2023-10-19 21:05 ` Ron <ronljohnsonjr@gmail.com>
2023-10-19 21:12 ` Evan Rempel <erempel@uvic.ca>
2023-10-20 02:58 ` Ron <ronljohnsonjr@gmail.com>
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