Ok, The solution was simple. Stop bacula. Bring up the old db and use pg_dump to export only the client table (pg_dump -t client), then in pqsl (on the new server) paste the INSERT INTO lines from pg_dump. Then delete the new duplicate ids and then restart bacula and all is well.
John On 7/20/06, John Drescher <[EMAIL PROTECTED]> wrote: > ---------- Forwarded message ---------- > From: John Drescher <[EMAIL PROTECTED]> > Date: Jul 20, 2006 10:31 AM > Subject: Re: [Bacula-users] Restore says no full backup > To: Dan Langille <[EMAIL PROTECTED]> > > > Yes, In this case I have to do a manual restore because most of the > menu options for restore will not work well for my situation. > > # bconsole > Connecting to Director fileserver:9101 > 1000 OK: fileserver-dir Version: 1.38.11 (28 June 2006) > Enter a period to cancel a command. > *restore client="fileserver-fd" fileset="CleanPendingImages" > storage="DLT-IV" select > Using default Catalog name=HBCatalog DB=bacula > No Full backup before 2006-07-20 10:29:41 found. > * > > On 7/20/06, Dan Langille <[EMAIL PROTECTED]> wrote: > > 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
