Received: from localhost (maia-1.hub.org [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id BE32A9FB2D0 for ; Mon, 5 Feb 2007 16:14:37 -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 02803-01 for ; Mon, 5 Feb 2007 16:14:31 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4 Received: from ciao.gmane.org (main.gmane.org [80.91.229.2]) by postgresql.org (Postfix) with ESMTP id 01F1C9FB2C9 for ; Mon, 5 Feb 2007 16:14:31 -0400 (AST) Received: from list by ciao.gmane.org with local (Exim 4.43) id 1HEAEJ-0006ak-6S for pgsql-admin@postgresql.org; Mon, 05 Feb 2007 21:14:23 +0100 Received: from 85.187.136.11 ([85.187.136.11]) by main.gmane.org with esmtp (Gmexim 0.1 (Debian)) id 1AlnuQ-0007hv-00 for ; Mon, 05 Feb 2007 21:14:23 +0100 Received: from milen by 85.187.136.11 with local (Gmexim 0.1 (Debian)) id 1AlnuQ-0007hv-00 for ; Mon, 05 Feb 2007 21:14:23 +0100 X-Injected-Via-Gmane: http://gmane.org/ To: pgsql-admin@postgresql.org From: "Milen A. Radev" Subject: Re: Moving a table to another directory Date: Mon, 05 Feb 2007 22:14:16 +0200 Lines: 16 Message-ID: <45C79018.2080101@radev.net> References: <86aad3420702051141u6903bc7evea2ff90dd9ecda00@mail.gmail.com> Mime-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 8bit X-Complaints-To: usenet@sea.gmane.org X-Gmane-NNTP-Posting-Host: 85.187.136.11 User-Agent: Mozilla Thunderbird 1.5.0.9 (Windows/20061207) In-Reply-To: <86aad3420702051141u6903bc7evea2ff90dd9ecda00@mail.gmail.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.631 tagged_above=0 required=5 tests=AWL, BAYES_20, RCVD_NUMERIC_HELO, SPF_HELO_PASS, SPF_PASS X-Spam-Level: X-Archive-Number: 200702/60 X-Sequence-Number: 24525 Ezequiel Luis Pellettieri написа: > Hi guys I have a big table (25 gb) and a need to move it to another > directory cos i'm out of space. > making a symlik will be ok? or I have to do something else > 1. CREATE TABLESPACE xxx LOCATION 'another_dir' (http://www.postgresql.org/docs/current/static/sql-createtablespace.html); 2. ALTER TABLE big_table SET TABLESPACE xxx; (http://www.postgresql.org/docs/current/static/sql-altertable.html) -- Milen A. Radev