Re: Help update PostgreSQL 13.12 to 13.14

Поиск
Список
Период
Сортировка
От Kashif Zeeshan
Тема Re: Help update PostgreSQL 13.12 to 13.14
Дата
Msg-id CAAPsdhdC8KRCgL3JzWu4t_w7oWT07FCS03W4v-ty3KEzQhkJYQ@mail.gmail.com
обсуждение исходный текст
Ответ на Help update PostgreSQL 13.12 to 13.14  (•Isaac Rv <isaacrodri05@gmail.com>)
Список pgsql-hackers


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.


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.

В списке pgsql-hackers по дате отправления:

Предыдущее
От: Amit Langote
Дата:
Сообщение: Re: sql/json remaining issue
Следующее
От: Ayush Vatsa
Дата:
Сообщение: Proposal to have INCLUDE/EXCLUDE options for altering option values