Bill Moran said: > In response to "Ralf Gross" <[EMAIL PROTECTED]>: > >> the / disk of my bacula (1.38.5) server crashed Friday night. The >> postgres >> db is on a separate disk. I restored the filesystem from a second backup >> system. Since I only perform full backups on weekend the db should have >> been in a consistent state. But to get some experience with desaster >> recovery, I restored the postgres db from my bacula.sql dump file from >> last weeks backup (cat bacula.sql | psql bacula) and ran dbcheck with >> the >> fix option. > > The command you show above will append the data in the bacula.sql file to > the existing database (unless that file explicitly contains commands to > delete data from the tables before recreating it). I doubt that's what > you wanted to do and it's likely the cause of your errors.
Does this part of the manual makes sense at all? http://www.bacula.org/rel-manual/Catalog_Maintenance.html#SECTION000237000000000000000 Compacting Your PostgreSQL Database [snip] pg_dump bacula > bacula.sql cat bacula.sql | psql bacula rm -f bacula.sql > The drop/create/restore process is probably more along the lines of > what you wanted to accomplish. I agree with you, after the currently running backup has finished, I will dump the db and try dbcheck again. Ralf ------------------------------------------------------------------------- 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 Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
