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
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 |
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 |