Re: Howto repair template1

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Jan Poslusny <pajout(at)gingerall(dot)cz>
Cc: PgSQL General ML <pgsql-general(at)postgresql(dot)org>
Subject: Re: Howto repair template1
Date: 2005-06-21 13:33:24
Message-ID: 1938.1119360804@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Jan Poslusny <pajout(at)gingerall(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Richard Huxton 2005-06-21 13:36:26 Re: Explain analyze gives no info
Previous Message Richard Huxton 2005-06-21 13:30:38 Re: problems with types after update to 8.0