Bruce Momjian <pgman@candle.pha.pa.us> writes:
> I have a few other questions:
> What is the procedure for moving tablespace directories?
There is none.
> However, pg_tablespace still has the old location.
Yup. The *only* thing that pg_tablespace.spclocation is used for is
for pg_dumpall to dump appropriate CREATE TABLESPACE commands, so it's
not like you couldn't hack it after the fact.
> Do we need ALTER TABLESPACE to move tablespaces, and ALTER clauses to
> move objects to other tablespaces? Are these TODO items for later?
TODO. You sound like a man who's expecting a
several-generations-polished facility when we only just committed
the first version today. I do not feel a need to have any of these
features in 7.5 ...
regards, tom lane