Re: Help update PostgreSQL 13.12 to 13.14 - Mailing list pgsql-hackers
From | Kashif Zeeshan |
---|---|
Subject | Re: Help update PostgreSQL 13.12 to 13.14 |
Date | |
Msg-id | CAAPsdhf_vJEUmhWxRQpYsYXVggiuZzuEuBAHvYb5LPTaVcxuSA@mail.gmail.com Whole thread Raw |
In response to | Help update PostgreSQL 13.12 to 13.14 (•Isaac Rv <isaacrodri05@gmail.com>) |
List | pgsql-hackers |
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 pendientesVeo que esta el pg_upgrade, pero no entiendo bien cómo usarloSaludos y muchas graciasEl 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.14sudo 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 ityum 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 steps1. Backup your data2. Review the release notes of the update release3. Stop the PG Server4. Upgrade postgres to newer version, e.g. on CentOS use the command 'sudo yum update postgresql'5. Restart PG ServerThanksKashif ZeeshanBitnine GlobalEl jue, 25 abr 2024 a las 11:20, Kashif Zeeshan (<kashi.zeeshan@gmail.com>) escribió:Hi IsaacYou 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.
ThanksKashif ZeeshanBitnine GlobalOn 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.
pgsql-hackers by date: