The following bug has been logged on the website:
Bug reference: 6581
Logged by: Keith Fiske
Email address: keith(at)omniti(dot)com
PostgreSQL version: 9.1.3
Operating system: Any
Description:
Using the --no-tablespaces option for pg_dumpall correctly stops tablespace
creation and each individual object from having its tablespace set. But if
the original database had its default tablespace changed, this is still
added at the beginning of the dump file:
ALTER DATABASE dbname SET default_tablespace TO 'old_db_tablespace';