Bacula-users

Re: [Bacula-users] howto to recover postgres catalog after delete from file

2011-05-20 03:52:24
Subject: Re: [Bacula-users] howto to recover postgres catalog after delete from file
From: Thomas Stegbauer <mailingliste1 AT stegbauer DOT info>
To: bacula-users AT lists.sourceforge DOT net
Date: Fri, 20 May 2011 09:48:47 +0200 (CEST)





Von: "Rodrigo Renie Braga" <rodrigorenie AT gmail DOT com>
An: "Thomas Stegbauer" <mailingliste1 AT stegbauer DOT info>
CC: bacula-users AT lists.sourceforge DOT net
Gesendet: Freitag, 20. Mai 2011 04:25:31
Betreff: Re: [Bacula-users] howto to recover postgres catalog after delete from file


it is not so important if i cant restore a single file from an old backup,
but i want to make a new full-backup, with correct catalog update.
i do not understand where the batch relation come from and why there is an
sql-Error when the file, filename and path table are empty?

Well, from what you said in this part alone, seems like you don't care about any of your previous backups, right? So why don't you just drop your entire database and start a clean Bacula install all over again?

I believe that the trouble you'll get from a fresh install is much simpler (and faster) than solving this database problem you're having...


hi rodrigo,

i already thought about this, but i dont want to relable the 38 tapes.
cause this mean:
stopping bacula-sd, deleting tape by dd, start bacula-sd, label, exchange tape and so on.

so i thought already about exporting
media, media_mediaid_seq, mediatype, mediatype_mediatypeid_seq, pool, pool_poolid_seq

and afterwards purging the volumes in the new database?

or are there other thoughts or traps?

best regards
thomas


------------------------------------------------------------------------------
What Every C/C++ and Fortran developer Should Know!
Read this article and learn how Intel has extended the reach of its 
next-generation tools to help Windows* and Linux* C/C++ and Fortran 
developers boost performance applications - including clusters. 
http://p.sf.net/sfu/intel-dev2devmay
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users