Re: [GENERAL] Howto repair template1

2005-06-21 Thread Tom Lane
Jan Poslusny <[EMAIL PROTECTED]> 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

Re: [GENERAL] Howto repair template1

2005-06-21 Thread Richard Huxton
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 inst

[GENERAL] Howto repair template1

2005-06-21 Thread Jan Poslusny
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, paj