X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (neptune.hub.org [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 063E5D1B46A for ; Wed, 14 Jan 2004 16:30:55 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 46988-10 for ; Wed, 14 Jan 2004 12:30:24 -0400 (AST) Received: from clientmail2.amicus.com (clientmail2.amicus.com [208.134.137.26]) by svr1.postgresql.org (Postfix) with ESMTP id 1697AD1D8AF for ; Wed, 14 Jan 2004 12:30:23 -0400 (AST) Received: from lombard.babcockbrown.com (lombard.babcockbrown.com [208.1.254.12]) by clientmail2.amicus.com (8.12.6/8.12.6) with ESMTP id i0EGU3TZ027303 for ; Wed, 14 Jan 2004 10:30:03 -0600 Received: from tiburon.us.babcockbrown.com (tiburon.babcockbrown.com [208.1.254.14]) by lombard.babcockbrown.com (8.12.10/8.12.10) with ESMTP id i0EGHYVx010593 for ; Wed, 14 Jan 2004 08:17:34 -0800 (PST) Received: from cracker.eu.babcockbrown.com (localhost [127.0.0.1]) by tiburon.us.babcockbrown.com (8.12.9/8.12.9) with ESMTP id i0EGSCA6011708 for ; Wed, 14 Jan 2004 08:28:14 -0800 (PST) Received: from babcockbrown.com by cracker.eu.babcockbrown.com (8.9.3+Sun/SMI-SVR4) id QAA12916; Wed, 14 Jan 2004 16:30:41 GMT Message-ID: <40056C14.8080909@babcockbrown.com> Date: Wed, 14 Jan 2004 16:19:32 +0000 From: James Neville User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.4) Gecko/20030624 X-Accept-Language: en-us, en MIME-Version: 1.0 To: pgsql-admin@postgresql.org Subject: Missing Schemas Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-RAVMilter-Version: 8.4.3(snapshot 20030212) (clientmail2.amicus.com) X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200401/152 X-Sequence-Number: 12015 Hi, We've got a rather odd problem with our PG 7.3.2 production installation. Everything is working fine on the surface, and has been for quite some time. Only recently, we have noticed the abscence of any schemas. We're at a complete loss as to how this happened, or even when. The databases we run are used purely for web applications, and are generally only ever accessed locally. It was only on debugging queries from a third party product that we noticed their absence. The product issues queries like: SELECT * FROM dbname.public.users; Obviously, the JDBC Driver making the SQL query fails on 'public'. We have another installation on a development machine that was compiled from source at the same time. This machine seems to be OK, so I doubt the production installation failed in any way. Does anyone have a clue as to how this may have happened, and an approach to remedying the problem with a reinstall? Many thanks in advance, James.