public inbox for [email protected]  

help / color / mirror / Atom feed

Update postgresql via offline mode
7+ messages / 5 participants
[nested] [flat]

* Update postgresql via offline mode
@ 2026-04-15 07:05  Mahendra Singh <[email protected]>
  0 siblings, 3 replies; 7+ messages in thread

From: Mahendra Singh @ 2026-04-15 07:05 UTC (permalink / raw)
  To: pgsql-admin <[email protected]>

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


^ permalink  raw  reply  [nested|flat] 7+ messages in thread

* R: Update postgresql via offline mode
@ 2026-04-15 07:27  Gianfranco Cocco <[email protected]>
  parent: Mahendra Singh <[email protected]>
  2 siblings, 1 reply; 7+ messages in thread

From: Gianfranco Cocco @ 2026-04-15 07:27 UTC (permalink / raw)
  To: Mahendra Singh <[email protected]>; +Cc: pgsql-admin <[email protected]>

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
​vargroup.com
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 <[email protected]>
Inviato: mercoledì 15 aprile 2026 09:05
A: pgsql-admin <[email protected]>
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

^ permalink  raw  reply  [nested|flat] 7+ messages in thread

* Re: Update postgresql via offline mode
@ 2026-04-15 08:59  Holger Jakobs <[email protected]>
  parent: Mahendra Singh <[email protected]>
  2 siblings, 1 reply; 7+ messages in thread

From: Holger Jakobs @ 2026-04-15 08:59 UTC (permalink / raw)
  To: Mahendra Singh <[email protected]>; +Cc: pgsql-admin <[email protected]>

Am 2026-04-15 09:05, schrieb Mahendra Singh:
> 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

Hi Mahendra,

This depends heavily on your platform and how you have installed your 
PostgreSQL initially.

Please tell us the details. Is it Windows, Linux, Mac? Did you install 
via your package manager? Did you use the PostgreSQL repos or those 
provided by the distribution? Or did you use an installer by EDB?

Then we might be able to help.

Kind Regards,
Holger




-- 
--
Holger Jakobs, 51469 Bergisch Gladbach, Tel. +49 178 9759012





^ permalink  raw  reply  [nested|flat] 7+ messages in thread

* Re: Update postgresql via offline mode
@ 2026-04-15 10:57  Mahendra Singh <[email protected]>
  parent: Holger Jakobs <[email protected]>
  0 siblings, 1 reply; 7+ messages in thread

From: Mahendra Singh @ 2026-04-15 10:57 UTC (permalink / raw)
  To: Holger Jakobs <[email protected]>; +Cc: pgsql-admin <[email protected]>

Dear Holger,

Yes, it is a linux server, used repos initially for installation.

Now, we want to upgrade PostgreSQL to latest minor version.

On Wed, Apr 15, 2026 at 12:59 PM Holger Jakobs <[email protected]> wrote:

> Am 2026-04-15 09:05, schrieb Mahendra Singh:
> > 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
>
> Hi Mahendra,
>
> This depends heavily on your platform and how you have installed your
> PostgreSQL initially.
>
> Please tell us the details. Is it Windows, Linux, Mac? Did you install
> via your package manager? Did you use the PostgreSQL repos or those
> provided by the distribution? Or did you use an installer by EDB?
>
> Then we might be able to help.
>
> Kind Regards,
> Holger
>
>
>
>
> --
> --
> Holger Jakobs, 51469 Bergisch Gladbach, Tel. +49 178 9759012
>


^ permalink  raw  reply  [nested|flat] 7+ messages in thread

* Re: Update postgresql via offline mode
@ 2026-04-15 11:15  Holger Jakobs <[email protected]>
  parent: Mahendra Singh <[email protected]>
  0 siblings, 0 replies; 7+ messages in thread

From: Holger Jakobs @ 2026-04-15 11:15 UTC (permalink / raw)
  To: Mahendra Singh <[email protected]>; +Cc: pgsql-admin <[email protected]>

Am 2026-04-15 12:57, schrieb Mahendra Singh:
> Dear Holger,
> 
> Yes, it is a linux server, used repos initially for installation.
> 
> Now, we want to upgrade PostgreSQL to latest minor version.
> 
> On Wed, Apr 15, 2026 at 12:59 PM Holger Jakobs <[email protected]>
> wrote:
> 
>> Am 2026-04-15 09:05, schrieb Mahendra Singh:
>>> 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
>> 
>> Hi Mahendra,
>> 
>> This depends heavily on your platform and how you have installed
>> your
>> PostgreSQL initially.
>> 
>> Please tell us the details. Is it Windows, Linux, Mac? Did you
>> install
>> via your package manager? Did you use the PostgreSQL repos or those
>> provided by the distribution? Or did you use an installer by EDB?
>> 
>> Then we might be able to help.
>> 
>> Kind Regards,
>> Holger
>> 
>> --
>> --
>> Holger Jakobs, 51469 Bergisch Gladbach,

This information isn't sufficient. Which Linux Distro? Which kind of 
package (pgdg or from the distribution)?




-- 
--
Holger Jakobs, 51469 Bergisch Gladbach





^ permalink  raw  reply  [nested|flat] 7+ messages in thread

* Re: Update postgresql via offline mode
@ 2026-04-15 12:05  Ron Johnson <[email protected]>
  parent: Mahendra Singh <[email protected]>
  2 siblings, 0 replies; 7+ messages in thread

From: Ron Johnson @ 2026-04-15 12:05 UTC (permalink / raw)
  To: pgsql-admin <[email protected]>

On Wed, Apr 15, 2026 at 3:05 AM Mahendra Singh <[email protected]>
wrote:

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

Assuming you use RHEL, manually download the relevant RPMs from these two
directories (where X is the RHEL major version):
https://download.postgresql.org/pub/repos/yum/common/redhat/rhel-*X*-x86_64/
https://download.postgresql.org/pub/repos/yum/${PgMajorVer}/redhat/rhel-*X*
-x86_64/

I automated it with a set of PowerShell scripts (since we have multiple PG
major versions running on multiple RHEL versions).  It works like a champ.

-- 
Death to <Redacted>, and butter sauce.
Don't boil me, I'm still alive.
<Redacted> lobster!


^ permalink  raw  reply  [nested|flat] 7+ messages in thread

* Re: Update postgresql via offline mode
@ 2026-04-15 23:42  Eduar Flow <[email protected]>
  parent: Gianfranco Cocco <[email protected]>
  0 siblings, 0 replies; 7+ messages in thread

From: Eduar Flow @ 2026-04-15 23:42 UTC (permalink / raw)
  To: Gianfranco Cocco <[email protected]>; +Cc: Mahendra Singh <[email protected]>; pgsql-admin <[email protected]>

. 📥 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 <
[email protected]> 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 <[email protected]>
> *Inviato:* mercoledì 15 aprile 2026 09:05
> *A:* pgsql-admin <[email protected]>
> *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

^ permalink  raw  reply  [nested|flat] 7+ messages in thread

end of thread, other threads:[~2026-04-15 23:42 UTC | newest]

Thread overview: 7+ messages (download: mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2026-04-15 07:05 Update postgresql via offline mode Mahendra Singh <[email protected]>
2026-04-15 07:27 ` R: Update postgresql via offline mode Gianfranco Cocco <[email protected]>
2026-04-15 23:42   ` Eduar Flow <[email protected]>
2026-04-15 08:59 ` Holger Jakobs <[email protected]>
2026-04-15 10:57   ` Mahendra Singh <[email protected]>
2026-04-15 11:15     ` Holger Jakobs <[email protected]>
2026-04-15 12:05 ` Ron Johnson <[email protected]>

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