pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: James Neville <james.neville@babcockbrown.com>
To: pgsql-admin@postgresql.org
Subject: Missing Schemas
Date: Wed, 14 Jan 2004 16:19:32 +0000
Message-ID: <40056C14.8080909@babcockbrown.com> (raw)

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.






Message-ID: <40056C14.8080909@babcockbrown.com>
Permalink:  ../40056C14.8080909@babcockbrown.com/
Also on:    postgresql.org/message-id/40056C14.8080909@babcockbrown.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-admin@postgresql.org
  Cc: james.neville@babcockbrown.com
  Subject: Re: Missing Schemas
  In-Reply-To: <40056C14.8080909@babcockbrown.com>
  References: <40056C14.8080909@babcockbrown.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox