I'm trying to import a new data set into postgres 9.6, but the data to import use a different table space (for example, Y) and the import has not been able to set the default table space (for example, X) on the server. Found only when the import has thrown pg_restore: [archiver] Fault …
I want to know if it is possible to create a new table space in order to be able to import it.
I do not want to change the default tablespace of the current database because it has multiple users.
Should I create a new database and link to the Y tablespace? Or is it possible to modify the current database?