[Bacula-users] [RESOLVED] FATAL: database "bacula" does not exist

2013-12-31 Thread Ken Barclay
Dear All who responded, The problem has now been resolved. Bootstrap file and then import db worked well. (Now to start restoring some dead server partitions). Awesome Mailing List! HAPPY NEW YEAR TO ALL! (Now I can go home and enjoy the rest of the holiday :) ). @Kern, appreciate your comme

Re: [Bacula-users] FATAL: database "bacula" does not exist

2013-12-31 Thread Phil Stracchino
On 12/31/13 11:48, Alan Brown wrote: > On 31/12/13 15:37, Phil Stracchino wrote: >> >> 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 metada

Re: [Bacula-users] FATAL: database "bacula" does not exist

2013-12-31 Thread Phil Stracchino
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

Re: [Bacula-users] FATAL: database "bacula" does not exist

2013-12-31 Thread Kern Sibbald
Hello, For me the next step would be to find out why the postgres database is gone. Perhaps you did a Postgres upgrade or reinstall? Normally for an upgrade, Postgres will keep the old database and put the new one under a directory which is the Postgres version, thus you may have several Postgres