I'm fairly desperate for some advice on this issue.

I have 3.4GB free in /var where Postgresql is located. At the end of a
large backup job (7,643,966 files taking up 7.265TB of space) Postgres
bails out copying a batch file into the File table due to a mysterious
"no space left on device" error.

Questions:
1. How should I size my postgresql partition?
2. Can I stop this needless after-backup insertion? I tried setting
   Spool Attributes to NO but it did not work
3. Why is Bacula using a batch file at all? Why not simply do a straight
   insert?

I'm keen to get this 7TB backup out, but I have to reconfigure Bacula to
suit. Help much appreciated!

Rory


On 02/08/10, Rory Campbell-Lange (rory AT campbell-lange DOT net) wrote:
> I turned off spooling and set the Spool Attributes directive to no and
> reran the backup. The backup job completes but the database insert bails
> out.
> 
> clwbackup-dir JobId 8: Fatal error: sql_create.c:894 Fill File table
> Query failed: INSERT INTO File (FileIndex, JobId, PathId, FilenameId,
> LStat, MD5)SELECT batch.FileIndex, bat ch.JobId, Path.PathId,
> Filename.FilenameId,batch.LStat, batch.MD5 FROM batch JOIN Path ON (batc
> h.Path = Path.Path) JOIN Filename ON (batch.Name = Filename.Name):
> ERR=ERROR:  could not write to hash-join temporary file: No space left
> on device
> 
> I don't understand why bacula isn't writing to the database
> continuously. Why is a batch file needed?


-- 
Rory Campbell-Lange
rory AT campbell-lange DOT net

------------------------------------------------------------------------------
The Palm PDK Hot Apps Program offers developers who use the
Plug-In Development Kit to bring their C/C++ apps to Palm for a share
of $1 Million in cash or HP Products. Visit us here for more details:
http://p.sf.net/sfu/dev2dev-palm
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users