| From: | Paul Makepeace <postgresql(dot)org(at)paulm(dot)com> |
|---|---|
| To: | Jean-Christian Imbeault <jc(at)mega-bucks(dot)co(dot)jp> |
| Cc: | pgsql-novice(at)postgresql(dot)org |
| Subject: | Re: uh-oh, overwrote template1 |
| Date: | 2003-04-16 08:01:51 |
| Message-ID: | 20030416080151.GF7382@mythix.realprogrammers.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
On Wed, Apr 16, 2003 at 04:48:19PM +0900, Jean-Christian Imbeault wrote:
> I accidentally overwrote the template1 db when restoring a backup of
> another DB. ($ psql template1 < backup.sql).
I noticed this on techdocs,
http://techdocs.postgresql.org/redir.php?link=/techdocs/pgsqladventuresep1.php
``Josh Berkus' Adventures in PostgreSQL
Restoring a Corrupted Template1 using Template0
Josh accidentally loads data into the template1 database schema, then
shows you how to fix it.''
HTH, Paul
--
Paul Makepeace ....................................... http://paulm.com/
"What is love? The mind of the biggest head."
-- http://paulm.com/toys/surrealism/
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jean-Christian Imbeault | 2003-04-16 08:02:04 | Re: uh-oh, overwrote template1 |
| Previous Message | Jean-Christian Imbeault | 2003-04-16 07:48:19 | uh-oh, overwrote template1 |