Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1at1BT-0000N5-56 for pgsql-admin@arkaria.postgresql.org; Wed, 20 Apr 2016 23:05:23 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1at1BS-0008Fy-NP for pgsql-admin@arkaria.postgresql.org; Wed, 20 Apr 2016 23:05:22 +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 1at19m-0006Ja-Br for pgsql-admin@postgresql.org; Wed, 20 Apr 2016 23:03:38 +0000 Received: from allegro-1.evaristesys.com ([209.51.167.66]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1at19i-0002pT-0m for pgsql-admin@postgresql.org; Wed, 20 Apr 2016 23:03:37 +0000 Received: from [50.20.0.42] (helo=[10.1.5.203]) by allegro-1.evaristesys.com with esmtpsa (TLSv1.2:DHE-RSA-AES128-SHA:128) (Exim 4.84) (envelope-from ) id 1at19g-0007LY-8E for pgsql-admin@postgresql.org; Wed, 20 Apr 2016 19:03:32 -0400 Subject: Re: Tablespace - PostgreSQL 9.2 To: pgsql-admin@postgresql.org References: From: Alex Balashov Message-ID: <57180ABE.1090208@evaristesys.com> Date: Wed, 20 Apr 2016 19:03:26 -0400 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:38.0) Gecko/20100101 Thunderbird/38.6.0 MIME-Version: 1.0 In-Reply-To: Content-Type: text/plain; charset=utf-8; format=flowed Content-Transfer-Encoding: 7bit X-Pg-Spam-Score: -2.9 (--) 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 04/20/2016 07:00 PM, drum.lucas@gmail.com wrote: > Setting a WHOLE table to start using tablespace in a different > array/disks, do I have to have the same on the slaves, right? No, the tablespace change will be propagated as a DDL change automatically. What you _do_ have to do manually is to ensure the physical storage directory for the tablespace(s) exists on both master and slave. -- Alex Balashov | Principal | Evariste Systems LLC 1447 Peachtree Street NE, Suite 700 Atlanta, GA 30309 United States Tel: +1-800-250-5920 (toll-free) / +1-678-954-0671 (direct) Web: http://www.evaristesys.com/, http://www.csrpswitch.com/ -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin