X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 0D6805E46DC for ; Wed, 25 Aug 2004 13:31:35 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 40054-08 for ; Wed, 25 Aug 2004 16:31:38 +0000 (GMT) Received: from news.hub.org (news.hub.org [200.46.204.72]) by svr1.postgresql.org (Postfix) with ESMTP id CF9ED5E46CD for ; Wed, 25 Aug 2004 13:31:30 -0300 (ADT) Received: from news.hub.org (news.hub.org [200.46.204.72]) by news.hub.org (8.12.9/8.12.9) with ESMTP id i7PGVbLq044908 for ; Wed, 25 Aug 2004 16:31:37 GMT (envelope-from news@news.hub.org) Received: (from news@localhost) by news.hub.org (8.12.9/8.12.9/Submit) id i7PGA36N036905 for pgsql-admin@postgresql.org; Wed, 25 Aug 2004 16:10:03 GMT From: Chris Browne X-Newsgroups: comp.databases.postgresql.admin Subject: Re: HELP pleaseeee!!! Date: Wed, 25 Aug 2004 11:46:44 -0400 Organization: cbbrowne Computing Inc Lines: 32 Message-ID: <608yc3rziz.fsf@dev6.int.libertyrms.info> References: Mime-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit X-Complaints-To: usenet@news.hub.org User-Agent: Gnus/5.110003 (No Gnus v0.3) XEmacs/21.4 (Security Through Obscurity, linux) Cancel-Lock: sha1:UOmXknXzxaQ4tejN5Xo6zeU+O7s= To: pgsql-admin@postgresql.org X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=1.3 tagged_above=0.0 required=5.0 tests=PLING_PLING X-Spam-Level: * X-Archive-Number: 200408/245 X-Sequence-Number: 14640 andresbarra@hotmail.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 how/why... -- let name="cbbrowne" and tld="cbbrowne.com" in String.concat "@" [name;tld];; http://cbbrowne.com/info/finances.html The human race will decree from time to time: "There is something at which it is absolutely forbidden to laugh." -- Nietzche on Common Lisp