Ted Byers <r.ted.byers@rogers.com> writes:
> It seems the public schema is
> automagically created by Postgres every time I create
> a new database on a given server, and it has over a
> dozen types, over 400 functions, &c. I don't really
> understand why it needs to be duplicated in every Db
> on a server, but that is another matter.
What it sounds like to me is that you've managed to clutter your
template1 with a lot of stuff you don't actually want, and that's
getting propagated into new databases by CREATE DATABASE. If so,
it's not pg_dump's fault --- you need to clean out template1.
regards, tom lane