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(at)postgresql(dot)org
Subject: Re: Advice Needed: Simultaneous Upgrade of Two-Node PostgreSQL 11 Cluster
Date: 2025-01-07 13:37:50
Message-ID: 5DA36CEB-A299-41C5-8C00-FC1631E6EE8E@elevated-dev.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

> On Jan 6, 2025, at 11:57 PM, Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at> wrote:
>
> One month to rebuild a standby?

In addition to other alternatives presented:

- better hardware, one month to restore seems insane
- separate OLTP from data warehouse for reporting
- if the issue is network bandwidth, then local backup, bzip2 for compression

If you do go to logical replication, be sure to look at new features in 17 for managing slots and syncing up.

How large is this database?

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message kasem adel 2025-01-07 13:50:22 Re: Advice Needed: Simultaneous Upgrade of Two-Node PostgreSQL 11 Cluster
Previous Message Laurenz Albe 2025-01-07 06:57:19 Re: Advice Needed: Simultaneous Upgrade of Two-Node PostgreSQL 11 Cluster