Re: [Bacula-users] How to list file sizes in terminated jobs

2009-03-27 Thread Craig Ringer
> It'd be really nice if Bacula could store this information in a more > query-friendly way. Oh, as a follow-up to my prior post: For what it's worth, in PostgreSQL the amount of storage required to store the lstat information as individual int4 fields is almost exactly the same as what's needed

Re: [Bacula-users] How to list file sizes in terminated jobs

2009-03-27 Thread Craig Ringer
> It'd be really nice if Bacula could store this information in a more > query-friendly way. Just for kicks, I've written an extension to PostgreSQL that lets you decode the lstat field into a proper `stat' structure you can query, build indexes on, etc. It's basically just a PostgreSQL function

Re: [Bacula-users] How to list file sizes in terminated jobs

2009-03-27 Thread Craig Ringer
Foo wrote: > Hi, > > I'm looking to mod query option 12 to list not just path/filename but size > too, possibly other attributes like permissions, datestamps etc. > > Is this info kept in the catalog somewhere or does Bacula parse volume > files for this? If the latter, has anyone done any sc

Re: [Bacula-users] How to list file sizes in terminated jobs

2009-03-26 Thread John Drescher
On Thu, Mar 26, 2009 at 12:40 PM, Foo wrote: > Hi, > > I'm looking to mod query option 12 to list not just path/filename but size > too, possibly other attributes like permissions, datestamps etc. > > Is this info kept in the catalog somewhere or does Bacula parse volume > files for this? If the l

[Bacula-users] How to list file sizes in terminated jobs

2009-03-26 Thread Foo
Hi, I'm looking to mod query option 12 to list not just path/filename but size too, possibly other attributes like permissions, datestamps etc. Is this info kept in the catalog somewhere or does Bacula parse volume files for this? If the latter, has anyone done any scripting to parse it out