Sorry, when the previous poster mentioned 'snapshot', I was thinking of SQL Server's 'dump', which is transactionally consistent, because it's done by the SQL engine. I thought Oracle had a similar method for producing a usable backup of the SQL server?
> -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] > Sent: Friday, June 14, 2002 2:53 PM > To: Bort, Paul > Cc: [EMAIL PROTECTED] > Subject: RE: Backing up PostgreSQL? > > > [ 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]> >
