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 (r...@campbell-lange.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 r...@campbell-lange.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@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
