Bruce Momjian <pgman@xxxxxxxxxxxxxxxx> writes: > Should pg_dumpall be using the "SET default_tablespace = foo" method as > well? That would mean changing the semantics of CREATE DATABASE; currently it copies the default tablespace from the template database, rather than looking at default_tablespace. I'm unsure if that's a good idea or not. None of the other properties of a database are handled that way. regards, tom lane