A few weeks after moving my bacula database from a postgresql 7 server
to a new postgresql 8 server by using pg_dump, I am having problems
with selecting files for restores although my database looks mostly
ok. I did have a problem in which all clients were listed twice in the
client table and bacula really did not like this so I deleted the
duplicate rows (using knoda) but I see this was somehow messed up as
only a few of my clients are listed now not all ~17.
The problem is that in a gnome-console or wx-console when I ask for
all the backups for a client for a single job it returns either
Improper date format because there is no date to select or "No Full
backup before 2006-07-20 09:33:33 found." But I do have several full
backups for that client, job and pool.
# select jobid,job,poolid,clientid,level,jobstatus from job where
name='CleanImages';
jobid | job | poolid | clientid | level | jobstatus
-------+---------------------------------+--------+----------+-------+-----------
1179 | CleanImages.2006-03-01_14.39.49 | | | F | C
1185 | CleanImages.2006-03-01_14.59.13 | 2 | 3 | F | T
1360 | CleanImages.2006-04-25_14.58.13 | 12 | 3 | F | f
1361 | CleanImages.2006-04-25_15.04.31 | 12 | | F | T
1470 | CleanImages.2006-05-25_17.42.36 | 12 | | F | T
1578 | CleanImages.2006-06-23_14.03.19 | 12 | | F | T
(6 rows)
Could it be that the clientid is not filled in??
Or could it be the problem with the client table?
# select * from client;
clientid | name | uname |
autoprune | fileretention | jobretention
----------+---------------+-----------------------------------+-----------+---------------+--------------
21 | dev2-fd | Windows XP,MVS,NT 5.1.2600 |
0 | 5184000 | 15552000
19 | datastore0-fd | x86_64-pc-linux-gnu,gentoo,1.6.14 |
0 | 5184000 | 15552000
20 | dev4-fd | x86_64-pc-linux-gnu,gentoo,1.6.13 |
0 | 5184000 | 15552000
18 | fileserver-fd | x86_64-pc-linux-gnu,gentoo,1.6.14 |
0 | 5184000 | 15552000
(4 rows)
The correct client for all the CleanImages jobs was fileserver-fd.
I believe I have to restore/fix the client table to fix this problem.
Is this true?? I still have access to the old server.
BTW, I am running the bacula-1.38.11 on an amd64 gentoo box.
fileserver is the bacula director and the database is on a different
amd64 gentoo box if that makes a difference.
-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys -- and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
_______________________________________________
Bacula-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/bacula-users
