X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 2EAD39DC810 for ; Mon, 19 Dec 2005 15:20:49 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 23190-09 for ; Mon, 19 Dec 2005 15:20:48 -0400 (AST) Received: from svr4.postgresql.org (svr4.postgresql.org [66.98.251.159]) by postgresql.org (Postfix) with ESMTP id B61A69DC871 for ; Mon, 19 Dec 2005 15:20:46 -0400 (AST) Received: from noel.decibel.org (unknown [67.100.216.10]) by svr4.postgresql.org (Postfix) with ESMTP id C30E15AF04D for ; Mon, 19 Dec 2005 19:20:47 +0000 (GMT) Received: by noel.decibel.org (Postfix, from userid 1001) id 29C1C39829; Mon, 19 Dec 2005 13:20:45 -0600 (CST) Date: Mon, 19 Dec 2005 13:20:45 -0600 From: "Jim C. Nasby" To: prabhakar V Cc: pgsql-admin@postgresql.org Subject: Re: Backup and clean up Message-ID: <20051219192045.GA28771@pervasive.com> References: <956e047a0512130148t4ae10446n8118f4e115cdf40b@mail.gmail.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <956e047a0512130148t4ae10446n8118f4e115cdf40b@mail.gmail.com> X-Operating-System: FreeBSD 6.0-RELEASE amd64 X-Distributed: Join the Effort! http://www.distributed.net User-Agent: Mutt/1.5.11 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.028 required=5 tests=[AWL=0.028] X-Spam-Score: 0.028 X-Spam-Level: X-Archive-Number: 200512/202 X-Sequence-Number: 19922 On Tue, Dec 13, 2005 at 03:18:40PM +0530, prabhakar V wrote: > or else how can i move this DB to some other partition. For ex : /data2 if > this possible, Please help me out. Use tablespaces. Though I think you can't alter a table's tablespace in 8.0... -- Jim C. Nasby, Sr. Engineering Consultant jnasby@pervasive.com Pervasive Software http://pervasive.com work: 512-231-6117 vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461