Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 899669FA1BE for ; Fri, 19 Oct 2007 23:11:31 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 14981-07 for ; Fri, 19 Oct 2007 23:11:31 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5 Received: from web54302.mail.re2.yahoo.com (web54302.mail.re2.yahoo.com [206.190.49.112]) by postgresql.org (Postfix) with SMTP id CEC429FA1BD for ; Fri, 19 Oct 2007 23:11:30 -0300 (ADT) Received: (qmail 62673 invoked by uid 60001); 20 Oct 2007 02:11:29 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=X-YMail-OSG:Received:Date:From:Subject:To:MIME-Version:Content-Type:Content-Transfer-Encoding:Message-ID; b=o+Git5siH503UEj95U+0lnLAyyDS5Yi72SNUtSd6Pueysf72nDVwL5Zs+1ZpnWBXmVoYp79cMtxKOgzXm561xNgAbXUxK2F8mSpPtDaOzGDOe2SyP0sI/1xJmnbFRhVthqVPl+D1SWBZFPuAJjjGBm+kovJOjT45OcGgAZgSS0c=; X-YMail-OSG: I2eXO7UVM1mKJ5Y2UnJEc88EqNcH9IYu4KHnjWV6b3txJtbhtJjfE2Y91vlm2ukDKsvWrElhoRua6uOgSGLHUU1RErVMJkZ1zofvdrKxHP2yPOlqjyvbypD3DIelbj2X2yCaMsW90kReBA-- Received: from [69.224.218.191] by web54302.mail.re2.yahoo.com via HTTP; Fri, 19 Oct 2007 19:11:29 PDT Date: Fri, 19 Oct 2007 19:11:29 -0700 (PDT) From: chester c young Subject: backup database tablespace with rsync? To: sql pgsql MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit Message-ID: <451865.61216.qm@web54302.mail.re2.yahoo.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200710/84 X-Sequence-Number: 29456 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'? __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com