Re: Help update PostgreSQL 13.12 to 13.14 - Mailing list pgsql-hackers

From Bruce Momjian
Subject Re: Help update PostgreSQL 13.12 to 13.14
Date
Msg-id Zjjnvc5ciM6M_MDT@momjian.us
Whole thread Raw
In response to Re: Help update PostgreSQL 13.12 to 13.14  (Kashif Zeeshan <kashi.zeeshan@gmail.com>)
List pgsql-hackers
This seven email thread should never have appeared on the hackers list. 
It is more appropriate for the pgsql-general@postgresql.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@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.zeeshan@gmail.com>)
>     escribió:
> 
> 
> 
>         On Mon, Apr 29, 2024 at 9:07 PM •Isaac Rv <isaacrodri05@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.zeeshan@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 <
>                 isaacrodri05@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.zeeshan@gmail.com>) escribió:
> 
> 
> 
>                         On Fri, Apr 26, 2024 at 9:22 PM •Isaac Rv <
>                         isaacrodri05@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.zeeshan@gmail.com>) escribió:
> 
> 
> 
>                                 On Thu, Apr 25, 2024 at 11:55 PM •Isaac Rv <
>                                 isaacrodri05@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.zeeshan@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 <isaacrodri05@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.
> 

-- 
  Bruce Momjian  <bruce@momjian.us>        https://momjian.us
  EDB                                      https://enterprisedb.com

  Only you can decide what is important to you.



pgsql-hackers by date:

Previous
From: Sriram RK
Date:
Subject: Re: AIX support
Next
From: Robert Haas
Date:
Subject: Re: Removing unneeded self joins