Re: OS rpms needed to support install of postgres 15

[Ron <ronljohnsonjr@xxxxxxxxx>]

On 5/11/23 15:45, chrisp@xxxxxxxxxxxx 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.