database crash w/missing data [urgent] 
Author Message
 database crash w/missing data [urgent]

Yesterday I had a crash that cost me a week's worth of data.  Please not
this may not be the fault of postmaster, but I'm still in a bad way.  We had
some network problems and had to reboot the computer, using /sbin/reboot.
When the computer started up and we ran the postmaster startup script, all
of our databases were acting funny.

100% of the data was gone! From the shell if you went select * from company,
postgres reports 0 tuples! (but returns the schema).  The funny thing was,
if you went \d company, I would get the message 'relation company does not
exist'.  Also, \d would not list the relations.  This was true for all the
relations for all the databases.

Please not I was running fsync off for this database.

Because this database was running our customer management system, I had no
choice but to restore from backup.

Is there any possibility of restoring the missing data?


Sat, 25 Sep 2004 21:36:12 GMT
 [ 1 post ] 

 Relevant Pages 

1. URGENT! missing Data ENvironment Command in VB6

2. URGENT: Missing database tables

3. Database CRASHED very urgent!

4. URGENT: database crash - any idea welcome

5. Restored Database is missing data

6. After System Crash Redo Logs missing

7. After System Crash Redo Logs missing

8. database corruption, data loss after OS crash

9. VBfrontend - Access2000Back end - Access Database crashes - data destroyed

10. miss some rows of data while transfering data

11. URGENT sql works, but code missing from Query Editor

12. URGENT HELP NEEDED tables missing sql2000

Powered by phpBB® Forum Software