Обсуждение: 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