From: Ron <ronljohnsonjr@gmail.com>
To: pgsql-admin@lists.postgresql.org
Subject: Re: OS rpms needed to support install of postgres 15
Date: Thu, 11 May 2023 16:23:34 -0500
Message-ID: <e8287cee-2107-eb1e-6b19-9a20576a61de@gmail.com> (raw)
In-Reply-To: <20230511144535.Horde.VWK-k7xlnMXEQ06V-Dls3A5@webmail.xmission.com>
References: <168383672314.1024.10224590160904708012@malur.postgresql.org>
<20230511144535.Horde.VWK-k7xlnMXEQ06V-Dls3A5@webmail.xmission.com>
On 5/11/23 15:45, chrisp@xmission.com wrote:
>
>
> I want to install Postgres 15 in Red hat 7 and alpine 3.17. My machines
> do not have internet access. I also want to keep the OS/software footprint
> as small possible (not install the complete OS repo).
>
> Anyone know of a weblink showing the needed OS rpms and their dependent
> rpms needed to support a Postgres 15 deploy for Redhat 7 and alpine 3.17?
I'm in your "My machines do not have internet access" situation, too, so
wrote this PowerShell script to download the RPM files I need. You'll need
to modify for version numbers and download directory.
$RHFileVer='rhel8'
$RHSiteVer='rhel-8.6'
$RHSiteVer2='rhel-8'
$PGVer='13.10'
function Get-RPM
{
$site = $args[0]
$f = $args[1]
write-host $site$f
wget $site$f -outfile $f
}
$PathRoot='C:\Users\Me\Documents\Database Install Files\Postgresql\'
$CurPath=$PathRoot+'Pg'+$PGVer+'_'+$RHFileVer.ToUpper()
New-Item -Path $CurPath -ItemType Directory
Set-Location -Path $CurPath
$page="https://download.postgresql.org/pub/repos/yum/common/redhat/${RHSiteVer2}-x86_64/"
get-RPM $page "check_postgres-2.25.0-2.${RHFileVer}.noarch.rpm"
get-RPM $page "pgbackrest-2.44-1.${RHFileVer}.x86_64.rpm"
$page="https://download.postgresql.org/pub/repos/yum/13/redhat/${RHSiteVer}-x86_64/"
get-RPM $page "pg_top_13-3.7.0-6.${RHFileVer}.x86_64.rpm"
get-RPM $page "pgaudit15_13-1.5.2-1.${RHFileVer}.x86_64.rpm"
get-RPM $page "plpgsql_check_13-2.3.0-1.${RHFileVer}.x86_64.rpm"
get-RPM $page "postgresql13-${PGVer}-1PGDG.${RHFileVer}.x86_64.rpm"
get-RPM $page "postgresql13-contrib-${PGVer}-1PGDG.${RHFileVer}.x86_64.rpm"
get-RPM $page "postgresql13-docs-${PGVer}-1PGDG.${RHFileVer}.x86_64.rpm"
get-RPM $page "postgresql13-libs-${PGVer}-1PGDG.${RHFileVer}.x86_64.rpm"
get-RPM $page "postgresql13-server-${PGVer}-1PGDG.${RHFileVer}.x86_64.rpm"
--
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: OS rpms needed to support install of postgres 15
In-Reply-To: <e8287cee-2107-eb1e-6b19-9a20576a61de@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