pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Guru Prasad <pnguruji@yahoo.com>
Cc: pgsql-hackers@postgresql.org
Cc: pgsql-sql@postgresql.org
Subject: Re: [HACKERS] Postgres
Date: Sat, 16 Jun 2001 12:54:53 -0400
Message-ID: <28177.992710493@sss.pgh.pa.us> (raw)
In-Reply-To: <Pine.LNX.4.20.0106161049490.21517-100000@Larry.bks>
References: <Pine.LNX.4.20.0106161049490.21517-100000@Larry.bks>

Guru Prasad <pnguruji@yahoo.com> writes:
> using postgres 7.1 version. Now the database got corrupted. I had no clue
> how it got corrupted. Basically, i did found that the data of various
> users existing (in /usr/local/pgsql/data directory). But there were no
> data existing in the following system catalogs.

> pg_database. (except template0 & template1)
> pg_shadow.   (except postgres user. Previously 15 users were there.)
> pg_tables.   (Not showing any user created tables. Only system tables
> get displayed).

> But the data structure of individual tables exist somewhere. Suppose if i
> do 'select * from tablename' then field names gets displayed but says 'no
> rows'. At the same time, i am unable to get the structure through
> \d tablename. 

If there's no entry for your database in pg_database, how were you able
to connect to do a 'select * from tablename'?

I'd like to see exactly what you did and exactly what results you got,
not your interpretations about whether there's data in tables or not.
Whatever's going on here is probably more subtle than that.

			regards, tom lane



view thread (9+ messages)

Message-ID: <28177.992710493@sss.pgh.pa.us>
Permalink:  ../28177.992710493@sss.pgh.pa.us/
Also on:    postgresql.org/message-id/28177.992710493@sss.pgh.pa.us

 · 

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 using the --to and --cc options:
  reply via email

  To: pgsql-sql@postgresql.org
  Cc: tgl@sss.pgh.pa.us, pnguruji@yahoo.com, pgsql-hackers@postgresql.org
  Subject: Re: [HACKERS] Postgres
  In-Reply-To: <28177.992710493@sss.pgh.pa.us>

* 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