Re: Advice Needed: Simultaneous Upgrade of Two-Node PostgreSQL 11 Cluster

From: Scott Ribe <scott_ribe(at)elevated-dev(dot)com>
To: kasem adel <kasemadel8(at)gmail(dot)com>
Cc: pgsql-admin <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Advice Needed: Simultaneous Upgrade of Two-Node PostgreSQL 11 Cluster
Date: 2025-01-09 13:44:28
Message-ID: 06090D46-9CB3-4491-A395-47654C4A2517@elevated-dev.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

> On Jan 7, 2025, at 6:50 AM, kasem adel <kasemadel8(at)gmail(dot)com> wrote:
>
> Kindly be informed that database size is 1.8 TB and we have an low network bandwidth between two node 10 mbps and to transfer the data from scratch that will take from 21 day to 30 day for this we need solution in upgrade to prevent load data from scratch .

Yes, and I gave you alternatives taking that into account. I think you have all the answers you're going to get, and now have to study them and choose an approach.

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Gambhir Singh 2025-01-10 09:50:57 Before image of selective columns.
Previous Message Alvaro Herrera 2025-01-09 11:11:19 Re: 2nd PostgreSQL server in WAL shipping cluster fails to start