| From: | Richard Huxton <dev(at)archonet(dot)com> |
|---|---|
| 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 11:10:59 |
| Message-ID: | 42B7F5C3.1010506@archonet.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Jan Poslusny wrote:
> 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?
When you recreate template1, you can specify template0 as the template
to use (if you see what I mean)
createdb --template template0 template1
--
Richard Huxton
Archonet Ltd
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jason Tesser | 2005-06-21 12:08:16 | Re: problems with types after update to 8.0 |
| Previous Message | Jan Poslusny | 2005-06-21 10:47:21 | Howto repair template1 |