Re: Installing PostGreSQLon Redhat Linux - Help needed

[Ron <ronljohnsonjr@xxxxxxxxx>]

    On 3/27/23 11:32, Sendhu Sendhu wrote:

Hey,

I need some help installing and configuring PostGreSQL on Redhat Linux. We can't install from source as the Internet is unavailable. I have looked into download and manual install, but am having hard time finding the required RPMs' and instructions. Can someone please help ?

https://download.postgresql.org/pub/repos/yum/common/redhat/rhel-9-x86_64/

    I had the same problem, so wrote this PowerShell script (that you will
    have to modify).

--
Born in Arizona, moved to Babylonia.

$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\A467197\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"
get-RPM $page "pgcluu-3.4-1.${RHFileVer}.noarch.rpm"
#get-RPM $page "pgbouncer-1.17.0-10.${RHFileVer}.x86_64.rpm"

$page="https://download.postgresql.org/pub/repos/yum/13/redhat/${RHSiteVer}-x86_64/";

#get-RPM $page "amcheck_next96-1.5-1.${RHFileVer}.x86_64.rpm"
get-RPM $page "pg_repack_13-1.4.8-1.${RHFileVer}.x86_64.rpm"
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 "plsh_13-1.20220917-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-plperl-${PGVer}-1PGDG.${RHFileVer}.x86_64.rpm"
get-RPM $page "postgresql13-plpython3-${PGVer}-1PGDG.${RHFileVer}.x86_64.rpm"
get-RPM $page "postgresql13-server-${PGVer}-1PGDG.${RHFileVer}.x86_64.rpm"
#get-RPM $page "repmgr_13-5.3.2-1.${RHFileVer}.x86_64.rpm"