Re: Installing PostGreSQLon Redhat Linux - Help needed

[Ron <ronljohnsonjr@xxxxxxxxx>]

    Here you go.

On 3/27/23 17:07, Sendhu Sendhu wrote:

Hi Ron,

I'm not finding the powershell script. Do you mind attaching again ?

On Mon, Mar 27, 2023 at 5:23 PM Ron <ronljohnsonjr@xxxxxxxxx> wrote:

My earlier email had a PowerShell script in a text file.  In there is everything I've used for the past three years when downloading packages for 9.6 and 13.

You'll have to edit it for your own needs.

On 3/27/23 13:51, Sendhu Sendhu wrote:

Assuming our Linux distribution is rhel-9.0-x86_64/, do I need to download all files and sub-dir and install them?

On Mon, Mar 27, 2023 at 2:41 PM Ron <ronljohnsonjr@xxxxxxxxx> wrote:

On 3/27/23 13:31, Sendhu Sendhu wrote:

Hi Servet,

Thanks for your response. Under the redhat directory, there are a few dozen files. Which ones are needed for installation?

Also, is there a step by step installation available?

Once they're in their own Linux directory, simply "sudo yum install *rpm".

--

Born in Arizona, moved to Babylonia.

--
Born in Arizona, moved to Babylonia.

--
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"