Torsdag 01 marts 2007 21:07 skrev Arno Lehmann: > Hi, > > On 3/1/2007 9:00 PM, Darien Hager wrote: > > On Mar 1, 2007, at 6:50 AM, Ryan Novosielski wrote: > >>>On Thursday 01 March 2007 10:32:49 Kern Sibbald wrote: > >>> > >>>this item does indeed work very stable. I've been using this in > >>>production for > >>>exporting large Oracle databases (100+ GBytes each) once per week > >>>for about > >>>two years. I've never encountered stability issue with the FIFOS. :-) > >> > >>I would love, if you have the time, to write a brief mention about how > >>this is done. Perhaps it could be posted somewhere (if it isn't > >>already)? > > > > My experience with FIFO database dumps: > > > > > > Basics: > > ... > > > So if anyone's interested, I have a python script which will actually > > do non-blocking IO (gasp, shock) over the FIFOs, waiting until any > > one of them can accept data and only *then* launching connecting to > > the database to fill the FIFO. It will also do the converse for > > restoring data back to the databases, noticing newly created FIFOs > > (created by a Bacula restore job) in the directory and trying to grab > > data from them. > > Currently, I'm not interested but this sounds like areally great > enhancement! > > You wrote that for PostgreSQL, but I suppose adapting it to other > databases or whatever would not be too much of a problem, so I suggest > you post it to the wiki at http://paramount.ind.wpi.edu/wiki/doku.php or > mail to the list. I'm sure that script will be helpful to many users, > and I suppose it could be added to the user-contributed examples in the > source code. > > > Note that this is definite overkill if you're okay > > with doing one dump per server of all active databases. > > Depends on the available dump space vs. database size... I am reading this thread with interest and trying to understand. I thought that the databases would dump 'through' the FIFO directly to Bacula - thus eliminating the need for dump space - am I wrong here?
Steen > > Arno > > > -- > > --Darien A. Hager > > [EMAIL PROTECTED] > > > > > > > > ------------------------------------------------------------------------- > > Take Surveys. Earn Cash. Influence the Future of IT > > Join SourceForge.net's Techsay panel and you'll get the chance to share > > your opinions on IT & business topics through brief surveys-and earn cash > > http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV > > _______________________________________________ > > Bacula-users mailing list > > Bacula-users@lists.sourceforge.net > > https://lists.sourceforge.net/lists/listinfo/bacula-users -- Regards Steen ------------------------------------------------------------------------- Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay panel and you'll get the chance to share your opinions on IT & business topics through brief surveys-and earn cash http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
