Jan Poslusny wrote:
> Hi,
> my colleague unfortunately ran some database dump in template1 on our
> production server, pg7.3.5. Can we drop template1, dump template0 and
> rebuild template1 from this dump? Or does exist some better way how to
> repair template1 without any affect of living database instances?
When you recreate template1, you can specify template0 as the template
to use (if you see what I mean)
createdb --template template0 template1
--
Richard Huxton
Archonet Ltd