I have a potentially huge headache on an old (4.6) openacs install I have. It had been running fine for over a year.
Today I was called because the services had stopped. They rebooted the server.
I logged in and tried to restart aolserver/openacs... got the standard welcome screen you get when you first install openacs, just before it creates the datamodel.
I figure it is a database problem so I stop aolserver and ssh in but find only six tables! after a \dt using psql
List of relations
Name | Type | Owner
acs_mail_links | table |
acs_objects | table |
composition_rels | table |
membership_rels | table |
spam_messages | table |
users | table |
These tables have lots of old data. I just don't know what happened to all the other tables.
To make matters worse, there is no current backup. I am afraid to do anything that might make me lose more info.
Where do I start? Is there a way to find and recover data on the postgresql file system structure?