Received: from localhost (unknown [200.46.204.183]) by developer.postgresql.org (Postfix) with ESMTP id DF4632E004A for ; Mon, 26 May 2008 14:32:33 -0300 (ADT) Received: from developer.postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 86376-04 for ; Mon, 26 May 2008 14:32:14 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from moutng.kundenserver.de (moutng.kundenserver.de [212.227.126.179]) by developer.postgresql.org (Postfix) with ESMTP id 5F6B82E003B for ; Mon, 26 May 2008 14:32:15 -0300 (ADT) Received: from webserv.wug.de ([194.25.154.138]) by mrelayeu.kundenserver.de (node=mrelayeu5) with ESMTP (Nemesis) id 0ML25U-1K0gYP07JU-0006zv; Mon, 26 May 2008 19:32:14 +0200 Received: from kretschmer by webserv.wug.de with local (Exim 3.36 #1) id 1K0gYO-0004SS-00 for pgsql-performance@postgresql.org; Mon, 26 May 2008 19:32:12 +0200 Date: Mon, 26 May 2008 19:32:12 +0200 From: "A. Kretschmer" To: pgsql-performance@postgresql.org Subject: Re: Symbolic Links to Tablespaces Message-ID: <20080526173212.GA17009@a-kretschmer.de> References: <21505.1211814531@sss.pgh.pa.us> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: X-OS: Debian/GNU Linux - weil ich es mir Wert bin! User-Agent: Mutt/1.5.9i X-Provags-ID: V01U2FsdGVkX1/ahvDnXFfJ8tk/36b14nB66jV2h7nUDmSkBqN Mu8ZHaYMrbJRaKPDPSAwq9j87j8ybekT0EAgs0Y4NgmEwN7Wwa JxD57p7WJGA7nferDMVtMStRpNJ/NLp X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200805/337 X-Sequence-Number: 30305 am Mon, dem 26.05.2008, um 12:10:07 -0500 mailte Campbell, Lance folgendes: > Once I have assigned tables and indexes to a particular tablespace that > points to a particular location on disk is there a simple way to move > the files to a new location? > > Example: > Table xyz is using tablespace xyz_tbl which is located at > /somedir/xyz_tbl on the disk. If I want to move it to a new disk > located at /someotherdir/xyz_tbl/ how can I do that easily? ALTER TABLE SET TABLESPACE http://www.postgresql.org/docs/8.3/static/sql-altertable.html PS.: please no top-posting. Andreas -- Andreas Kretschmer Kontakt: Heynitz: 035242/47150, D1: 0160/7141639 (mehr: -> Header) GnuPG-ID: 0x3FFF606C, privat 0x7F4584DA http://wwwkeys.de.pgp.net