Обсуждение: Help update PostgreSQL 13.12 to 13.14
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.
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.
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?
El 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.
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!
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 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.
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.
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
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 etcRegardsKashif ZeeshanBitnine GlobalOn 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.
sudo systemctl enable postgresql-13
sudo systemctl start postgresql-13
sudo dnf install -y https://download.postgresql.org/pub/repos/yum/reporpms/EL-8-x86_64/pgdg-redhat-repo-latest.noarch.rpm
Hola, estos son los pasos que me danPero 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-13Quedo atentoSaludosEl 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.14HiPlease 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.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.RegardsKashif ZeeshanBitnine GlobalEl 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 etcRegardsKashif ZeeshanBitnine GlobalOn 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.
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.