Over the weekend, some users were working as normal, but when we got in this morning, all the changes that they made had been reverted. I am suspecting that someone has logged in and restored the database to a previous backup version(from Friday). Is there any way that I can see when the database was last restored ? Also, is there some way that I can convert the pg_xlogs to a readable format?
Any help would be greatly appreciated.
I am using postgres 9.0
Thanks in advance.