On 20 Jul 2006 at 10:07, John Drescher wrote: > 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.
Do you have the same problem with bconsole? > # 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. I didn't spend much time analyzing the above. I wanted to know about bconsole first. -- Dan Langille : Software Developer looking for work my resume: http://www.freebsddiary.org/dan_langille.php ------------------------------------------------------------------------- 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
