Richard Huxton <dev@archonet.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