[ On Friday, June 14, 2002 at 12:20:21 (-0400), Bort, Paul wrote: ] > Subject: RE: Backing up PostgreSQL? > > I don't know much about PostgresQL, but on MS SQL server and Oracle (IIRC), > any update that would leave the database inconsistent should be inside a > transaction. Any snapshot will not happen while a transaction is in > progress; therefore the snapshot is consistent and restorable. I guess it > depends on how sane your programmers are.
Oracle, running on any snapshot-capable unix (including FreeBSD) and using a normal filesystem for storage, will not -- cannot possibly -- guarantee that a snapshot will not happen while a transaction is in progress. There is no possible interlock in any snapshot implementations I'm aware of between the kernel (which does the snapshot operation) and the user-land Oracle process(es). -- Greg A. Woods +1 416 218-0098; <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Planix, Inc. <[EMAIL PROTECTED]>; VE3TCP; Secrets of the Weird <[EMAIL PROTECTED]>