Postgres Pro
Downloads
Home   >   mailing lists

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

From Mauricio Fernandez
Subject Re: Installing version other than the last one
Date
Msg-id CAMdfv4XNRfVyxazQn-SU2BDkRTgDNxRvWqkVJ7r3BVpkUXtpRQ@mail.gmail.com
Whole thread Raw
In response to Re: Installing version other than the last one  (Imran Khan <imran.k.23@gmail.com>)
List pgsql-admin
Tree view
Thank you Imran for the answer.

I haven't still install any things, just  update the yum repository though


I guess if I download the 17.1 rpm packages, when I list the yum repository ( sudo dnf list postgresql17* ) I would get available the version 17.1 and then install it

kind regards

Mauricio Fernández






El lun, 24 feb 2025 a las 17:07, Imran Khan (<imran.k.23@gmail.com>) escribió:
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: Imran Khan
Date:
Subject: Re: Installing version other than the last one
Next
From: Edwin UY
Date:
Subject: Re: Question about pg_dump + pg_restore + pg_toast