Thanks very much for your response, Eric. On 30/07/10, Eric Bollengier (eric.bolleng...@baculasystems.com) wrote: > It depends on how many files you backup, but a Bacula catalog requires some > space, specially if you handle many files. I think you need help to configure > your PostgreSQL catalog. 3.4GB free is not enough in any cases.
Do mean this is not enough space for postgres in the long run? I understand that. > > Clearly there is a problem with the size of the temporary file used > > during the batch copy update. Since there are successful inserts into > > the log table milliseconds later this clearly points to a problem in the > > way Bacula inserts data in batch mode. Is it not possible to change this > > arrangement to use sequential inserts instead? > > You can try --disable-batch-insert, insertion process will take several hours > or days instead of minutes, but if you don't have disk space... > > I'm also keen to know if I can append to this large job to try and > > retrieve the set of data, or do I have to start again? > > You can also try to change the source code by uncommenting the "db changes" > check line in src/cats/sql_create.c db_create_file_attributes_record(). > > It allows to commit batch session every X records. It should work, and can > help in your situation but this code is untested, so I advise you to do some > restore tests. Feedback will be appreciated. Thanks for the suggestion. I'm going to first try Dan Langille's suggestion of setting "Spool Attributes" to "no". -- 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