On 07/02/2010 04:52 PM, Martin Simmons wrote:
> It would be interesting to check the MD5 column in the output of the SQL query
>
> SELECT Path.Path,Filename.Name,File.MD5 FROM File,Filename,Path WHERE 
> File.JobId=NNNN
>   AND Filename.FilenameId=File.FilenameId
>   AND Path.PathId=File.PathId ORDER BY
>   Path.Path,Filename.Name;
>
> when NNNN is the jobid of the Full backup (the column is called MD5, but it
> can also contain the SHA1 value).

                 path                 |      name       |             md5 

-------------------------------------+-----------------+-----------------------------
  /usr/share/postgresql-8.4/man/man7/ |                 | 0
  /usr/share/postgresql-8.4/man/man7/ | I_AM_FAKE_AHK   | 
9pJlAWgNbz4aM4vmduNmJkByLMU
  /usr/share/postgresql-8.4/man/man7/ | I_AM_FAKE_AHK_2 | 
9pJlAWgNbz4aM4vmduNmJkByLMU
  /usr/share/postgresql-8.4/man/man7/ | I_AM_FAKE_AHK_3 | 
9pJlAWgNbz4aM4vmduNmJkByLMU
  /usr/share/postgresql-8.4/man/man7/ | table.7.bz2     | 
EeaI7PgQNG2luduNX/wueQLoD7o
(5 rows)

Here, the mysterious table.7.bz2 file does indeed have a checksum value.

Best,
   Andreas

------------------------------------------------------------------------------
This SF.net email is sponsored by Sprint
What will you do first with EVO, the first 4G phone?
Visit sprint.com/first -- http://p.sf.net/sfu/sprint-com-first
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users