我首先在SSD上创建了一个postgres拥有的目录,并创建了如下表空间:我继续移动重要表及其上的所有索引(这只显示了一个分区,并且修改了父表):ALTER INDEX coreg_2010_a_pkey SET TABLESPACE ssd_tablespace;
ALTER TABLE visits_2010_a SET TABLESPACE ss
shared memory implementation ... posixLOG: could not link file "pg_xlog/xlogtemp.25" to "pg_xlog/000000010000000000000001": Operation not permitted
FATAL: could not open file"pg_xlog/00000001000
LOG: could not link file "pg_xlog/xlogtemp.1716" to "pg_xlog/000000010000000000000001" (initializationof log file): Operation not supported
FATAL: could not open file "pg_xlog/000000010000000000000001"