Re: Could not read pg_multixact/offsets on

Поиск
Список
Период
Сортировка
От Ron Johnson
Тема Re: Could not read pg_multixact/offsets on
Дата
Msg-id CANzqJaDsgix0Yj=gdLGd2X-qnayf5fXHC_mqfEh0ynFv8qZAsw@mail.gmail.com
обсуждение исходный текст
Ответ на Could not read pg_multixact/offsets on  (still Learner <stilllearner23@gmail.com>)
Список 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 по дате отправления:

Предыдущее
От: jacob ndinkwa
Дата:
Сообщение: Re: repmgr auto-failover not happening.
Следующее
От: Nikhil Shetty
Дата:
Сообщение: Re: repmgr auto-failover not happening.