I've just rebooted my server after a crash/reboot (which I haven't determined the cause of yet). Server: centos, Postgresql: 9.2.8
It looks like all my postgresql databases were reverted to the state they were in 3 months ago. Columns that I added recently are missing and the maximum values for created
timestamp columns are all from 3 months ago.
Is there any crash scenario that could have caused this? Any ideas on an approach to recovery, apart from restoring from backup?