pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Missing Schema
5+ messages / 3 participants
[nested] [flat]

* Missing Schema
@ 2004-01-14 16:26  James Neville <james.neville@babcockbrown.com>
  0 siblings, 2 replies; 5+ messages in thread

From: James Neville @ 2004-01-14 16:26 UTC (permalink / raw)
  To: 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.




^ permalink  raw  reply  [nested|flat] 5+ messages in thread

* Re: Missing Schema
@ 2004-01-14 17:12  Peter Eisentraut <peter_e@gmx.net>
  parent: James Neville <james.neville@babcockbrown.com>
  1 sibling, 1 reply; 5+ messages in thread

From: Peter Eisentraut @ 2004-01-14 17:12 UTC (permalink / raw)
  To: James Neville <james.neville@babcockbrown.com>; pgsql-admin

James Neville wrote:
> Does anyone have a clue as to how this may have happened, and an
> approach to remedying the problem with a reinstall?

Well, perhaps you have simply dropped them?  You can just recreate them.




^ permalink  raw  reply  [nested|flat] 5+ messages in thread

* Re: Missing Schema
@ 2004-01-14 17:16  James Neville <james.neville@babcockbrown.com>
  parent: Peter Eisentraut <peter_e@gmx.net>
  0 siblings, 1 reply; 5+ messages in thread

From: James Neville @ 2004-01-14 17:16 UTC (permalink / raw)
  To: pgsql-admin

Peter Eisentraut wrote:

>Well, perhaps you have simply dropped them?  You can just recreate them.
>
Well, thats a relief, but what tables do I need to recreate, and what 
are their schemas?
I'm also rather curious as to how/why someone would have dropped a 
system table.

Thanks,
James.




^ permalink  raw  reply  [nested|flat] 5+ messages in thread

* Re: Missing Schema
@ 2004-01-14 18:19  Peter Eisentraut <peter_e@gmx.net>
  parent: James Neville <james.neville@babcockbrown.com>
  0 siblings, 0 replies; 5+ messages in thread

From: Peter Eisentraut @ 2004-01-14 18:19 UTC (permalink / raw)
  To: James Neville <james.neville@babcockbrown.com>; pgsql-admin

James Neville wrote:
> Peter Eisentraut wrote:
> >Well, perhaps you have simply dropped them?  You can just recreate
> > them.
>
> Well, thats a relief, but what tables do I need to recreate, and what
> are their schemas?

You don't need to create any tables, just schemas.

> I'm also rather curious as to how/why someone would have dropped a
> system table.

You didn't drop any system table (or you'd have far worse problems), you 
(possibly) just dropped the schema "public".




^ permalink  raw  reply  [nested|flat] 5+ messages in thread

* Re: Missing Schema
@ 2004-01-14 19:22  Tom Lane <tgl@sss.pgh.pa.us>
  parent: James Neville <james.neville@babcockbrown.com>
  1 sibling, 0 replies; 5+ messages in thread

From: Tom Lane @ 2004-01-14 19:22 UTC (permalink / raw)
  To: James Neville <james.neville@babcockbrown.com>; +Cc: pgsql-admin

James Neville <james.neville@babcockbrown.com> writes:
> Only recently, we have noticed the abscence of any schemas.

It's not possible that the database contains *no* schemas.  You are
being way too imprecise in describing the problem.

> The product issues queries like:
> SELECT * FROM dbname.public.users;

> Obviously, the JDBC Driver making the SQL query fails on 'public'.

What's obvious about it?  And what exactly is the error message?

I suspect you are completely misinterpreting what you are seeing.

			regards, tom lane



^ permalink  raw  reply  [nested|flat] 5+ messages in thread


end of thread, other threads:[~2004-01-14 19:22 UTC | newest]

Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2004-01-14 16:26 Missing Schema James Neville <james.neville@babcockbrown.com>
2004-01-14 17:12 ` Peter Eisentraut <peter_e@gmx.net>
2004-01-14 17:16   ` James Neville <james.neville@babcockbrown.com>
2004-01-14 18:19     ` Peter Eisentraut <peter_e@gmx.net>
2004-01-14 19:22 ` Tom Lane <tgl@sss.pgh.pa.us>

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