Re: Additional Help in vetting my steps for Postgres DB upgrade from Ver 13.X to ver 15.X - Mailing list pgsql-general

From Adrian Klaver
Subject Re: Additional Help in vetting my steps for Postgres DB upgrade from Ver 13.X to ver 15.X
Date
Msg-id 037a8338-3434-47d4-aaad-ef186d4d3250@aklaver.com
Whole thread Raw
In response to Additional Help in vetting my steps for Postgres DB upgrade from Ver 13.X to ver 15.X  (Bharani SV-forum <esteembsv-forum@yahoo.com>)
Responses Re: Additional Help in vetting my steps for Postgres DB upgrade from Ver 13.X to ver 15.X
List pgsql-general
On 12/11/24 11:12, Bharani SV-forum wrote:
> Team
> As suggested from old server, post shutdown of DB, I did OS level dump 
> of PG_DATA folder and had restored in the new server.

If you follow the process shown here:

https://www.postgresql.org/message-id/CAKAnmmKZdhnhdNRd3OgDyEco9OPkT%3DqA_TeWMFMRvUM9pXauKg%40mail.gmail.com

You would not have to do the below.

> 
> Any idea on how to install the older binary postgres 13.18 ( OS=Amazon 
> Linux 2023.6.20241121) under a dedicated folder suffixed as the 
> following e.g.) /usr/pgsql1318
> 
> System Admin had already installed newer version pgsql 15.08 binaries in 
> the  new server (OS= Amazon Linux 2023.6.20241121) in the folder "/usr/bin/"
> 
> We were quoted , OS = Amazon Linux 2023.6.20241121 doesnot support 
> postgres ver 15.10 (Community edition) under its AWS-EC2.

That does not reflect well on Amazon Linux, that it is missing two 
critical bug releases.

> 
> Regards
> 
> 
> 

-- 
Adrian Klaver
adrian.klaver@aklaver.com




pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: Credcheck- credcheck.max_auth_failure
Next
From: Erik Wienhold
Date:
Subject: Re: Empty query_id in pg_stat_activity