Help update PostgreSQL 13.12 to 13.14

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.

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.

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.

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.

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.

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.