June 18th, 2012, 05:43 AM
How to view last restore time?
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.