Re: [PERFORM] Moving a tablespace

2006-08-22 Thread Tom Lane
Michael Fuhr <[EMAIL PROTECTED]> writes: > On Tue, Aug 22, 2006 at 06:16:54PM -0700, Craig A. James wrote: >> Is there a way to move a tablespace to a new location without a >> dump/restore? > The last paragraph of the Tablespaces documentation might be helpful: > http://www.postgresql.org/docs/8

Re: [PERFORM] Moving a tablespace

2006-08-22 Thread Michael Fuhr
On Tue, Aug 22, 2006 at 06:16:54PM -0700, Craig A. James wrote: > Is there a way to move a tablespace to a new location without a > dump/restore? I, er, this hypothetical guy, knows he can move it and put a > symbolic link in for /disk2, but this is somewhat unsatisfactory since > "/disk2" woul

[PERFORM] Moving a tablespace

2006-08-22 Thread Craig A. James
Suppose, hypothetically of course, someone lacked foresight, and put a tablespace somewhere with a dumb name, like "/disk2", instead of using a symbolic link with a more descriptive name. And then /disk2 needs to be renamed, say to "/postgres_data", and this (hypothetical) DBA realizes he has