Обсуждение: 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