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
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
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: