Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1bRiyb-0007j4-Sn for pgsql-admin@arkaria.postgresql.org; Mon, 25 Jul 2016 16:43:33 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1bRiyb-0006qP-Fu for pgsql-admin@arkaria.postgresql.org; Mon, 25 Jul 2016 16:43:33 +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 1bRiya-0006q7-Rc for pgsql-admin@postgresql.org; Mon, 25 Jul 2016 16:43:32 +0000 Received: from tamriel.snowman.net ([2001:4830:167b::11]) by makus.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1bRiyY-0008EX-Au for pgsql-admin@postgresql.org; Mon, 25 Jul 2016 16:43:31 +0000 Received: by tamriel.snowman.net (Postfix, from userid 1000) id DF00F5F796; Mon, 25 Jul 2016 12:43:29 -0400 (EDT) Date: Mon, 25 Jul 2016 12:43:29 -0400 From: Stephen Frost To: Jerry Sievers Cc: pgsql-admin@postgresql.org Subject: Re: Pg-Upgrade standbys via rsync... and avoid sending UNlogged data? Message-ID: <20160725164329.GA4028@tamriel.snowman.net> References: <86d1m5b6bi.fsf@jerry.enova.com> <20160725163700.GZ4028@tamriel.snowman.net> MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha512; protocol="application/pgp-signature"; boundary="50WZftmI8KrtQkml" Content-Disposition: inline In-Reply-To: <20160725163700.GZ4028@tamriel.snowman.net> X-Editor: Vim http://www.vim.org/ X-Info: http://www.snowman.net X-Operating-System: Linux/3.13.0-91-generic (x86_64) X-Uptime: 12:42:07 up 16 days, 18:06, 7 users, load average: 0.03, 0.06, 0.05 User-Agent: Mutt/1.5.21 (2010-09-15) X-Pg-Spam-Score: -3.2 (---) 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 --50WZftmI8KrtQkml Content-Type: text/plain; charset=us-ascii Content-Disposition: inline Content-Transfer-Encoding: quoted-printable * Stephen Frost (sfrost@snowman.net) wrote: > > I have among others, a 5TB system w/about 40G of unlogged data. >=20 > Honestly, sending an extra 40G out of 5TB (we're talking less than 1% > here...) might be worth it to keep the process simple. Of course, I realize right after sending this that you aren't sending the 5TB. :) Depends on your network speed if the 40G would be an issue or not then. In some cases, it might only add a bit of time but keep the process simple, other cases, it might take longer. I'm not really thrilled with the idea of complicating the rsync in that way, but I can understand why you're considering it. Thanks! Stephen --50WZftmI8KrtQkml Content-Type: application/pgp-signature; name="signature.asc" Content-Description: Digital signature -----BEGIN PGP SIGNATURE----- Version: GnuPG v1 iQIcBAEBCgAGBQJXlkGxAAoJEO1sijiDR2RVaNMP/jZ5FilyWIPXbaJttZDW6qAx fbxOy6OVh91EtaKiGFEODCLwQCZUrpCjwCn/T1Y0hoyOL7Iy7JmctnEeRawFTHP3 qWlzyNSh8PrGglsPpohct6tXNr54hURssJsaXUHufI2Jg+ZixLC8M3+D7owmmwrq 3xyWu57ELQzhICeEGDvjpQtVSvUO2AJzaEZvM5kTVSPM+5VojKzD/liepC5Jepyn 4U4gH9wN2srHCQ0UP9VR7ArgXj9CTthSxp4iy1fDbBfNoBv4sKmtiDc4oaywaPmh VFDd7nirXwtZHRGNlZQIYbzBrSTs5cMIR4MlbhkQC0kC/PvRP++vEHCFPbs5g7sb 5xXxqmdvAfPW0fZXx/ye8M/SCB1sRkL7myZCOr2pw3f+IYld2/povm4L9S6x8pjF NOe/WlKfp2VCcPpTtixOda7AhteBxNDSU1Py+8bytN4hkBRqURqEdcdoY8jQvnVE YU7/FwsnOecxKK+KHr1em8LelRmr6r0lTEKgoNlBOin+PcP5OFVbjVWTJ+nOizlB SNSmQMkIupG68DPGl0f5jD/JPry11Y+o4fLX/+BB1f38s1kNu0K32ZJAoItjxSJ5 1KD932kIA5muc0NyhL9HsDfqd4TE60SRLIDo/kHuYbDGpqvDkgOp/55i4bTnmzfy asOczSXK5kOJJHtE/v5O =9ttl -----END PGP SIGNATURE----- --50WZftmI8KrtQkml--