Rod,
> I think what we want is a clean template without all of the extras that
> template1 has.
We have this, it's called Template0.
Actually, KL, that would solve a lot of these duplicate object problems. What
if pg_restore used Template0 and not Template1? It wouldn't fix the "drop
public schema" issue but it would solve the others.
--
Josh Berkus
Aglio Database Solutions
San Francisco