[prev in list] [next in list] [prev in thread] [next in thread] 

List:       bacula-users
Subject:    Re: [Bacula-users] Bacula + Postgres : copy batch problem
From:       Rory Campbell-Lange <rory () campbell-lange ! net>
Date:       2010-07-30 14:46:44
Message-ID: 20100730144644.GB16112 () campbell-lange ! net
[Download RAW message or body]

Thanks very much for your response, Eric.

On 30/07/10, Eric Bollengier (eric.bollengier@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
rory@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
[prev in list] [next in list] [prev in thread] [next in thread]