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 18E793B720A; Thu, 16 Dec 2004 18:23:29 +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 41722-07; Thu, 16 Dec 2004 18:23:23 +0000 (GMT) Received: from tus-gate2.raytheon.com (tus-gate2.raytheon.com [199.46.245.231]) by svr1.postgresql.org (Postfix) with ESMTP id EF0013B74B7; Thu, 16 Dec 2004 18:23:22 +0000 (GMT) Received: from ds02w00.directory.ray.com (ds02w00.directory.ray.com [147.25.146.118]) by tus-gate2.raytheon.com (8.12.10/8.12.10) with ESMTP id iBGINDMJ011411; Thu, 16 Dec 2004 11:23:15 -0700 (MST) Received: from ds02w00 (localhost [127.0.0.1]) by ds02w00.directory.ray.com (Switch-3.1.4/Switch-3.1.0) with ESMTP id iBGIMt8x029656; Thu, 16 Dec 2004 18:22:56 GMT Received: from ds02w00.directory.ray.com with LMTP by ds02w00 (2.0.6/sieved-2-0-build-559); Thu, 16 Dec 2004 18:22:55 +0000 Received: from notesserver5.ftw.us.ray.com (notesserver5.ftw.us.ray.com [151.168.145.35]) by ds02w00.directory.ray.com (Switch-3.1.4/Switch-3.1.0) with ESMTP id iBGILwYa029329 sender Richard_D_Levine@raytheon.com; Thu, 16 Dec 2004 18:22:01 GMT Subject: Re: missing schemas from template1 To: Scott Marlowe Cc: drdani@mazsola.iit.uni-miskolc.hu, pgsql-admin@postgresql.org, pgsql-admin-owner@postgresql.org, Tom Lane X-Mailer: Lotus Notes Release 5.0.8 June 18, 2001 Message-ID: From: Richard_D_Levine@raytheon.com Date: Thu, 16 Dec 2004 13:18:11 -0500 X-MIMETrack: Serialize by Router on NotesServer5/HDC(Release 6.5.2|June 01, 2004) at 12/16/2004 01:22:01 PM MIME-Version: 1.0 Content-type: text/plain; charset=US-ASCII X-SPAM: 0.00 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.178 tagged_above=0 required=5 tests=NO_REAL_NAME X-Spam-Level: X-Archive-Number: 200412/183 X-Sequence-Number: 15769 Did you turn on the "view system objects" thingy in pgadmin3? That's too technical%| Okay, I just checked and it's Display->System Objects. Scott Marlowe ks.com> cc: drdani@mazsola.iit.uni-miskolc.hu, pgsql-admin@postgresql.org Sent by: Subject: Re: [ADMIN] missing schemas from template1 pgsql-admin-owner@pos tgresql.org 12/16/2004 01:05 PM 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? ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html