In response to "Ralf Gross" <[EMAIL PROTECTED]>: > Hi, > > 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. The drop/create/restore process is probably more along the lines of what you wanted to accomplish. -- Bill Moran Collaborative Fusion Inc. ------------------------------------------------------------------------- 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
