Re: Installing version other than the last one

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(dot)fernandez(at)gmail(dot)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(at)gmail(dot)com>)
> escribió:
>
>> On Mon, Feb 24, 2025 at 2:26 PM Mauricio Fernandez <
>> mmauricio(dot)fernandez(at)gmail(dot)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!
>>
>