On Friday, December 27, 2013, Joseph Kregloh wrote: > FYI, some testing showed that playing around with spclocation in >> pg_tablespace is not recommended. > > > Do you happen to have more information about this? Because it would > actually solve all my problems by moving the user created tablespaces out > of the /data directory. But I would like more information on the subject > before even thinking about it anymore. I did it a couple times for testing > purposes. I modified the spclocation in pg_tablespace and then move the > folder. >
spclocation no longer exists in 9.3. If the database needs to know where the location is, it inspects the symlink in pg_tblspc to figure that out. Cheers, Jeff >