Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1bVepG-0007vw-1J for pgsql-admin@arkaria.postgresql.org; Fri, 05 Aug 2016 13:06:10 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1bVepF-0005tb-Cq for pgsql-admin@arkaria.postgresql.org; Fri, 05 Aug 2016 13:06:09 +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 ) id 1bVenZ-0003xf-EO for pgsql-admin@postgresql.org; Fri, 05 Aug 2016 13:04:25 +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 ) id 1bVenW-0002za-9W for pgsql-admin@postgresql.org; Fri, 05 Aug 2016 13:04:24 +0000 Received: from compute2.internal (compute2.nyi.internal [10.202.2.42]) by mailout.nyi.internal (Postfix) with ESMTP id 5B9B22075E; Fri, 5 Aug 2016 09:04:20 -0400 (EDT) Received: from frontend1 ([10.202.2.160]) by compute2.internal (MEProxy); Fri, 05 Aug 2016 09:04:20 -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=boTxZ4twaLIfGQp LBJ6melzmWyc=; b=lnw1lqErxzfSR21vkIx9YYyTeDRcVJvjVjcHwpoGA2RmOex S5sBB5KXjxl5IWW0TzSfMVW4Ju3GRGLDsHPoa6kWgEq69KYkIUhN+B4piCrCyfL8 lvHTEvWBGKkpEL2igVMIZp8TzSe1nReIGWx9dsyJ3TkIF5KyGjaNXiHemKHk= X-Sasl-enc: HK3RgrsA3yJXIi7Mn3sQgG02dtYAf18ni4/susGdqD/w 1470402260 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 01B82F2985; Fri, 5 Aug 2016 09:04:19 -0400 (EDT) Subject: Re: Pg-Upgrade standbys via rsync... and avoid sending UNlogged data? To: Bruce Momjian , Stephen Frost 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> Cc: Jerry Sievers , pgsql-admin@postgresql.org From: Peter Eisentraut Organization: 2ndQuadrant Message-ID: <4f3868e0-d3e5-11a7-939b-f143543d4bcb@2ndquadrant.com> Date: Fri, 5 Aug 2016 09:04:19 -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: <20160804225536.GA22579@momjian.us> Content-Type: text/plain; charset=windows-1252 Content-Transfer-Encoding: 7bit X-Pg-Spam-Score: -2.6 (--) 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 On 8/4/16 6:55 PM, Bruce Momjian wrote: > > + Unfortunately, rsync also needlessly copies the > + files associated with temporary and unlogged tables. > If you have tablespaces, you will need to run a similar > rsync command for each tablespace directory. If you > have relocated pg_xlog outside the data directories, That seems like an odd location to insert that. -- 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