Received: from malur.postgresql.org ([217.196.149.56])
	by arkaria.postgresql.org with esmtp (Exim 4.84_2)
	(envelope-from
 <pgsql-admin-owner+M45722=pgsql+2Dadmin=arkaria.postgresql.org@postgresql.org>)
	id 1bWZPN-0004bH-DU
	for pgsql-admin@arkaria.postgresql.org; Mon, 08 Aug 2016 01:31:13 +0000
Received: from localhost ([127.0.0.1] helo=postgresql.org)
	by malur.postgresql.org with smtp (Exim 4.84_2)
	(envelope-from
 <pgsql-admin-owner+M45722=pgsql+2Dadmin=arkaria.postgresql.org@postgresql.org>)
	id 1bWZPN-0008A0-0L
	for pgsql-admin@arkaria.postgresql.org; Mon, 08 Aug 2016 01:31:13 +0000
Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29])
	by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256)
	(Exim 4.84_2)
	(envelope-from <peter.eisentraut@2ndquadrant.com>)
	id 1bWZNg-0006De-FL
	for pgsql-admin@postgresql.org; Mon, 08 Aug 2016 01:29:28 +0000
Received: from out2-smtp.messagingengine.com ([66.111.4.26])
	by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256)
	(Exim 4.84_2)
	(envelope-from <peter.eisentraut@2ndquadrant.com>)
	id 1bWZNb-0004YV-JM
	for pgsql-admin@postgresql.org; Mon, 08 Aug 2016 01:29:26 +0000
Received: from compute2.internal (compute2.nyi.internal [10.202.2.42])
	by mailout.nyi.internal (Postfix) with ESMTP id 4C9D020296;
	Sun,  7 Aug 2016 21:29:21 -0400 (EDT)
Received: from frontend1 ([10.202.2.160])
  by compute2.internal (MEProxy); Sun, 07 Aug 2016 21:29:21 -0400
DKIM-Signature: v=1; a=rsa-sha1; c=relaxed/relaxed; d=
	messagingengine.com; h=cc:content-transfer-encoding:content-type
	:date:from:in-reply-to:message-id:mime-version:references
	:subject:to:x-sasl-enc:x-sasl-enc; s=smtpout; bh=U2eXn98L0Hf/q9Z
	zIJscZci8FB0=; b=OMlpQ0FMwNbx54AJwb+Gi+z54VL/yoWLvlqTx/ziNvVbPZR
	TJUMGRcPoi0Tx8fIKiyomgTy9Jn4roOhSXiLFYToBVHavyrT7y2rYEwDfXtIHXDJ
	5WyGdVCmSiluX4Pb76E3IYLMIjmkrZFXHpj9QI4rFgOG4y2nMXBwfR4XjROM=
X-Sasl-enc: cEgvgp6ROJTUC3XvxHkJA8TKr3RT0884gL23f1M4+/0J 1470619760
Received: from april.local (c-73-13-66-39.hsd1.pa.comcast.net [73.13.66.39])
	by mail.messagingengine.com (Postfix) with ESMTPA id DEB2FF285F;
	Sun,  7 Aug 2016 21:29:20 -0400 (EDT)
Subject: Re: Pg-Upgrade standbys via rsync... and avoid sending
 UNlogged data?
To: Bruce Momjian <bruce@momjian.us>
References: <86d1m5b6bi.fsf@jerry.enova.com>
 <20160725163700.GZ4028@tamriel.snowman.net>
 <20160725164329.GA4028@tamriel.snowman.net> <86eg6hr58q.fsf@jerry.enova.com>
 <20160726161946.GA3511@momjian.us>
 <20160726231129.GH4028@tamriel.snowman.net>
 <20160804225536.GA22579@momjian.us>
 <4f3868e0-d3e5-11a7-939b-f143543d4bcb@2ndquadrant.com>
 <20160805140521.GA5093@momjian.us> <20160805140644.GB5093@momjian.us>
Cc: Stephen Frost <sfrost@snowman.net>, Jerry Sievers
 <gsievers19@comcast.net>, pgsql-admin@postgresql.org
From: Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
Organization: 2ndQuadrant
Message-ID: <bbc8fd84-b4b4-d70b-3c2c-1e41678674cc@2ndquadrant.com>
Date: Sun, 7 Aug 2016 21:29:20 -0400
User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.11; rv:45.0)
 Gecko/20100101 Thunderbird/45.2.0
MIME-Version: 1.0
In-Reply-To: <20160805140644.GB5093@momjian.us>
Content-Type: text/plain; charset=windows-1252
Content-Transfer-Encoding: 7bit
X-Pg-Spam-Score: -2.6 (--)
List-Archive: <http://archives.postgresql.org/pgsql-admin>
List-Help: <mailto:majordomo@postgresql.org?body=help>
List-ID: <pgsql-admin.postgresql.org>
List-Owner: <mailto:pgsql-admin-owner@postgresql.org>
List-Post: <mailto:pgsql-admin@postgresql.org>
List-Subscribe: <mailto:majordomo@postgresql.org?body=sub%20pgsql-admin>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
X-Mailing-List: pgsql-admin
Precedence: bulk
Sender: pgsql-admin-owner@postgresql.org

On 8/5/16 10:06 AM, Bruce Momjian wrote:
> On Fri, Aug  5, 2016 at 10:05:21AM -0400, Bruce Momjian wrote:
>> On Fri, Aug  5, 2016 at 09:04:19AM -0400, Peter Eisentraut wrote:
>>> On 8/4/16 6:55 PM, Bruce Momjian wrote:
>>>>         <para>
>>>> +        Unfortunately, <application>rsync</> also needlessly copies the
>>>> +        files associated with temporary and unlogged tables.
>>>>          If you have tablespaces, you will need to run a similar
>>>>          <application>rsync</> command for each tablespace directory.  If you
>>>>          have relocated <filename>pg_xlog</> outside the data directories,
>>>
>>> That seems like an odd location to insert that.
>>
>> Would you like to suggest another location as I could not find out.
> 
> Sorry, typo:  :-(
> 
> 	Would you like to suggest another location as I could not find one.

I think it belongs to the previous paragraph, so I moved it there.


-- 
Peter Eisentraut              http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services


-- 
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin