Received: from localhost (unknown [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id 0935F9F9EFD for ; Sat, 20 Oct 2007 11:52:36 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.182]) (amavisd-maia, port 10024) with ESMTP id 95066-02 for ; Sat, 20 Oct 2007 11:52:27 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5 Received: from ug-out-1314.google.com (ug-out-1314.google.com [66.249.92.173]) by postgresql.org (Postfix) with ESMTP id 01C989F9941 for ; Sat, 20 Oct 2007 11:52:32 -0300 (ADT) Received: by ug-out-1314.google.com with SMTP id j3so733953ugf for ; Sat, 20 Oct 2007 07:52:31 -0700 (PDT) Received: by 10.67.29.12 with SMTP id g12mr3787678ugj.1192870880758; Sat, 20 Oct 2007 02:01:20 -0700 (PDT) Received: by 10.67.29.6 with HTTP; Sat, 20 Oct 2007 02:01:20 -0700 (PDT) Message-ID: Date: Sat, 20 Oct 2007 04:01:20 -0500 From: "Scott Marlowe" To: "chester c young" Subject: Re: backup database tablespace with rsync? Cc: "sql pgsql" In-Reply-To: <451865.61216.qm@web54302.mail.re2.yahoo.com> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline References: <451865.61216.qm@web54302.mail.re2.yahoo.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200710/86 X-Sequence-Number: 29458 On 10/19/07, chester c young wrote: > postgres A, db 'test', tablespace /pg/test1 > postgres B, db 'test', tablespace /pg/test2 > > tablespace /pg/test1 only has A db 'test' > tablespace /pg/test2 only has B db 'test' > > if > - A and B shut down > - /pg/test1 copied to /pg/test2 > - A and B restarted > > would B db 'test' be running the data that was in A db 'test'? You can't rsync just pieces of the db. you have to copy the whole database