Heikki Linnakangas wrote:
...
> Shut down the database server, replace the symbolic link in
> data/pg_tblspc to the new location, and start the server again. The
> location is also stored in pg_tablespace catalog; you'll need to fix it
> with "UPDATE pg_tablespace SET spclocation ='/someotherdir/xyz_tbl'
> WHERE spcname='xyz_tbl'", or pg_dumpall will still show the old location.
>
wouldn't alter tablespace be not more easy and less fragile?
T.