Re: Help update PostgreSQL 13.12 to 13.14

This seven email thread should never have appeared on the hackers list.
It is more appropriate for the pgsql-general(at)postgresql(dot)org email list.

---------------------------------------------------------------------------

On Mon, May 6, 2024 at 08:53:15AM +0500, Kashif Zeeshan wrote:
> 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 <isaacrodri05(at)gmail(dot)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(dot)zeeshan(at)gmail(dot)com>)
> escribió:
>
>
>
> On Mon, Apr 29, 2024 at 9:07 PM •Isaac Rv <isaacrodri05(at)gmail(dot)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(dot)zeeshan(at)gmail(dot)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 <
> 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.
>

--
Bruce Momjian <bruce(at)momjian(dot)us> https://momjian.us
EDB https://enterprisedb.com

Only you can decide what is important to you.