My postgres server is running out of space when restoring database, after dumping, How can I create a tablespace and specify a new database to that specific location.
Some examples would be nice. Thanks
PostgreSQL CREATE TABLESPACE statement
create database dbname with tablespace = tablespace_name;