Skip site navigation (1) Skip section navigation (2)

Re: HELP pleaseeee!!!

From: Chris Browne <cbbrowne(at)acm(dot)org>
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: HELP pleaseeee!!!
Date: 2004-08-25 15:46:44
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-admin
andresbarra(at)hotmail(dot)com ("andres barra") writes:
> hi, somebody can help me???
> I tried to create a new database but i canĀ“t.
> psql: FATAL:  Database "template1" does not exist in the system catalog.
> createdb: database creation failed
> I tried to make initdb in another directory and it shows me  Segmentation 
> Fault.
> how i do to restore the template1????

You could restore template1 from template0...

$ createdb -T template0 template1

I would suggest figuring out first why template1 got trashed, as
that's a pretty severe problem.  It sounds to me as though something's
severely broken with your PostgreSQL binaries; you may want to check
the provenance of the code.

If you compiled it yourself, then checking where the compile has
gotten to is clearly in your hands; if it was installed in "packaged"
form, you should look into whether someone has corrupted it, and
let name="cbbrowne" and tld="" in String.concat "@" [name;tld];;
The human race  will decree from time to time:  "There is something at
which it is absolutely forbidden to laugh."
-- Nietzche on Common Lisp

In response to

pgsql-admin by date

Next:From: Steve LaneDate: 2004-08-25 17:06:42
Subject: Odd query behavior [urgent, but long]
Previous:From: Frederic MassotDate: 2004-08-25 14:58:55
Subject: Size of database

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group