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 0641A3B6E70 for ; Thu, 16 Dec 2004 17:01:32 +0000 (GMT) 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 51696-05 for ; Thu, 16 Dec 2004 17:01:24 +0000 (GMT) Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by svr1.postgresql.org (Postfix) with ESMTP id 114B43B2552 for ; Thu, 16 Dec 2004 17:01:24 +0000 (GMT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.13.1/8.13.1) with ESMTP id iBGH1Lal025663; Thu, 16 Dec 2004 12:01:21 -0500 (EST) To: drdani@mazsola.iit.uni-miskolc.hu Cc: pgsql-admin@postgresql.org Subject: Re: missing schemas from template1 In-reply-to: References: <25467.1103215423@sss.pgh.pa.us> Comments: In-reply-to drdani@mazsola.iit.uni-miskolc.hu message dated "Thu, 16 Dec 2004 17:58:42 +0100" Date: Thu, 16 Dec 2004 12:01:21 -0500 Message-ID: <25662.1103216481@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.005 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200412/171 X-Sequence-Number: 15757 drdani@mazsola.iit.uni-miskolc.hu writes: > On Thu, 16 Dec 2004, Tom Lane wrote: >> Uh ... what schemas are you expecting to find there? > In normal cases there are: > information_schema > pg_catalog > pg_temp1 > pg_toast > public > schemas. Without them the database is not really usefull. When I > create the first database (as copy of template1 of course) it misses > those schemas. I don't know what is the normal way to create them if > `initdb' didn't do it (it just said it did...) It's difficult to believe that those aren't there, or that the database would appear to work if they were not. Are you able to do, say, "select * from pg_namespace"? regards, tom lane