Bruce Momjian <[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org