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 DB0433B728A for ; Thu, 16 Dec 2004 18:05:38 +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 89373-02 for ; Thu, 16 Dec 2004 18:05:29 +0000 (GMT) Received: from koolancexeon.g2switchworks.com (mail.g2switchworks.com [63.87.162.25]) by svr1.postgresql.org (Postfix) with ESMTP id 5E8C63B719B for ; Thu, 16 Dec 2004 18:05:27 +0000 (GMT) Received: mail.g2switchworks.com 10.10.1.8 from 10.10.1.37 10.10.1.37 via HTTP with MS-WebStorage 6.5.6944 Received: from state.g2switchworks.com by mail.g2switchworks.com; 16 Dec 2004 12:05:26 -0600 Subject: Re: missing schemas from template1 From: Scott Marlowe To: Tom Lane Cc: drdani@mazsola.iit.uni-miskolc.hu, pgsql-admin@postgresql.org In-Reply-To: <26326.1103219998@sss.pgh.pa.us> References: <25467.1103215423@sss.pgh.pa.us> <25662.1103216481@sss.pgh.pa.us> <26326.1103219998@sss.pgh.pa.us> Content-Type: text/plain Content-Transfer-Encoding: 7bit Message-Id: <1103220325.22049.99.camel@state.g2switchworks.com> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.4.6 (1.4.6-2) Date: Thu, 16 Dec 2004 12:05:26 -0600 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/182 X-Sequence-Number: 15768 On Thu, 2004-12-16 at 11:59, Tom Lane wrote: > drdani@mazsola.iit.uni-miskolc.hu writes: > > On Thu, 16 Dec 2004, Tom Lane wrote: > >> It's difficult to believe that those aren't there, or that the database > >> would appear to work if they were not. > > > The databse is not useable, so that's right. > > >> Are you able to do, say, "select > >> * from pg_namespace"? > > > The system is closed, I have no access to it from home, so I can't try > > it right now. The answer is surely no. > > If not, why are you so certain that the problem is with missing schemas > and not something else? I would think it would be impossible to do any > investigation at all, if the initial catalog contents are messed up that > badly. Maybe the hosting company is running 7.2 or something like that?