Received: from localhost (maia-1.hub.org [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id 2DBE19FB329 for ; Tue, 6 Feb 2007 19:17:22 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-new, port 10024) with ESMTP id 69758-10 for ; Tue, 6 Feb 2007 19:17:18 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from exchange.g2switchworks.com (mail.g2switchworks.com [63.87.162.25]) by postgresql.org (Postfix) with ESMTP id 211EF9FB324 for ; Tue, 6 Feb 2007 19:17:16 -0400 (AST) Received: from 10.10.1.37 ([10.10.1.37]) by exchange.g2switchworks.com ([10.10.1.2]) with Microsoft Exchange Server HTTP-DAV ; Tue, 6 Feb 2007 23:17:15 +0000 Received: from state.g2switchworks.com by mail.g2switchworks.com; 06 Feb 2007 17:17:15 -0600 Subject: Re: how to add a new data partition From: Scott Marlowe To: Karthikeyan Sundaram Cc: pgsql-admin@postgresql.org In-Reply-To: References: Content-Type: text/plain Content-Transfer-Encoding: 7bit Message-Id: <1170803834.5451.115.camel@state.g2switchworks.com> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.4.6 (1.4.6-2) Date: Tue, 06 Feb 2007 17:17:15 -0600 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200702/89 X-Sequence-Number: 24554 On Tue, 2007-02-06 at 15:46, Karthikeyan Sundaram wrote: > Hi all, > > We are using postgres 8.0.1 on our production and 8.2 on our development. > The linuix partition is getting full where the database resides. In few > weeks our partition will ran out of space so the database will also run out > of space. We have added another HDD of 300GB. Now my question is, how will > I point the database to the new partition along with the old one. Do I need > to create a symbolic link to the exitisting DB? > > Adding a new tablespace doesn't solve the issue as there are many tables > in the old tablespace. Is there a way to extend the tablespace to the new > partition like in Oracle. So, alter table ... set tablespace new_tablespace doesn't work for you in this circumstance?