Обсуждение: uh-oh, overwrote template1

I accidentally overwrote the template1 db when restoring a backup of
another DB. ($ psql template1 < backup.sql).

Is the template1 db important, or is this something I can live without?

If it's important how can I recover it?

Thanks,

Jean-Christian Imbeault

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/

Paul Makepeace wrote:
>
> http://techdocs.postgresql.org/redir.php?link=/techdocs/pgsqladventuresep1.php

Thank you! Just what I needed. Glad to see that someone else had the
same slip of the fingers as I did ;)

Jean-Christian Imbeault