miller_2555 <nabble(dot)30(dot)miller_2555(at)spamgourmet(dot)com> writes:
> So this does not work well apparently.
The only obvious thing wrong with your example is failing to preserve
ownership/permissions of the moved files. I think the upper directories
are probably not readable by Postgres so it's choking.
BTW, Postgres *already* refers to tablespaces via symlinks, so you could
do this with a tad less runtime overhead by re-pointing the appropriate
symlink inside $PGDATA/pg_tblspc/.
regards, tom lane