RE: upgrade to PG11 on secondary fails (no initdb was launched) - Mailing list pgsql-performance

From Greg Clough
Subject RE: upgrade to PG11 on secondary fails (no initdb was launched)
Date
Msg-id BYAPR12MB2999E06D968654BBBEC0F9DFEC010@BYAPR12MB2999.namprd12.prod.outlook.com
Whole thread Raw
In response to Fwd: upgrade to PG11 on secondary fails (no initdb was launched)  (Mariel Cherkassky <mariel.cherkassky@gmail.com>)
List pgsql-performance
> 2019-05-23 04:17:02 EDT  23593  DETAIL:  The database cluster was initialized with PG_CONTROL_VERSION 960, but the
serverwas 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)
standbyservers, 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
instructionsin 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
toall 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.

pgsql-performance by date:

Previous
From: Mariel Cherkassky
Date:
Subject: Fwd: upgrade to PG11 on secondary fails (no initdb was launched)
Next
From: Fabio Pardi
Date:
Subject: Re: Fwd: upgrade to PG11 on secondary fails (no initdb was launched)