Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1dsAwp-00040L-UC for pgsql-admin@arkaria.postgresql.org; Wed, 13 Sep 2017 16:55:36 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1dsAwp-0003CZ-Hv for pgsql-admin@arkaria.postgresql.org; Wed, 13 Sep 2017 16:55:35 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1dsAv0-0008ML-Pt for pgsql-admin@postgresql.org; Wed, 13 Sep 2017 16:53:42 +0000 Received: from tamriel.snowman.net ([2001:470:e38f::11]) by makus.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1dsAut-0002iS-Qg for pgsql-admin@postgresql.org; Wed, 13 Sep 2017 16:53:41 +0000 Received: by tamriel.snowman.net (Postfix, from userid 1000) id 59DE65F799; Wed, 13 Sep 2017 12:53:35 -0400 (EDT) Date: Wed, 13 Sep 2017 12:53:35 -0400 From: Stephen Frost To: Don Seiler Cc: pgsql-admin Subject: Re: Upgrade master/slave: rsync? Message-ID: <20170913165335.GY4628@tamriel.snowman.net> References: <20170913162413.GX4628@tamriel.snowman.net> MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha512; protocol="application/pgp-signature"; boundary="+lIdlT0F70KZrfXR" Content-Disposition: inline In-Reply-To: User-Agent: Mutt/1.5.21 (2010-09-15) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-admin Precedence: bulk Sender: pgsql-admin-owner@postgresql.org --+lIdlT0F70KZrfXR Content-Type: text/plain; charset=us-ascii Content-Disposition: inline Don, On these mailing lists, we really prefer it if people wouldn't "top-post", instead add your comments in-line and eliminate text that isn't relevant. * Don Seiler (don@seiler.us) wrote: > In the meantime I'll look at using the --link method and rsync. Probably > should be using --link method on a larger database anyway to save time and > disk space? Yes, it's much more efficient, but I strongly recommend taking a backup as close to before the upgrade as possible, being extremely careful throughout the process, plan for a good bit of time above what the actual commands take to run, and make sure that you have *tested* your backup and *restore* process well and have strong confidence in it. Thanks! Stephen --+lIdlT0F70KZrfXR Content-Type: application/pgp-signature; name="signature.asc" Content-Description: Digital signature -----BEGIN PGP SIGNATURE----- Version: GnuPG v1 iQIcBAEBCgAGBQJZuWKOAAoJEO1sijiDR2RVQdIP/ji4CtIomwmeqHFphgJnLmSd jDitAUWjoSuGy/zN8VElpoLa8+TC8jVLcpDXym998QVh7MYGPjyavxKeWIog920l iIVDpoIEHm0blIES+0HxvTUeS12ctJV4SBMAYFTIBF+3jaY6uOIZ1gcgB1Q545Dg gXm2mrXSiHzt903+Rmpzdk886uaQjHb0/ej3s6E/Wgzc82sn3BkwAMIdTiK79m4x lTWl7F+9Zl0bW1F+5XC1nkOVTVvc6TD1o76Rz7Pdk6dHdEMCKno5fc0zg7rhnNjn Jim51ZdIUuZ8qjs2qfBVSpJ3aa0U1ltgZYvJ9HFr8Eknv+hBPX9qD1SqVkyGZu73 9xnyc2QHzbZ13uWL1Oo+0gVmSsLPxww8Go3yRu8UjRk7glZIs9305KQVMQgjNrdx rysy1ML+jCjONbuJa+rmfndskaI9/Nt+UuEOGWVf8H06UeSpm10Pt4PLTgqvKOE6 3yfxkMScK1ujnd1lCuHZvjTlR179VRo/9Kd+uVIs31Chy9IN0mZhH4koe9IsAIe+ sI0eqa4R46JHAJ6osUiIegmfYV2gxTBIWeorw1uLIwpJueFrjQokGFR/wvFbDpD3 3A3t9U2XZUcCQo4x1mZmFs2pQx9dGp12u3Ge7FoWzTjKKmskvC7b1F0O1XpqW0yv 7YgsGKZMCGJx9IFscovl =iFGL -----END PGP SIGNATURE----- --+lIdlT0F70KZrfXR--