Jan Poslusny <pajout@xxxxxxxxxxxx> 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 ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend