Thread: Installing version other than the last one

Installing version other than the last one

From

Mauricio Fernandez

Date:

24 February, 22:25:44

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?

Thank you very much in advance

kind regards

Mauricio Fernández

Re: Installing version other than the last one

From

Ron Johnson

Date:

24 February, 22:42:08

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!

Re: Installing version other than the last one

From

Mauricio Fernandez

Date:

24 February, 23:03:06

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!

Re: Installing version other than the last one

From

Imran Khan

Date:

24 February, 23:07:20

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!

Re: Installing version other than the last one

From

Mauricio Fernandez

Date:

24 February, 23:14:37

Thank you Imran for the answer.

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

sudo dnf install -y https://download.postgresql.org/pub/repos/yum/reporpms/EL-9-x86_64/pgdg-redhat-repo-latest.noarch.rpm

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!

Re: Installing version other than the last one

From

Ron Johnson

Date:

25 February, 02:02:18

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!

Re: Installing version other than the last one

From

Mauricio Fernandez

Date:

25 February, 15:45:10

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!