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 CAMdfv4V1W7BXffTs9TQUf8yjN-UQC4EyVdKiH5aUT7_iQdPCuQ@mail.gmail.com
Whole thread Raw
In response to Re: Installing version other than the last one  (Ron Johnson <ronljohnsonjr@gmail.com>)
List pgsql-admin
Thank you very much Run

Starting with a clean S.O. there was not any problems to install postgresql 17.1 following your instructions

kind regards

Mauricio Fernández

El lun, 24 feb 2025 a las 20:02, Ron Johnson (<ronljohnsonjr@gmail.com>) escribió:
No, do not install all of them.  I'm especially concerned about -llvmjit, but also -devel will pull in a lot of packages you might not need.

And don't overcomplicate things.  Just download these specific files in a directory by themselves and then do "sudo yum install *.rpm".
postgresql17-17.1-1PGDG.rhel9.x86_64.rpm
postgresql17-17.1-contrib-1PGDG.rhel9.x86_64.rpm
postgresql17-17.1-docs-1PGDG.rhel9.x86_64.rpm
postgresql17-17.1-lib-1PGDG.rhel9.x86_64.rpm
postgresql17-17.1-server-1PGDG.rhel9.x86_64.rpm

That's all, nothing more.  You'll have PG 17.1 installed on your machine.  Then you can run initdb, edit config files, etc.

On Mon, Feb 24, 2025 at 3: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!


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

pgsql-admin by date:

Previous
From: shammat@gmx.net
Date:
Subject: Re: Changing the Datatype from Bit to Boolean.
Next
From: Mahendra Singh
Date:
Subject: Migrate data from Oracle to EPAS, EPAS to PostgreSQL