Re: Install PostgreSQL 17 by rpm

On Wed, Feb 26, 2025 at 7:08 AM Loles Ferrándiz DBA <
lolesferrandizdba(at)gmail(dot)com> wrote:

> Greetings to all.
>
> I wanted to ask if there is a way to install PostgreSQL packages on Linux
> without an Internet connection, that is, whether to use the repositories.
>
> There are clients who do not want to enable Internet access on their
> servers and I need to install PostgreSQL from packages with rpm.
>

I'm in the exact same situation. Thus, I directly download the relevant
RPM packages to my laptop, then scp them to a "version subdirectory" on the
Linux hosts.
"sudo yum install PGx.y_RHELz/*rpm" installs them.

These are the PowerShell commands which I used a few days ago to download
the PG 16.8 packages for RHEL9. Add or remove packages, change to RHEL8,
or even RHEL7 as you see fit. Some version numbers will though.

$RHRelInFile='rhel9'
$RHRelInURL='rhel-9'
$RHRelInURL2=$RHRelInURL
$PgMajorVer='16'
$PGVer="${PgMajorVer}.8"
$PGDGv1="1PGDG"
$PGDGv4="4PGDG"
function Get-RPM
{
$site = $args[0]
$f = $args[1]
write-host $site$f
wget $site$f -outfile $f
}
$PathRoot=$env:USERPROFILE+'\Documents\Database Installers\Postgresql\'
$CurPath=$PathRoot+'Pg'+$PGVer+'_'+$RHRelInFile.ToUpper()
If(!(test-path -PathType container $CurPath))
{
New-Item -Path $CurPath -ItemType Directory
}
Set-Location -Path $CurPath
$page="
https://download.postgresql.org/pub/repos/yum/common/redhat/${RHRelInURL2}-x86_64/
"
get-RPM $page "check_postgres-2.25.0-3.${RHRelInFile}.noarch.rpm"
get-RPM $page "pgbackrest-2.54.2-${PGDGv1}.${RHRelInFile}.x86_64.rpm"
get-RPM $page "pgcluu-4.0-${PGDGv1}.${RHRelInFile}.noarch.rpm"
$page="
https://download.postgresql.org/pub/repos/yum/${PgMajorVer}/redhat/${RHRelInURL}-x86_64/
"
get-RPM $page
"pg_repack_${PgMajorVer}-1.5.2-${PGDGv1}.${RHRelInFile}.x86_64.rpm"
get-RPM $page
"pgaudit_${PgMajorVer}-16.0-${PGDGv1}.${RHRelInFile}.x86_64.rpm"
get-RPM $page
"plpgsql_check_${PgMajorVer}-2.7.8-${PGDGv1}.${RHRelInFile}.x86_64.rpm"
get-RPM $page
"plsh_${PgMajorVer}-1.20220917-${PGDGv4}.${RHRelInFile}.x86_64.rpm"
get-RPM $page
"postgresql${PgMajorVer}-${PGVer}-${PGDGv1}.${RHRelInFile}.x86_64.rpm"
get-RPM $page
"postgresql${PgMajorVer}-contrib-${PGVer}-${PGDGv1}.${RHRelInFile}.x86_64.rpm"
get-RPM $page
"postgresql${PgMajorVer}-docs-${PGVer}-${PGDGv1}.${RHRelInFile}.x86_64.rpm"
get-RPM $page
"postgresql${PgMajorVer}-libs-${PGVer}-${PGDGv1}.${RHRelInFile}.x86_64.rpm"
get-RPM $page
"postgresql${PgMajorVer}-plperl-${PGVer}-${PGDGv1}.${RHRelInFile}.x86_64.rpm"
get-RPM $page
"postgresql${PgMajorVer}-plpython3-${PGVer}-${PGDGv1}.${RHRelInFile}.x86_64.rpm"
get-RPM $page
"postgresql${PgMajorVer}-server-${PGVer}-${PGDGv1}.${RHRelInFile}.x86_64.rpm"

--
Death to <Redacted>, and butter sauce.
Don't boil me, I'm still alive.
<Redacted> lobster!