Re: LVM snapshots

"Matt Clark" <matt@ymogen.net> writes:
> Has anyone tried taking an LVM snapshot of a running DB?  And then reverting
> to the snapshot?  I presume one would need to take a low level backup (i.e.
> using dd, not tar or cp) of the snapshot to preserve the precise FS layout,
> but are there any other issues?

This was discussed only a couple weeks ago (in the context of a similar
facility in NetApp servers, but I believe LVM was mentioned).  See the
archives.

            regards, tom lane