>>>>> On Fri, 20 May 2011 13:57:45 +0200 (CEST), Thomas Stegbauer said:
> - Ursprüngliche Mail -
> Von: "Martin Simmons"
> An: bacula-users@lists.sourceforge.net
> Gesendet: Freitag, 20. Mai 2011 12:06:59
> Betreff: Re: [Bacula-users] howto
- Ursprüngliche Mail -
Von: "Thomas Stegbauer"
An: bacula-users@lists.sourceforge.net
Gesendet: Freitag, 20. Mai 2011 13:57:45
Betreff: Re: [Bacula-users] howto to recover postgres catalog after delete from
file
- Ursprüngliche Mail -
Von: "Marti
- Ursprüngliche Mail -
Von: "Martin Simmons"
An: bacula-users@lists.sourceforge.net
Gesendet: Freitag, 20. Mai 2011 12:06:59
Betreff: Re: [Bacula-users] howto to recover postgres catalog after delete from
file
>>>>> On Thu, 19 May 2011 18:54:58 +0200
> On Thu, 19 May 2011 18:54:58 +0200 (CEST), Thomas Stegbauer said:
>
> but after the backup job i get:
> 9-Mai 05:23 pa-server-dir JobId 2268: Fatal error: sql_create.c:894 Fill File
> table Query failed: INSERT INTO File (FileIndex, JobId, PathId, FilenameId,
> LStat, MD5)SELECT batch.Fil
- Ursprüngliche Mail -
Von: "Rodrigo Renie Braga"
An: "Thomas Stegbauer"
CC: bacula-users@lists.sourceforge.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
> 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 w
- Ursprüngliche Mail -
Von: "Phil Stracchino"
An: bacula-users@lists.sourceforge.net
Gesendet: Donnerstag, 19. Mai 2011 22:06:43
Betreff: Re: [Bacula-users] howto to recover postgres catalog after delete from
file
On 05/19/11 12:54, Thomas Stegbauer wrote:
> hi all,
>
On 05/19/11 12:54, Thomas Stegbauer wrote:
> hi all,
>
> i am running bacula 5.0.1 with postgresql catalog on Ubuntu.
> As there was an error in the file relation. it was an blockerror.
> i was unable to do a select on the file table, nor a pg_dump of the
> catalog.
>
> so i deleted everything fr
hi all,
i am running bacula 5.0.1 with postgresql catalog on Ubuntu.
As there was an error in the file relation. it was an blockerror.
i was unable to do a select on the file table, nor a pg_dump of the catalog.
so i deleted everything from
file
filepath
path - table, but left the table th
