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@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users