Tino Wildenhain wrote:
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?
Yes. But it requires copying all the data.
--
Heikki Linnakangas
EnterpriseDB http://www.enterprisedb.com
