Re: BUG #5184: default tablespace owner is not dumped

"Robert Haas" <robertmhaas(at)gmail(dot)com> writes:
> The following command does not change the output of "pg_dumpall":
> alter tablespace pg_default owner to bob;

I don't think this is a bug. It's one specific aspect of a general
principle that system objects don't get dumped. If they did, using
pg_dump to upgrade across major versions would be somewhere between
impossible and your worst nightmare.

It might be nice if manual changes to system objects got dumped,
but that's really an AI-complete problem --- which properties of
the objects represent manual changes, and how can we know whether
trying to apply those changes to a new system version will work?

regards, tom lane