Re: Could not read pg_multixact/offsets on - Mailing list pgsql-admin

From Ron Johnson
Subject Re: Could not read pg_multixact/offsets on
Date
Msg-id CANzqJaDsgix0Yj=gdLGd2X-qnayf5fXHC_mqfEh0ynFv8qZAsw@mail.gmail.com
Whole thread Raw
In response to Could not read pg_multixact/offsets on  (still Learner <stilllearner23@gmail.com>)
List pgsql-admin
On Sun, Feb 4, 2024 at 1:20 PM still Learner <stilllearner23@gmail.com> wrote:
Hi Team,

We are PG 11.5 with RHEL 7.9 as it has EOL, we planned to upgrade to PG16.1. When the server was ready with RHEL 9.3, installed 11.15 and set the replica with Master. As the DB is more than 20TB, unmounted the storage while installing RHEL 9 and reattached. 
DB started and once it sync with master, made this replica as master, once this done we have encountered several issues like.

What replica?
Physical replication from 11.5 to 16.1?  I don't think that was possible.  Or do you mean logical replication from the local 11.5 instance to 16.1? 

Anyway, if you have PG 11.5 and 16.1 installed on the same RHEL9 server, I think that, after mounting the old disk, I'd have done a pg_upgrade instead of replication.  Copying 20TB doesn't take that long.


pgsql-admin by date:

Previous
From: jacob ndinkwa
Date:
Subject: Re: repmgr auto-failover not happening.
Next
From: Nikhil Shetty
Date:
Subject: Re: repmgr auto-failover not happening.