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 <isaacrodr...@gmail.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.zees...@gmail.com>) > escribió: > >> >> >> On Fri, Apr 26, 2024 at 9:22 PM •Isaac Rv <isaacrodr...@gmail.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.zees...@gmail.com>) escribió: >>> >>>> >>>> >>>> On Thu, Apr 25, 2024 at 11:55 PM •Isaac Rv <isaacrodr...@gmail.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.zees...@gmail.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 <isaacrodr...@gmail.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. >>>>>>> >>>>>>