Received: from makus.postgresql.org (makus.postgresql.org [98.129.198.125]) by mail.postgresql.org (Postfix) with ESMTP id 1A3BE3E3C9D for ; Sun, 4 Dec 2011 12:12:30 -0400 (AST) Received: from momjian.us ([72.94.173.45]) by makus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1RXEg1-0002PO-Ka for pgsql-docs@postgresql.org; Sun, 04 Dec 2011 16:12:30 +0000 Received: (from bruce@localhost) by momjian.us (8.11.6/8.11.6) id pB4GCHt06225; Sun, 4 Dec 2011 11:12:17 -0500 (EST) From: Bruce Momjian Message-Id: <201112041612.pB4GCHt06225@momjian.us> Subject: Re: Moving tablespaces In-Reply-To: To: Magnus Hagander Date: Sun, 4 Dec 2011 11:12:17 -0500 (EST) CC: PostgreSQL-documentation X-Mailer: ELM [version 2.4ME+ PL124 (25)] MIME-Version: 1.0 Content-Transfer-Encoding: 7bit Content-Type: text/plain; charset="US-ASCII" X-Pg-Spam-Score: -3.1 (---) X-Archive-Number: 201112/6 X-Sequence-Number: 7113 Magnus Hagander wrote: > On Sun, Dec 4, 2011 at 00:43, Bruce Momjian wrote: > > Do we have any documentation about how to move a tablespace to a new > > directory? ?If not, I think we should write some. > > Do we have any support for doing it? (Yes, it works, but anything that > requires manual hacking of system catalogs really can't be considered > supported, can it?) True. It is something we just don't support? They have to dump, edit the dump, and reload, to change a tablespace directory? Yikes. Is that the state we are in? Has no one complained about this? They just use symlinks? -- Bruce Momjian http://momjian.us EnterpriseDB http://enterprisedb.com + It's impossible for everything to be true. +