[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

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 would

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: