Utkarsh Porwal wrote:
> Any advise or experience with restoring the db server using VM snapshots with a caveat that snapshots
> have been taken with DB running and nt stopped.
This is explained in the documentation:
http://www.postgresql.org/docs/current/static/backup-file.html
The key word is "consistent snapshot": if it is a truly atomic file system
snapshot, crash recovery will get your database up an running.
All you have to do is start the database.
If the snapshot is not truly atomic, you will very likely end up with
a corrupted database.
Yours,
Laurenz Albe