Moving a tablespace - Mailing list pgsql-performance

From Craig A. James
Subject Moving a tablespace
Date
Msg-id 44EBAC86.7070503@modgraph-usa.com
Whole thread Raw
Responses Re: Moving a tablespace
List pgsql-performance
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 made a dumb mistake. 

Is there a way to move a tablespace to a new location without a dump/restore?  I, er, this hypothetical guy, knows he
canmove it and put a symbolic link in for /disk2, but this is somewhat unsatisfactory since "/disk2" would have to
existforever. 

Thanks,
Craig

pgsql-performance by date:

Previous
From: "Subbiah, Stalin"
Date:
Subject: Query tuning
Next
From: Michael Fuhr
Date:
Subject: Re: Moving a tablespace