I need an advicer for recovering our PostgreSQL DB. We have all data (the whole folder) but no backup. We've already tried standard restart and also also tried pg_resetxlog. It allowed DB to start but it had anyway damaged indexes and lost 2 weeks of data. The case seem to be similar to this case:
[login to view URL]
But solution adviced there is also not working. If you know a solution I`d be grateful.
Thu, 12 Mar 2015 15:49:42 +0530
schema?
Any past backups?
Data size (on disk)?
Packaged or built PostgreSQL?
Data changes frequent?
Is db up now?
Priority at present: to recover lost data?
Any backups after restore?