Hi Upgrade works when you have an existing Postgres installation with server running. If you run the following command then it will upgrade the existing installation of postgre. sudo dnf install -y postgresql13-server
But you don't need to execute the below commands as this will create data directory and start the server on it. sudo /usr/pgsql-13/bin/postgresql-13-setup initdb sudo systemctl enable postgresql-13 sudo systemctl start postgresql-13 You just need to install the version of postgres you need and it will upgrade the existing installation and you just need to restart the server. sudo systemctl restart postgresql-13 The following commands you mentioned are going to setup the repos for postgres which will used to download and install postgres packages. # Install the RPM from the repository: sudo dnf install -y https://download.postgresql.org/pub/repos/yum/reporpms/EL-8-x86_64/pgdg-redhat-repo-latest.noarch.rpm But you done need to disable it as this will disable the repo you installed above. sudo dnf -qy module disables postgresql Regards Kashif Zeeshan Bitnine Global On Fri, May 3, 2024 at 7:28 PM •Isaac Rv <isaacrodr...@gmail.com> wrote: > Hola, estos son los pasos que me dan > > Pero esto es solamente para instalar el Yum? O instala una instancia nueva > de PostgreSQL? > Y que pasa si ya esta instalado el yum pero mal configurado cómo bien > dices? > > # Instalar el RPM del repositorio: > sudo dnf install -y > https://download.postgresql.org/pub/repos/yum/reporpms/EL-8-x86_64/pgdg-redhat-repo-latest.noarch.rpm > > sudo dnf -qy módulo deshabilita postgresql > > sudo dnf install -y postgresql13-servidor > > sudo /usr/pgsql-13/bin/postgresql-13-setup initdb > sudo systemctl habilitar postgresql-13 > sudo systemctl iniciar postgresql-13 > > > Quedo atento > > > Saludos > > El lun, 29 abr 2024 a las 21:59, Kashif Zeeshan (<kashi.zees...@gmail.com>) > escribió: > >> >> >> On Mon, Apr 29, 2024 at 9:07 PM •Isaac Rv <isaacrodr...@gmail.com> wrote: >> >>> Ok entiendo sí, pero mi versión sigue en la 13.12 y necesito que sea >>> 13.14, me indica que ya no tiene actualizaciones pero realmente sí, ya no >>> sé cómo actualizarla a la 13.14 >>> >> >> Hi >> >> Please make sure that your postgres repository is set properly, that's >> the only reason that it's not finding V13.14. Please follow the link below. >> >> https://www.postgresql.org/download/linux/redhat/ >> >> There is another way to avoid it by downloading the V13.14 on your system >> and then install this version on your system which will upgrade your >> existing installation. >> >> Regards >> Kashif Zeeshan >> Bitnine Global >> >>> >>> El sáb, 27 abr 2024 a las 9:29, Kashif Zeeshan (<kashi.zees...@gmail.com>) >>> escribió: >>> >>>> 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. >>>>>>>>>>> >>>>>>>>>>
