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 CFC69D1D541 for ; Wed, 14 Jan 2004 16:37:30 +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 50271-05 for ; Wed, 14 Jan 2004 12:36:53 -0400 (AST) Received: from clientmail2.amicus.com (clientmail2.amicus.com [208.134.137.26]) by svr1.postgresql.org (Postfix) with ESMTP id 58236D1DA2E for ; Wed, 14 Jan 2004 12:36:52 -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 i0EGaoTZ028520 for ; Wed, 14 Jan 2004 10:36:50 -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 i0EGOPVx010812 for ; Wed, 14 Jan 2004 08:24:25 -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 i0EGZ6A6011925 for ; Wed, 14 Jan 2004 08:35:07 -0800 (PST) Received: from babcockbrown.com by cracker.eu.babcockbrown.com (8.9.3+Sun/SMI-SVR4) id QAA12938; Wed, 14 Jan 2004 16:37:42 GMT Message-ID: <40056DB9.70502@babcockbrown.com> Date: Wed, 14 Jan 2004 16:26:33 +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 Schema 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/120 X-Sequence-Number: 11983 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.