| From: | Albe Laurenz <laurenz(dot)albe(at)wien(dot)gv(dot)at> |
|---|---|
| To: | "'Porwal, Utkarsh *EXTERN*'" <utkarsh(dot)porwal(at)emc(dot)com>, Scott Ribe <scott_ribe(at)elevated-dev(dot)com>, pgsql-admin <pgsql-admin(at)postgresql(dot)org> |
| Subject: | Re: Advise on restoring from VM Snapshot backup |
| Date: | 2015-09-08 09:42:08 |
| Message-ID: | A737B7A37273E048B164557ADEF4A58B50FA2170@ntex2010i.host.magwien.gv.at |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Albe Laurenz | 2015-09-08 09:48:29 | Re: PostgresDB - Advise on possible data corruption |
| Previous Message | Porwal, Utkarsh | 2015-09-07 17:36:41 | Re: Advise on restoring from VM Snapshot backup |