Database tables disappeared.

From: Stefan Klopp <sklopp(at)ecmarket(dot)com>
To: PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Database tables disappeared.
Date: 2001-01-26 21:47:54
Message-ID: 3A71F08A.1C332ADB@ecmarket.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-jdbc

I was woundering if any of you have seen this problem.

I have been running a system using a postgres 6.5 database. After a while
I realized the system wasn't very active so I looked into it. I tryed to view
all the tables in the database using the \d command, but it return:

- Couldn't find any tables, sequences or indices!

So I then tried to do a select statement from the table, which worked,
although no data was returned, but the table structure was correct.

I have backed up my database and have been trying to recover my data with no
luck. I am able to vacuum the tables and have it tell me that there are
several those tuples in each table, yet I still cant view the data.

Any suggestions?

Thanks,

Stefan Klopp

ecmarket

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2001-01-26 21:49:12 Re: Sure enough, the lock file is gone
Previous Message Tom Lane 2001-01-26 21:33:36 Re: Hardwired MAXBACKENDS limit could be history

Browse pgsql-jdbc by date

  From Date Subject
Next Message Barry Lind 2001-01-26 23:37:50 Re: [BUGS] no way in LargeObject API to detect short read?
Previous Message Bruce Momjian 2001-01-26 21:24:39 Re: Open 7.1 items