Home / server / Questions / 438050
Accepted
greenoldman
Asked: 2012-10-14 09:33:04 +0800 CST

How to move tablespace to another directory?

  • 772

Let's say I have tablespace A located in the directory /A1, and I would like to move it (everything) to directory /A2?

I use openSUSE + PostgreSQL 9.1, and if this simplifies anything -- I can stop it (entire server) without a problem. Please note I am asking about entire tablespace and the tablespace already contains data!

linux

1 Answers

  1. Best Answer

    This excerpt from the docs should get you going:

    The directory $PGDATA/pg_tblspc contains symbolic links that point to each of the non-built-in tablespaces defined in the cluster. Although not recommended, it is possible to adjust the tablespace layout by hand by redefining these links. Two warnings: do not do so while the server is running; and after you restart the server, update the pg_tablespace catalog with the new locations. (If you do not, pg_dump will continue to output the old tablespace locations.)

    • 3