>>>>> On Sat, 14 Aug 2010 11:51:31 +0100, Rory Campbell-Lange said: > > On 13/08/10, Rory Campbell-Lange (r...@campbell-lange.net) wrote: > > I'd like to write catalog information to CD/DVD to accompany my tape > > sets, which will be between 1 and 15 LT04 tapes. I'm using Postgres > > for the Catalog. The idea is to make it easy for people to restore from > > these tapes 10 years from now. > > I'm trying to dump a manifest of files in the fileset from Postgres to > help achieve my aims above. > > I'm trying to work out which tape each file is on, by joining JobMedia > to File. However neither JobMedia.FirstIndex nor JobMedia.StartFile > appear to point to File.FileID. > > Can someone point me to the relationship between Media and File?
Compare File.FileIndex to JobMedia.FirstIndex and JobMedia.LastIndex. The JobMedia.StartFile and JobMedia.EndFile columns record the "tape file", i.e. EOF marks on the tape that are used for fast seeking. __Martin ------------------------------------------------------------------------------ This SF.net email is sponsored by Make an app they can't live without Enter the BlackBerry Developer Challenge http://p.sf.net/sfu/RIM-dev2dev _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
