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/