Re: Update postgresql via offline mode

public inbox for pgsql-admin@postgresql.org  
help / color / mirror / Atom feed

From: Eduar Flow <eduarshorybalbuena77@gmail.com>
To: Gianfranco Cocco <Gianfranco.Cocco@vargroup.com>
Cc: Mahendra Singh <msmahendrasingh18@gmail.com>
Cc: pgsql-admin <pgsql-admin@lists.postgresql.org>
Subject: Re: Update postgresql via offline mode
Date: Wed, 15 Apr 2026 17:42:30 -0600
Message-ID: <CALR9rdTRp8G-KguVhoYC_ktmRWDJ0BV8SXwfOjD_eiOeud6p_A@mail.gmail.com> (raw)
In-Reply-To: <PAVPR02MB91342346BDAD7F5F1E48B146F4222@PAVPR02MB9134.eurprd02.prod.outlook.com>
References: <CA+Thq8GEDVka_EukecJDDzQ5bwD0FYWBn_Lf72ds1CDQPGQcbw@mail.gmail.com>
	<PAVPR02MB91342346BDAD7F5F1E48B146F4222@PAVPR02MB9134.eurprd02.prod.outlook.com>

. 📥 Descargar paquetes (en otro equipo con internet)
Desde un equipo con conexión:
Ve al sitio oficial: PostgreSQL
Descarga la misma versión mayor (ej. 14.x) pero última menor disponible
Dependiendo de tu sistema:
Linux (ej. Ubuntu/Debian)
Descarga paquetes .deb:
Bash
apt download postgresql-14
apt download postgresql-client-14
RHEL/CentOS
Bash
yum install --downloadonly --downloaddir=/tmp/pg pkgname
Windows
Descarga el instalador .exe oficial
2. 📦 Transferir al servidor offline
Copia los paquetes usando:
USB
SCP desde red interna
Disco externo
3. 🛑 Detener PostgreSQL
Bash
sudo systemctl stop postgresql
4. ⬆️ Instalar actualización
Linux Debian/Ubuntu
Bash
sudo dpkg -i postgresql-14*.deb
RHEL/CentOS
Bash
sudo rpm -Uvh postgresql-14*.rpm
Windows
Ejecuta el .exe
Detectará instalación existente y actualizará
5. ▶️ Iniciar el servicio
Bash
sudo systemctl start postgresql
6. ✅ Verificar versión
Bash
psql -V
o dentro de PostgreSQL:
SQL
SELECT version();
⚠️ Buenas prácticas (muy importante)
Antes de actualizar:
💾 Backup completo:
Bash
pg_dumpall > backup.sql
📁 O copia del data directory (por seguridad extra)
🚨 Cosas a tener en cuenta
No mezclar repositorios o builds distintos
Asegúrate que las librerías requeridas también estén disponibles offline
Si usas extensiones, valida compatibilidad
🧠 Resumen simple
Sí, puedes hacerlo igual que Oracle/MSSQL:
Descargas el paquete en otro equipo
Lo copias
Paras PostgreSQL
Instalas encima
Inicias
Sin migraciones complicadas 👍

Yekma666

El mié, 15 de abr de 2026, 09:50, Gianfranco Cocco <
Gianfranco.Cocco@vargroup.com> escribió:

> Hi,
> You can download from repository
> https://download.postgresql.org/pub/repos/yum/ the software that you need
> and transfer them to your server.
> After that you can shutdown postgreSQL instance and launch the upgrade:
>
> For example:
>
> dnf install \
>    postgresql1xxxPGDG.rhelxx.x86_64.rpm \
>    postgresql1x-server-1x.x-1PGDG.rhelxx.x86_64.rpm \
>    postgresql1x-libs-1x.x-1PGDG.rhelx.x.x86_64.rpm \
>    .....rpm \
>    .....rpm \
>       --allowerasing
>
> --allowerasing ==> replace only binaries related to the same family.
>
>
> Good work.
> Regards,
>
> Gianfranco
> Gianfranco Cocco 
>
> <https://eu.content.exclaimer.net/?url=http%3A%2F%2Fwww.vargroup.com%2F&tenantid=rfCiJaqSEfCOYWBF...;
> vargroup.com
> <https://eu.content.exclaimer.net/?url=https%3A%2F%2Fwww.vargroup.com%2F&tenantid=rfCiJaqSEfCOYWB...;
> Questo messaggio è stato spedito da Var Group S.p.A. o da una delle
> aziende del Gruppo. Esso, e gli eventuali allegati, potrebbero contenere
> informazioni di carattere estremamente riservato e confidenziale.
> Qualora non foste i destinatari designati, vogliate cortesemente
> informarci immediatamente con lo stesso mezzo ed eliminare il
> messaggio e i relativi eventuali allegati, senza trattenerne copia.
>
> ------------------------------
> *Da:* Mahendra Singh <msmahendrasingh18@gmail.com>
> *Inviato:* mercoledì 15 aprile 2026 09:05
> *A:* pgsql-admin <pgsql-admin@lists.postgresql.org>
> *Oggetto:* Update postgresql via offline mode
>
> Dear Experts,
>
> Need your expertise here..!
>
> I want to patch my postgresql minor version to the latest minor version.
> How can I do so via offline mode? No need to enable the internet on the
> postgresql server.
> Please advise and suggest a simple and easy solution.
> Like in Oracle or MSSQL servers, just download the update from the
> internet and install on the server.
>
> Regards,
> Mahendra Singh
> DBA@DXB
>

Attachments:

  [image/png] image194947.png (14.7K, 3-image194947.png)
  download | view image

  [image/png] image806427.png (15.6K, 4-image806427.png)
  download | view image

  [image/png] image194947.png (14.7K, 5-image194947.png)
  download | view image

  [image/png] image806427.png (15.6K, 6-image806427.png)
  download | view image

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-admin@postgresql.org
  Cc: eduarshorybalbuena77@gmail.com, Gianfranco.Cocco@vargroup.com, msmahendrasingh18@gmail.com, pgsql-admin@lists.postgresql.org
  Subject: Re: Update postgresql via offline mode
  In-Reply-To: <CALR9rdTRp8G-KguVhoYC_ktmRWDJ0BV8SXwfOjD_eiOeud6p_A@mail.gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox