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 1hbosu-0001Cm-PA for pgsql-performance@arkaria.postgresql.org; Fri, 14 Jun 2019 16:17:00 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1hbost-0001ho-Lb for pgsql-performance@arkaria.postgresql.org; Fri, 14 Jun 2019 16:16:59 +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 1hbost-0001gJ-8f for pgsql-performance@lists.postgresql.org; Fri, 14 Jun 2019 16:16:59 +0000 Received: from tamriel.snowman.net ([2001:470:e38f::11]) by makus.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1hbosn-0005da-0L for pgsql-performance@lists.postgresql.org; Fri, 14 Jun 2019 16:16:58 +0000 Received: by tamriel.snowman.net (Postfix, from userid 1000) id D9F9F5F7BE; Fri, 14 Jun 2019 12:16:52 -0400 (EDT) Date: Fri, 14 Jun 2019 12:16:52 -0400 From: Stephen Frost To: Fabio Pardi Cc: Bruce Momjian , pgsql-performance@lists.postgresql.org Subject: Re: Fwd: upgrade to PG11 on secondary fails (no initdb was launched) Message-ID: <20190614161652.GI2480@tamriel.snowman.net> References: <68cf5e6c-8eb0-d8dc-08ec-78d8e910c17c@portavita.eu> <20190614033001.5jif725fxchtopg7@momjian.us> MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha512; protocol="application/pgp-signature"; boundary="Sj0nNMHKr1XTtrga" 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 --Sj0nNMHKr1XTtrga Content-Type: text/plain; charset=us-ascii Content-Disposition: inline Greetings, * Fabio Pardi (f.pardi@portavita.eu) wrote: > I understand that in this thread we are contextualizing in a step by > step procedure to create a new standby, but I have anyway a few remarks > about it (and the documentation where it has been copied from) and I > would be glad if you or somebody else could shed some light on it. This is not a procedure for creating a new standby. To create a *new* standby, with the primary online, use pg_basebackup or another tool that knows how to issue the appropriate start/stop backup and takes care of the WAL. Thanks! Stephen --Sj0nNMHKr1XTtrga Content-Type: application/pgp-signature; name="signature.asc" -----BEGIN PGP SIGNATURE----- Version: GnuPG v1 iQIcBAEBCgAGBQJdA8h0AAoJEO1sijiDR2RVhFIP/1XxW0Es0cuDY6aSbj1iDFK3 DipbgD1ont29KmYXAiIeA9QNVV3erEx/rMrqTS2mgaRUOZNAFL0EjaojBeMNJEUA 1uJMOoLt8ioEEg3sarvLksMCY9M0llZtmVRJ7+NTWj7T0+19EPX2N6u2Ng+wp0hY niBV8HJdRA3inVvySX32YvfztqOa1GyU2Kh4PPnBppC4UWK/N5gRltnCLDeCagSg z+sdOUqAKCYyX9swO+9C3JG2IhI57kQ7eeVR3QgZaPLR83RM2wlV7+PGmw4cPtak nsG/iIUI4d53yczYTT5jntm6XCMutyBDzBm3N9zLyvWW2FS4/n5lxo6ppXSiZt56 C2mTF5czCrehY6ei2uVmltzC5+0UUELqf1y/l5kubJjR8F/pkGZ7MUs503p3ROdc /9+bIrcLL1ALhVvRkIrAXkv9TQEkgq8x479agtkF3eWqT9JsaIAR26dT7rMW9PrC oHtGyGmwJfxJyFBkCnohsFJJYMC59Ge4Y6x1WznlKgREZFMvN/4dtytwaudL/44l Y47uSEzvvd5LtusXgCYTgX4TZ7L6TL7qLJBSHeTcldgrtVIpNdFT+x14MmsZXy87 RecvZx2KybFL0pNSMmT1oXQZhD6HEblWDEMBGmKC2wqo41511t6UFKiXlUuOkD9L y5VKqH0sN9l610sH9z9g =nEPG -----END PGP SIGNATURE----- --Sj0nNMHKr1XTtrga--