Vladimir Vassiliev a écrit :
> On Четверг 05 февраля 2009, you wrote:
>>>>>>> On Thu, 5 Feb 2009 12:21:31 +0300, Vladimir Vassiliev said:
>>> I did a couple of tests with empty files: in job with 1,001,002 files it's
>>> possible to select them but with 1,202,203 - is not.
>> Possibly the transaction and/or temporary tables used to insert the records 
>> is
>> too large?  I suggest checking your database logs.
> 
> Thanks for suggestion.
> I use Postgresql and have 
> 
> 2009-02-05 14:29:57 MSK 18899  LOG:  checkpoints are occurring too frequently 
> (3 seconds apart)
> 2009-02-05 14:29:57 MSK 18899  HINT:  Consider increasing the configuration 
> parameter "checkpoint_segments".
> 
> in log. 
> I'm not very experienced in Postgresql. Could this be the cause of the issue?
>  

Hello,

Is your PostgreSQL database encoding is SQL_ASCII ? Do you see error in
postgres log like that :
ERROR:  invalid byte sequence for encoding "UTF8":

If so, look at there :
http://article.gmane.org/gmane.comp.sysutils.backup.bacula.devel/12074/

I think it was my problem. I've just switch my database to SQL_ASCII and
I'm waiting for the next full backup to occur to see if it works.

Regards.
-- 
Jérôme Schell
CPE Lyon

------------------------------------------------------------------------------
Create and Deploy Rich Internet Apps outside the browser with Adobe(R)AIR(TM)
software. With Adobe AIR, Ajax developers can use existing skills and code to
build responsive, highly engaging applications that combine the power of local
resources and data with the reach of the web. Download the Adobe AIR SDK and
Ajax docs to start building applications today-http://p.sf.net/sfu/adobe-com
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users