Re: [Bacula-users] n00b question, full backup yields incomplete catalog?
2008-09-09 15:07:42
John Drescher wrote:
On Tue, Sep 9, 2008 at 2:44 PM, Alan Garrison <alang AT cronosys DOT com> wrote:
Skimming a pg_dump of the bacula
database shows nowhere near 162,000 file records. The job completion
email does indicate the proper number of files processed, just not the
Catalog.
I assume that a lot of these files have the same name (not including
the path)? bacula will only save a filename once in the file table of
the catalog
I do understand how the database is normalized, just for a job with
well over 100,000 files the "path" table has less than 5,000 records,
and the "file" table only has ~12,000 records. Searching the output of
a pg_dump shows lots of strings of unique-ish path names from the
backed up directory (and Volume) that are simply not in the PostgreSQL
database.
|
-------------------------------------------------------------------------
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/ _______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users
|
|
|