Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1hTpKh-00059b-Al for pgsql-admin@arkaria.postgresql.org; Thu, 23 May 2019 15:08:39 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1hTpKg-0004En-69 for pgsql-admin@arkaria.postgresql.org; Thu, 23 May 2019 15:08:38 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1hTpKf-00043r-O9 for pgsql-admin@lists.postgresql.org; Thu, 23 May 2019 15:08:37 +0000 Received: from tamriel.snowman.net ([2001:470:e38f::11]) by makus.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1hTpKd-0006fG-DX for pgsql-admin@postgresql.org; Thu, 23 May 2019 15:08:36 +0000 Received: by tamriel.snowman.net (Postfix, from userid 1000) id 2152A5F79F; Thu, 23 May 2019 11:08:35 -0400 (EDT) Date: Thu, 23 May 2019 11:08:35 -0400 From: Stephen Frost To: Greg Clough Cc: Mariel Cherkassky , PostgreSQL mailing lists Subject: Re: upgrade to PG11 on secondary fails (no initdb was launched) Message-ID: <20190523150834.GG2480@tamriel.snowman.net> References: MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha512; protocol="application/pgp-signature"; boundary="gneEPciiIl/aKvOT" Content-Disposition: inline In-Reply-To: User-Agent: Mutt/1.5.24 (2015-08-30) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --gneEPciiIl/aKvOT Content-Type: text/plain; charset=us-ascii Content-Disposition: inline Content-Transfer-Encoding: quoted-printable Greetings (moved to -admin, where it should be...), * Greg Clough (Greg.Clough@ihsmarkit.com) wrote: > > 2019-05-23 04:17:02 EDT 23593 DETAIL: The database cluster was initi= alized with PG_CONTROL_VERSION 960, but the server was compiled with PG_CON= TROL_VERSION 1100. >=20 > 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.= =2E." You can't use the rsync method described in the pg_upgrade documentation after the primary has been started, you'll end up with corruption. Thanks, Stephen --gneEPciiIl/aKvOT Content-Type: application/pgp-signature; name="signature.asc" -----BEGIN PGP SIGNATURE----- Version: GnuPG v1 iQIcBAEBCgAGBQJc5rdyAAoJEO1sijiDR2RVz6wQAI+/sicJEFwJ4HGgmhRmgzu4 2MXT+QvxKqgycKbHKA2QoKfcPWYruaFa+z7E9487JNXLp2RJb1Ra5o2vKlIxKkup /+UfJMYRWgqozulh7wz5gJAy8GKrhMlGkPplFdCc/0Rl+Pq9O/1SxuO4yEB4OGD2 kH1go8QXGcOARg6OjmC+cZjtIwHnwIbVYkzwxO+pA29GhUZe+/3oVXJlNVncfhRH W26L/aYbGtBG7beM+3MKd5F5bLVxtdm+gc551jKmhDtaBixGsr4ZtmrkSD/bl+E9 p7oTXBttv29Kmf3MGV5PCXIYwwuHGUSm2qUS1zS04ou5j2TXzAcCyJpBj7epYs8Y +JKygCmrmCuNgH/DhvyL5/DFCpD4qPS2ENCw1G/AvnxdobHc5kjKd8N1KClJHBIm SpZUW/HTX/Y0NlPLaZjHOts6r/kp0vFNoQIO6uHbI5qLFXywtZ5tsQBQ27eXAKGz FIMkTGr9cG+KK4bCPfhd4HMga8cCGzqzAaAW52/DoruGOquBsFfgvqnxuhY5lqi2 stK/O1lXF6YXqbBEeC5bTBscE+zCwnGG5VOUtdcQALi/CdSsL0rti3VdsxCONqQl ems+QgPCQk5H34p/kQDw618ERKnOsFf4ISLY+en6dxpnL91Q/vC0ZVWBDJO4ep9I xJeVdTXMl8Tb00wovFLQ =Fus0 -----END PGP SIGNATURE----- --gneEPciiIl/aKvOT--