Re: LVM snapshots - Mailing list pgsql-admin

From Matt
Subject Re: LVM snapshots
Date
Msg-id 3E8DCE84.2060909@ymogen.net
Whole thread Raw
In response to Re: LVM snapshots  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: LVM snapshots  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-admin
Tom Lane wrote:

 > A lot of detailed and informative stuff essentially equating a
snapshot backup with a system crash

And I have to agree with what Tom said.  An FS snapshot should indeed
look just like an instantaneous halt in processing.  Murthy's testing
does involve a pretty heavy load, and it is in a sense reassuring that
it manages to generate the same kind of issues, and that PostgreSQL's
ability to recover from such crashes is so good.

Maybe one could use FS snapshots as a way to test crash recovery without
needing to crash the system!

Anyway, I was about to respond to Tom's comment that it looked like a
snapshotting bug, but can we take it from yr subsequent post Tom that
you no longer think so?


pgsql-admin by date:

Previous
From: Robert Treat
Date:
Subject: Re: restore a dump file (with postgis tables): errors!!
Next
From: Tom Lane
Date:
Subject: Re: LVM snapshots