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