I'm trying to restore a dump done with pg_dumpall > 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
select version()
) and exact text of any error message.