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.
Attachment:
smime.p7s
Description: S/MIME Cryptographic Signature
