Re: [Bacula-users] SQL problem [was: Re: Catalog to accompany job tape sets]

2010-08-20 Thread Rory Campbell-Lange
On 20/08/10, Martin Simmons (mar...@lispworks.com) wrote: > > On Wed, 18 Aug 2010 23:15:59 +0100, Rory Campbell-Lange said: > > > > Can someone point me to the relationship between Media and File? ... > > This shows that each backup starts from 1 (0 for one of them?!), so there > > is no > > d

Re: [Bacula-users] SQL problem [was: Re: Catalog to accompany job tape sets]

2010-08-20 Thread Martin Simmons
> On Wed, 18 Aug 2010 23:15:59 +0100, Rory Campbell-Lange said: > > > > 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

Re: [Bacula-users] SQL problem [was: Re: Catalog to accompany job tape sets]

2010-08-18 Thread Rory Campbell-Lange
> > 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. bacula=#

Re: [Bacula-users] SQL problem [was: Re: Catalog to accompany job tape sets]

2010-08-16 Thread Martin Simmons
> 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 Cat

[Bacula-users] SQL problem [was: Re: Catalog to accompany job tape sets]

2010-08-14 Thread Rory Campbell-Lange
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 y