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