Postgres Pro
Downloads
Home   >   mailing lists

Re: Howto repair template1 - Mailing list pgsql-general

From Tom Lane
Subject Re: Howto repair template1
Date
Msg-id 1938.1119360804@sss.pgh.pa.us
Whole thread Raw
In response to Howto repair template1  (Jan Poslusny <pajout@gingerall.cz>)
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: peter pilsl
Date:
Subject: Re: renumber id's in correct order (compact id's)
Next
From: Richard Huxton
Date:
Subject: Re: problems with types after update to 8.0