Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1Ud5B2-0001QA-Tj for pgsql-admin@arkaria.postgresql.org; Thu, 16 May 2013 20:53:29 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.72) (envelope-from ) id 1Ud5B2-0000XY-AU for pgsql-admin@arkaria.postgresql.org; Thu, 16 May 2013 20:53:28 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1Ud5B1-0000XS-67 for pgsql-admin@postgresql.org; Thu, 16 May 2013 20:53:27 +0000 Received: from 30.55.colo.spiretech.net ([69.168.55.30] helo=lists.commandprompt.com) by magus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1Ud5An-0003Bd-Fl for pgsql-admin@postgresql.org; Thu, 16 May 2013 20:53:26 +0000 Received: from [192.168.1.5] (spinlock.commandprompt.com [69.168.55.30]) by lists.commandprompt.com (Postfix) with ESMTPA id 38A8851; Thu, 16 May 2013 13:53:11 -0700 (PDT) Received: from [192.168.1.5] ([71.95.101.172] helo=[192.168.1.5]) by assp.commandprompt.com with ESMTPS(AES256-SHA) (2.1.1); 16 May 2013 13:53:10 -0700 Message-ID: <5195472A.3050301@commandprompt.com> Date: Thu, 16 May 2013 13:52:58 -0700 From: "Joshua D. Drake" Organization: Command Prompt, Inc. User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:17.0) Gecko/20130404 Thunderbird/17.0.5 MIME-Version: 1.0 To: Victor Tan CC: pgsql-admin@postgresql.org Subject: Re: Streaming replication and partitions References: In-Reply-To: Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Assp-Version: 2.1.1(11364) on assp.commandprompt.com X-Assp-Client-SSL: yes X-Assp-ID: assp.commandprompt.com m1-37591-02386 X-Assp-Envelope-From: jd@commandprompt.com X-Assp-Intended-For: victortcs@gmail.com X-Assp-Original-Subject: Re: [ADMIN] Streaming replication and partitions X-Pg-Spam-Score: -1.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 05/16/2013 01:36 PM, Victor Tan wrote: > I am basically familiar with postgreSQL (in older incarnations) but have > not really done a streaming replication (WAL) setup before. > > In planning for my setup, I am going to use table partitioning and > tablespaces to keep things as quick as "possible". However, in a > streaming replication environment, will the slave and the master have to > be _exactly_ the same in terms of tablespaces? Is it possible some > TBSPACE01 on the master be on /sda1 and the same TBSPACE01 on the slave > be on /sdb1? Yes, as long as sdb1 points to the same directory that sda1 on the other server points to. > > Will I have to set up identical hardware and identical drives and > directory structure between the master and slave? > Only in the sense of the database directories, tablespaces are directory specific. JD > Thanks. > > - Victor Tan -- Command Prompt, Inc. - http://www.commandprompt.com/ PostgreSQL Support, Training, Professional Services and Development High Availability, Oracle Conversion, Postgres-XC @cmdpromptinc - 509-416-6579 -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin