On 12/31/13 02:29, Ken Barclay wrote: > Thanks to both Ryan and Phil for your prompt replies. > > Yes, the catalog gets backed up every night at the end of the nightly > backups. > Yes, I have the bootstrap file. > Yes, the media is intact. > No, the database wasn't on the storage array. It was on the Bacula server > itself. db size = 4.13 GB. > > This is what tells me that the db has gone: > [root@SVR03 data]# su - postgres > -bash-3.1$ > -bash-3.1$ psql -l > List of databases > Name | Owner | Encoding > -----------+----------+---------- > postgres | postgres | UTF8 > template0 | postgres | UTF8 > template1 | postgres | UTF8 > (3 rows) > -bash-3.1$ exit > > Correct me if I'm wrong, but it looks like my next step should be to create > a new database. Then bscan the tape back into the database. > I've used bscan before, but never restored from a bootstrap file.
That sounds like probably a good procedure, yes. I'd try to figure out what happened to the DB first, but if there's just no trace of it, create a new database, bscan the last night's tape, use that metadata to restore last night's catalog dump, then go from there. -- Phil Stracchino Babylon Communications ph...@caerllewys.net p...@co.ordinate.org Landline: 603.293.8485 ------------------------------------------------------------------------------ Rapidly troubleshoot problems before they affect your business. Most IT organizations don't have a clear picture of how application performance affects their revenue. With AppDynamics, you get 100% visibility into your Java,.NET, & PHP application. Start your 15-day FREE TRIAL of AppDynamics Pro! http://pubads.g.doubleclick.net/gampad/clk?id=84349831&iu=/4140/ostg.clktrk _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
