HELP pleaseeee!!!

[andres barra]

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????

bye..thanks...

_________________________________________________________________
Charla con tus amigos en línea mediante MSN Messenger:
http://messenger.latam.msn.com/


---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

[Chris Browne]

Post by andres barra
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
how/why...