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