"Tom Lane" <tgl@xxxxxxxxxxxxx> writes: > AFAIK, actually workable methods of this type depend on filesystem > cooperation, and are able to produce coherent snapshots of the logical > (not necessarily physical) filesystem content at a specific instant. I think you need filesystem cooperation in order to provide access to the snapshot somewhere. But the actual snapshotting is done at a very low level by intercepting any block writes and stashing away the old version before writing or alternately by noting the new version and redirecting any reads to the new version. I concur that anything that doesn't allow concurrent i/o while the snapshotting is happening is worthless. It sounds like you're just dd'ing from the device which is pretty much guaranteed not to work. Even if Postgres didn't do any i/o there's nothing stopping the OS and filesystem from issuing i/o. -- Gregory Stark EnterpriseDB http://www.enterprisedb.com
