Postgres Pro
Downloads
Home   >   mailing lists

Re: Installing version other than the last one - Mailing list pgsql-admin

From Imran Khan
Subject Re: Installing version other than the last one
Date
Msg-id CAC4eXDgZgtKAedTtwswGz4x3VBwqFJ916FTjS0idUtEejnZ6dg@mail.gmail.com
Whole thread Raw
In response to Re: Installing version other than the last one  (Mauricio Fernandez <mmauricio.fernandez@gmail.com>)
Responses Re: Installing version other than the last one
List pgsql-admin
Tree view
Hi Mauricio,

 If you are installing 17.1 on top of 17.4 is like downgrading major version 17. It's better you take a backup of data directory and backup dbs (logical - pg_dump) . Uninstall 17.4 and install 17.1. if internet then okay if not then download 17.1 rpms and do local install. Then initialize with initdb and start the instance and restore the backup.

Thanks,
Imran

On Mon, Feb 24, 2025, 11:03 PM Mauricio Fernandez <mmauricio.fernandez@gmail.com> wrote:
Hi Ron, thank you for the answer.

If I list the installed packages I get this:

postgresql17.x86_64              17.4-1PGDG.rhel9      
postgresql17-contrib.x86_64      17.4-1PGDG.rhel9      
postgresql17-devel.x86_64        17.4-1PGDG.rhel9      
postgresql17-docs.x86_64         17.4-1PGDG.rhel9      
postgresql17-libs.x86_64         17.4-1PGDG.rhel9      
postgresql17-llvmjit.x86_64      17.4-1PGDG.rhel9      
postgresql17-odbc.x86_64         17.00.0004-1PGDG.rhel9
postgresql17-plperl.x86_64       17.4-1PGDG.rhel9      
postgresql17-plpython3.x86_64    17.4-1PGDG.rhel9      
postgresql17-pltcl.x86_64        17.4-1PGDG.rhel9      
postgresql17-server.x86_64       17.4-1PGDG.rhel9      
postgresql17-tcl.x86_64          3.1.0-1PGDG.rhel9      
postgresql17-test.x86_64         17.4-1PGDG.rhel9      

I can understand when you said download them, but I have the following doubt

The 17.1 version of postgresql17.x86_64 (17.4-1PGDG.rhel9 ) is postgresql17-contrib-17.1-1PGDG.rhel9.x86_64.rpm ?    

Thank you very much

kind regards

Mauricio Fernández

El lun, 24 feb 2025 a las 16:42, Ron Johnson (<ronljohnsonjr@gmail.com>) escribió:
On Mon, Feb 24, 2025 at 2:26 PM Mauricio Fernandez <mmauricio.fernandez@gmail.com> wrote:
Hi admins, I want to install a specific postgresql version, for example, version 17.1.

From here : https://www.postgresql.org/download/linux/redhat/ I can get a guide to install the last version 17 (17.4), but, like I said I want to install 17.1.

From here https://download.postgresql.org/pub/repos/yum/17/redhat/rhel-9-x86_64/ there is a lot of packages and I don't know wich one to pick up.

Can you provide me a guide how to install it?

postgresql17-17.1-1PGDG.rhel9.x86_64.rpm is in that directory.  You'll also want the -contrib, -docs, -lib and -server .rpm files.

Just manually download them to a directory, and then "sudo yum *17.1*.rpm".

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

pgsql-admin by date:

Previous
From: Mauricio Fernandez
Date:
Subject: Re: Installing version other than the last one
Next
From: Mauricio Fernandez
Date:
Subject: Re: Installing version other than the last one