"David Ballester" <[EMAIL PROTECTED]> wrote: > > 2007/9/26, Bill Moran <[EMAIL PROTECTED]>: > > > PostgreSQL is extremely particular about SQL encodings, and rejects > > non-valid strings. If you've found a string that bacula tries to > > insert that PG considers invalid, then you've either found a bug in > > PG or in Bacula. (i.e., either bacula is submitting an invalid string, > > or PostgreSQL is rejecting a valid one) > > > > In any event, you _should_ file a bug report. However, you mention > > "old client" in your original post, but make no mention of the particular > > version of Bacula on the director, sd or fd. Is it possible that you're > > using an older version and this has been fixed in newer versions? > > > > -- > > Bill Moran > > http://www.potentialtech.com > > > > May be I've explained it bad. The 'old' client refers to character set > enconding on the system ( today UTF8 is used widely but one host to > protect is an old RHLES 3 32bit - Both director and fd has the same > version ( last release ) I've no access now to this machine and I > can't say what encoding is using the host, but if I'm not wrong, the > problem is that the files created in the client host were saved using > some character set ( seems that this files were uoploaded vía ftp from > windows machines ) not compatible with Postgresql/UTF8 and both > bacula-fd and director handles them well, but trying to insert data in > the database makes postgresql to reject it, bacula sees some error > returned by the database transaction and aborts the backup procedure.
I'm not character encoding expert, but my understanding is that UTF8 encompasses all other encodings. I don't think there's any character set out there that should produce strings that aren't valid UTF8. I've been curious as to how Bacula handles this, and it seems as if it does no validation whatsoever, with the result that PG catches the problem. It would seem to me that a reasonable result from Bacula would be to log an error and skip the file, but continue with the backup. -- Bill Moran http://www.potentialtech.com ------------------------------------------------------------------------- This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2005. http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/ _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
