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