Обсуждение: Re: Advise on restoring from VM Snapshot backup

Sure.

Any advise or experience with restoring the db server using VM snapshots with a caveat that snapshots have been taken
withDB running and nt stopped. 


Thanks and Regards,
Utkarsh Porwal


-----Original Message-----
From: Scott Ribe [mailto:scott_ribe@elevated-dev.com]
Sent: Monday, September 07, 2015 10:30 PM
To: Porwal, Utkarsh; pgsql-admin
Subject: Re: [ADMIN] Advise on restoring from FileSystem backup

On Sep 7, 2015, at 10:55 AM, Porwal, Utkarsh <utkarsh.porwal@emc.com> wrote:
>
> But the filesystem backup should work, isn't it?

Yes, if:

- You've actually stopped the db when you think you have.
- You've actually correctly copied the data directory.
- Nothing mysterious was modifying the data while you were copying it.

--
Scott Ribe
scott_ribe@elevated-dev.com
http://www.elevated-dev.com/
https://www.linkedin.com/in/scottribe/
(303) 722-0567 voice

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