RE: upgrade to PG11 on secondary fails (no initdb was launched)

From: Greg Clough <Greg(dot)Clough(at)ihsmarkit(dot)com>
To: Mariel Cherkassky <mariel(dot)cherkassky(at)gmail(dot)com>, PostgreSQL mailing lists <pgsql-performance(at)postgresql(dot)org>
Subject: RE: upgrade to PG11 on secondary fails (no initdb was launched)
Date: 2019-05-23 11:23:47
Message-ID: BYAPR12MB2999E06D968654BBBEC0F9DFEC010@BYAPR12MB2999.namprd12.prod.outlook.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-performance

> 2019-05-23 04:17:02 EDT 23593 DETAIL: The database cluster was initialized with PG_CONTROL_VERSION 960, but the server was compiled with PG_CONTROL_VERSION 1100.

It appears that you have not upgraded the standby server, so either use "rsync" or simply destroy and rebuild it from scratch "repmgr standby clone..."

https://www.postgresql.org/docs/11/pgupgrade.html

Upgrade Streaming Replication and Log-Shipping standby servers

If you used link mode and have Streaming Replication (see Section 26.2.5) or Log-Shipping (see Section 26.2) standby servers, you can follow these steps to quickly upgrade them. You will not be running pg_upgrade on the standby servers, but rather rsync on the primary. Do not start any servers yet.

If you did not use link mode, do not have or do not want to use rsync, or want an easier solution, skip the instructions in this section and simply recreate the standby servers once pg_upgrade completes and the new primary is running.

Greg.

________________________________

This e-mail, including accompanying communications and attachments, is strictly confidential and only for the intended recipient. Any retention, use or disclosure not expressly authorised by IHSMarkit is prohibited. This email is subject to all waivers and other terms at the following link: https://ihsmarkit.com/Legal/EmailDisclaimer.html

Please visit www.ihsmarkit.com/about/contact-us.html for contact information on our offices worldwide.

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Fabio Pardi 2019-05-23 11:31:01 Re: Fwd: upgrade to PG11 on secondary fails (no initdb was launched)
Previous Message Mariel Cherkassky 2019-05-23 11:07:30 Fwd: upgrade to PG11 on secondary fails (no initdb was launched)

Browse pgsql-performance by date

  From Date Subject
Next Message Fabio Pardi 2019-05-23 11:31:01 Re: Fwd: upgrade to PG11 on secondary fails (no initdb was launched)
Previous Message Mariel Cherkassky 2019-05-23 11:07:30 Fwd: upgrade to PG11 on secondary fails (no initdb was launched)