Message-ID: <e8287cee-2107-eb1e-6b19-9a20576a61de@gmail.com>
Date: Thu, 11 May 2023 16:23:34 -0500
MIME-Version: 1.0
User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:102.0) Gecko/20100101
 Thunderbird/102.10.0
Subject: Re: OS rpms needed to support install of postgres 15
Content-Language: en-US
To: pgsql-admin@lists.postgresql.org
References: <168383672314.1024.10224590160904708012@malur.postgresql.org>
 <20230511144535.Horde.VWK-k7xlnMXEQ06V-Dls3A5@webmail.xmission.com>
From: Ron <ronljohnsonjr@gmail.com>
In-Reply-To: 
 <20230511144535.Horde.VWK-k7xlnMXEQ06V-Dls3A5@webmail.xmission.com>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 8bit
Archived-At: 
 <https://www.postgresql.org/message-id/e8287cee-2107-eb1e-6b19-9a20576a61de%40gmail.com>
Precedence: bulk

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.