PostgreSQL db volume at 100%. Can I create a tablespace on another volume so I can vacuum full?
Here's what You can do to move your data to the new tablespace :


Create the new tablespace pointing to the new location.

postgres=# create TABLESPACE movespace LOCATION '/home/postgres_tbsp';
CREATE TABLESPACE

Alter table or database to move to the new tablespace.

postgres=# ALTER DATABASE slonmaster SET tablespace movespace;
ALTER DATABASE



This process could last long as it moves all the data in the table or database to a new location.