Postgres Pro
Downloads
Home   >   mailing lists

Re: Install PostgreSQL 17 by rpm - Mailing list pgsql-admin

From Ron Johnson
Subject Re: Install PostgreSQL 17 by rpm
Date
Msg-id CANzqJaCO8dpEBNQnEJbCA=sZP6wBwu5AKKoW51sRSR3TrpDWhw@mail.gmail.com
Whole thread Raw
In response to Install PostgreSQL 17 by rpm  (Loles Ferrándiz DBA <lolesferrandizdba@gmail.com>)
List pgsql-admin
Tree view
On Wed, Feb 26, 2025 at 7:08 AM Loles Ferrándiz DBA <lolesferrandizdba@gmail.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!

pgsql-admin by date:

Previous
From: "alexander al (leiden)"
Date:
Subject: Monitoring postgresql 14 in a paasrole
Next
From: Frank Zhou
Date:
Subject: Re: Monitoring postgresql 14 in a paasrole