Re: Help update PostgreSQL 13.12 to 13.14

Glad to be of help.
pg_uprade is used with major version upgrade e.g. from PG13 to 14 etc

Regards
Kashif Zeeshan
Bitnine Global

On Fri, Apr 26, 2024 at 10:47 PM •Isaac Rv <isaacrodri05(at)gmail(dot)com> wrote:

> Hola, lo acabo de hacer, quedó bien luego detuve el servidor, aplique otra
> vez el sudo yum update postgresql13 y me devolvió otra vez el mensaje que
> ya no tiene más actualizaciones pendientes
> Veo que esta el pg_upgrade, pero no entiendo bien cómo usarlo
>
> Saludos y muchas gracias
>
> El vie, 26 abr 2024 a las 11:34, Kashif Zeeshan (<kashi(dot)zeeshan(at)gmail(dot)com>)
> escribió:
>
>>
>>
>> On Fri, Apr 26, 2024 at 9:22 PM •Isaac Rv <isaacrodri05(at)gmail(dot)com> wrote:
>>
>>> Mira intente con el yum y si actualizó pero sin embargo no actualizo a
>>> la 13.14
>>>
>>> sudo yum update postgresql13
>>> Updating Subscription Management repositories.
>>>
>>> This system is registered with an entitlement server, but is not
>>> receiving updates. You can use subscription-manager to assign subscriptions.
>>>
>>> Last metadata expiration check: 0:07:02 ago on Fri 26 Apr 2024 10:01:36
>>> AM CST.
>>> Dependencies resolved.
>>> Nothing to do.
>>> Complete!
>>>
>>
>> It seemed yum is not able to get the latest package update, try clearing
>> the cache and rebuilding it
>>
>> yum clean all
>>
>> yum makecache
>>
>>
>>
>>>
>>> El jue, 25 abr 2024 a las 23:16, Kashif Zeeshan (<
>>> kashi(dot)zeeshan(at)gmail(dot)com>) escribió:
>>>
>>>>
>>>>
>>>> On Thu, Apr 25, 2024 at 11:55 PM •Isaac Rv <isaacrodri05(at)gmail(dot)com>
>>>> wrote:
>>>>
>>>>> Entiendo si, me han dicho que es sencillo, pero no entiendo si solo
>>>>> descargo los binarios y en cual carpeta reemplazo? no hay una guía cómo tal
>>>>> de cómo realizarlo, me podrías ayudar?
>>>>>
>>>>
>>>> Follow the below steps
>>>> 1. Backup your data
>>>> 2. Review the release notes of the update release
>>>> 3. Stop the PG Server
>>>> 4. Upgrade postgres to newer version, e.g. on CentOS use the command
>>>> 'sudo yum update postgresql'
>>>> 5. Restart PG Server
>>>>
>>>> Thanks
>>>> Kashif Zeeshan
>>>> Bitnine Global
>>>>
>>>>>
>>>>> El jue, 25 abr 2024 a las 11:20, Kashif Zeeshan (<
>>>>> kashi(dot)zeeshan(at)gmail(dot)com>) escribió:
>>>>>
>>>>>> Hi Isaac
>>>>>>
>>>>>> You are doing the minor version upgrade so it's not a big effort as
>>>>>> compared to major version upgrade, following is the process to do it.
>>>>>>
>>>>>> *Minor releases never change the internal storage format and are
>>>>>> always compatible with earlier and later minor releases of the same major
>>>>>> version number. For example, version 10.1 is compatible with version 10.0
>>>>>> and version 10.6. Similarly, for example, 9.5.3 is compatible with 9.5.0,
>>>>>> 9.5.1, and 9.5.6. To update between compatible versions, you simply replace
>>>>>> the executables while the server is down and restart the server. The data
>>>>>> directory remains unchanged — minor upgrades are that simple.*
>>>>>>
>>>>>>
>>>>>> Please follow the links below for more information.
>>>>>> https://www.postgresql.org/docs/13/upgrading.html
>>>>>> https://www.postgresql.org/support/versioning/
>>>>>>
>>>>>> Thanks
>>>>>> Kashif Zeeshan
>>>>>> Bitnine Global
>>>>>>
>>>>>> On Thu, Apr 25, 2024 at 9:37 PM •Isaac Rv <isaacrodri05(at)gmail(dot)com>
>>>>>> wrote:
>>>>>>
>>>>>>> Hello everyone, I hope you're doing well. Does anyone have a guide
>>>>>>> or know how to perform an upgrade from PostgreSQL 13.12 to 13.14 on Linux?
>>>>>>> I've searched in various places but haven't found any solid guides, and
>>>>>>> truth be told, I'm a bit of a novice with PostgreSQL. Any help would be
>>>>>>> appreciated.
>>>>>>>
>>>>>>