Alvaro Herrera <alvherre@dcc.uchile.cl> writes:
> On Fri, Jun 20, 2003 at 11:14:25AM -0600, scott.marlowe wrote:
>> Actually, template0 is the "oh dear god, what have I done to template1"
>> recovery database that the initdb script (now program) creates when run.
> I think template0 is also used to compute differences that should be
> written by pg_dump or pg_dumpall. I don't recall the exact details...
This is all covered in TFM ...
http://www.postgresql.org/docs/view.php?version=7.3&idoc=0&file=manage-ag-templatedbs.html
regards, tom lane