"Matt Clark" <matt(at)ymogen(dot)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