restoring Postgres dump with tablespaces I'm trying to restore a dump done with pg_dumpall &gt; mybak.sql from a server that has 1 table in a different tablespace that the default one.

On the target machine I have recreated the directory structure of the tablespace and it is owned by the postgres user with read/write permissions but still the restore is failing. Any suggestions? 

command used to restore is:

psql mydb -f mybak.sql

Thanks
Got it,

had to recreate the tablespace manually on target before restoring the dump.

Thanks anyway