Skip site navigation (1) Skip section navigation (2)

Missing Schema

From: James Neville <james(dot)neville(at)babcockbrown(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Missing Schema
Date: 2004-01-14 16:26:33
Message-ID: 40056DB9.70502@babcockbrown.com (view raw or flat)
Thread:
Lists: pgsql-admin
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.


Responses

pgsql-admin by date

Next:From: Peter EisentrautDate: 2004-01-14 17:12:32
Subject: Re: Missing Schema
Previous:From: James NevilleDate: 2004-01-14 16:19:32
Subject: Missing Schemas

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group