Re: uh-oh, overwrote template1 - Mailing list 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/