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 with DB running and nt stopped.

Thanks and Regards,
Utkarsh Porwal

-----Original Message-----
From: Scott Ribe [mailto:scott_ribe(at)elevated-dev(dot)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(dot)porwal(at)emc(dot)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(at)elevated-dev(dot)com
http://www.elevated-dev.com/
https://www.linkedin.com/in/scottribe/
(303) 722-0567 voice