Обсуждение: Howto repair template1

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?

Thanks,

pajout

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

Jan Poslusny <pajout@gingerall.cz> writes:
> 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?

See
http://techdocs.postgresql.org/techdocs/pgsqladventuresep1.php

            regards, tom lane