Howto repair template1

From: Jan Poslusny <pajout(at)gingerall(dot)cz>
To: PgSQL General ML <pgsql-general(at)postgresql(dot)org>
Subject: Howto repair template1
Date: 2005-06-21 10:47:21
Message-ID: 42B7F039.1080504@gingerall.cz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Richard Huxton 2005-06-21 11:10:59 Re: Howto repair template1
Previous Message Martijn van Oosterhout 2005-06-21 09:37:21 Re: renumber id's in correct order (compact id's)