| From: | Ian Barwick <barwick(at)gmail(dot)com> |
|---|---|
| To: | Michal Taborsky <michal(at)taborsky(dot)cz> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Restoring template1 |
| Date: | 2004-07-01 09:31:18 |
| Message-ID: | 1d581afe04070102313b5dd32d@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Thu, 01 Jul 2004 10:50:23 +0200, Michal Taborsky <michal(at)taborsky(dot)cz> wrote:
>
> Hi there.
>
> I had a weak moment and accidentally ran a dump restore script on
> template1 instead of proper database. So my template1 is now polluted
> with many tables, sequences and the like.
>
> Is there a way to restore a pristine template1? I haven't done any
> modifications to it, so I'd be good with the one distributed with
> default installation. Is it safe to DROP DATABASE template1 and recreate
> it with dump from different cluster? (Currently I have 7.4.1 available
> on other machine.)
>
> Thanks for any advice. It's not critical, but I'm too lazy to clear
> everything manually ;-).
try:
http://techdocs.postgresql.org/techdocs/pgsqladventuresep1.php
HTH
Ian Barwick
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Stephane Bortzmeyer | 2004-07-01 10:36:43 | Re: Bug in function to_char() !! |
| Previous Message | peter pilsl | 2004-07-01 08:56:29 | sql-question: sum-function and subqueries? |