Restoring template1

From: Michal Taborsky <michal(at)taborsky(dot)cz>
To: pgsql-general(at)postgresql(dot)org
Subject: Restoring template1
Date: 2004-07-01 08:50:23
Message-ID: 40E3D04F.7090009@taborsky.cz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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 ;-).

--
Michal Taborsky
http://www.taborsky.cz

Responses

Browse pgsql-general by date

  From Date Subject
Next Message peter pilsl 2004-07-01 08:56:29 sql-question: sum-function and subqueries?
Previous Message Maciej Bliziński 2004-07-01 08:23:29 Re: Bug in function to_char() !!