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... 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 > [email protected] > https://lists.sourceforge.net/lists/listinfo/bacula-users -- IT-Service Lehmann [EMAIL PROTECTED] Arno Lehmann http://www.its-lehmann.de ------------------------------------------------------------------------- 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 [email protected] https://lists.sourceforge.net/lists/listinfo/bacula-users
