Postgres Pro
Downloads
Home   >   mailing lists

Howto repair template1 - Mailing list pgsql-general

From Jan Poslusny
Subject Howto repair template1
Date
Msg-id 42B7F039.1080504@gingerall.cz
Whole thread Raw
Responses Re: Howto repair template1
Re: Howto repair template1
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: Martijn van Oosterhout
Date:
Subject: Re: renumber id's in correct order (compact id's)
Next
From: Richard Huxton
Date:
Subject: Re: Howto repair template1