>>>>> On Sat, 14 Aug 2010 11:51:31 +0100, Rory Campbell-Lange said:
> 
> On 13/08/10, Rory Campbell-Lange (rory AT campbell-lange DOT 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 AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users