Richard Huxton <dev(at)archonet(dot)com> writes:
> Actually, IIRC this is exactly why we have template0 -
> for those occasions where you want to regenerate template1.
Well, that's one of its uses.
IIRC there is a page on techdocs.postgresql.org that will walk you
through this procedure. There are a couple of safety interlocks you
need to defeat temporarily, so it's a bit more than a DROP and a CREATE.
regards, tom lane