Anyone whose ever had to rebuild a server just fromtapes might agree

[Taavi Burns]

On Thu, Jan 08, 2004 at 06:14:59PM -0500, CLIFFORD ILKAY wrote:
> >With IBM's DB2 UDB database, there is an improvement
> >to be made to this process.  It has a command to
> >suspend write IO (which also updates the log before
> >stopping writes).  Then you can split off a copy,
> >and resume writes.  The copy can then be restarted (no

Or you could do an online backup.  It takes longer to restore
(since you still have to rollforward through the logs
generated during the online backup), but it doesn't require
you to suspend writes at all.

> PostgreSQL but then you would not have to do that anyway with pg_dump since 
> pg_dump will make consistent backups of live data.

Is PostgreSQL with pg_dump ACID?  (I honestly don't know)

-- 
Taavi Burns
Member of Kokopelli
 -- kokopellichoir.com --
/*eof*/
--
The Toronto Linux Users Group.      Meetings: http://tlug.ss.org
TLUG requests: Linux topics, No HTML, wrap text below 80 columns
How to UNSUBSCRIBE: http://tlug.ss.org/subscribe.shtml