Re: Help update PostgreSQL 13.12 to 13.14

From: Kashif Zeeshan <kashi(dot)zeeshan(at)gmail(dot)com>
To: •Isaac Rv <isaacrodri05(at)gmail(dot)com>, pgsql-hackers(at)lists(dot)postgresql(dot)org
Subject: Re: Help update PostgreSQL 13.12 to 13.14
Date: 2024-04-26 05:16:37
Message-ID: CAAPsdhdC8KRCgL3JzWu4t_w7oWT07FCS03W4v-ty3KEzQhkJYQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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.
>>>
>>

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Ayush Vatsa 2024-04-26 05:35:04 Proposal to have INCLUDE/EXCLUDE options for altering option values
Previous Message Amit Langote 2024-04-26 03:34:10 Re: sql/json remaining issue