Hi,
after updateing to 5.0.3 it checked the state of some accurate backups. I'm not
sure if I fully understand why bacula is backing up some files.
I'm interested in the job VUMEM008-psql-dumps.
Terminated Jobs:
JobId Level Files Bytes Status Finished Name
======================================================================
25963 Incr 3 4.449 G OK 02-Oct-10 05:31 VUMEM008-psql-dumps
25970 Volu 635 0 OK 02-Oct-10 11:00 VerifyVUMEM008
25971 Volu 3 0 OK 02-Oct-10 11:01
VerifyVUMEM008-psql-dumps
26008 Full 104,492 6.834 G OK 04-Oct-10 04:23 VUMEM008
26009 Full 25 26.62 G OK 04-Oct-10 05:37 VUMEM008-psql-dumps
26014 Volu 104,492 0 OK 04-Oct-10 11:33 VerifyVUMEM008
26015 Volu 25 0 OK 04-Oct-10 11:38
VerifyVUMEM008-psql-dumps
26026 Incr 4 22.28 G OK 04-Oct-10 21:38 VUMEM008-psql-dumps
26039 Incr 16,460 8.614 G OK 05-Oct-10 04:15 VUMEM008
There has been a full backup on 2010-10-04 and and incremental later that same
day.
content of the full backup:
*list files jobid=26009
+----------------------------------------------------------------------------------------------------+
| filename
|
+----------------------------------------------------------------------------------------------------+
| /postgres-backups/testdb-20101001.sql.gz
|
| /postgres-backups/WAL/archive_status/
|
| /postgres-backups/WAL/
|
| /postgres-backups/mysql-backups/monthly/
|
|
/postgres-backups/mysql-backups/daily/information_schema/information_schema_2009-01-26_16h34m.Montag.sql.gz
|
| /postgres-backups/mysql-backups/daily/information_schema/
|
|
/postgres-backups/mysql-backups/daily/mantis/mantis_2009-01-26_16h34m.Montag.sql.gz
|
| /postgres-backups/mysql-backups/daily/mantis/
|
|
/postgres-backups/mysql-backups/daily/mysql/mysql_2009-01-26_16h34m.Montag.sql.gz
|
| /postgres-backups/mysql-backups/daily/mysql/
|
| /postgres-backups/mysql-backups/daily/
|
| /postgres-backups/mysql-backups/weekly/information_schema/
|
| /postgres-backups/mysql-backups/weekly/mantis/
|
| /postgres-backups/mysql-backups/weekly/mysql/
|
| /postgres-backups/mysql-backups/weekly/
|
| /postgres-backups/testdb-20100928.sql.gz
|
| /postgres-backups/testdb-20101002.sql.gz
|
| /postgres-backups/testdb-20100930.sql.gz
|
| /postgres-backups/lost+found/
|
| /postgres-backups/testdb-20100929.sql.gz
|
| /postgres-backups/all-20101003.sql.gz
|
| /postgres-backups/xlogs/
|
| /postgres-backups/basebackups/
|
| /postgres-backups/
|
| /postgres-backups/mysql-backups/
|
+----------------------------------------------------------------------------------------------------+
+--------+---------------------+---------------------+------+-------+----------+----------------+-----------+
| jobid | name | starttime | type | level | jobfiles
| jobbytes | jobstatus |
+--------+---------------------+---------------------+------+-------+----------+----------------+-----------+
| 26,009 | VUMEM008-psql-dumps | 2010-10-04 05:30:02 | B | F | 25
| 26,627,699,629 | T |
+--------+---------------------+---------------------+------+-------+----------+----------------+-----------+
content of the incremental job:
*list files jobid=26026
+------------------------------------------+
| filename |
+------------------------------------------+
| /postgres-backups/testdb-20101004.sql.gz |
| /postgres-backups/ |
| /postgres-backups/testdb-20100928.sql.gz |
| /postgres-backups/testdb-20100929.sql.gz |
+------------------------------------------+
+--------+---------------------+---------------------+------+-------+----------+----------------+-----------+
| jobid | name | starttime | type | level | jobfiles
| jobbytes | jobstatus |
+--------+---------------------+---------------------+------+-------+----------+----------------+-----------+
| 26,026 | VUMEM008-psql-dumps | 2010-10-04 21:33:12 | B | I | 4
| 22,283,895,422 | T |
+--------+---------------------+---------------------+------+-------+----------+----------------+-----------+
My question: why did the files testdb-20100928.sql.gz and
testdb-20100929.sql.gz get backed up in the incr. backup? They were already in
the full backup and did not change since then. I use the default Accurate Job
parameters.
Ralf
------------------------------------------------------------------------------
Beautiful is writing same markup. Internet Explorer 9 supports
standards for HTML5, CSS3, SVG 1.1, ECMAScript5, and DOM L2 & L3.
Spend less time writing and rewriting code and more time creating great
experiences on the web. Be a part of the beta today.
http://p.sf.net/sfu/beautyoftheweb
_______________________________________________
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
