Re: [Bacula-users] Advice upgrading bacula 5.0 -> 5.2

Hello,

2014-02-24 13:16 GMT+01:00 Márcio Merlone <marcio.merlone AT a1.ind DOT br>:

Em 24-02-2014 07:29, Radosław Korzeniewski escreveu:

2014-02-18 13:00 GMT+01:00 Márcio Merlone <marcio.merlone AT a1.ind DOT br>:

2. Fix some utf-8 invalid chars: iconv -c -f UTF-8 -t UTF-8 -o /tmp/bacula_new.sql /tmp/bacula.sql

Why do you need this?

Bacula (AFAIK) does not use UTF-8 as a database character coding.

Indeed, but my filesystem is. When restoring catalog dump on the new server I got these two messages:

???

I do not understand. Your file name is /tmp/bacula.sql, it does not have UTF8 characters in its name.

psql:/tmp/bacula.sql:67185854: ERROR: invalid byte sequence for encoding "UTF8": 0xa2
CONTEXT: COPY filename, line 2881
psql:/tmp/bacula.sql:69079011: ERROR: invalid byte sequence for encoding "UTF8": 0x87
CONTEXT: COPY path, line 4771

I think your Bacula database has wrong charset encoding. It should be SQL_ASCII not UTF-8, so PostgreSQL should take any 8bit character as an input.

After iconv I was able to restore without warnings.

But you have a corrupted filename table - means you could not restore some files with proper filename. IMO, YMMV.

best regards

--
Radosław Korzeniewski
radoslaw AT korzeniewski DOT net

------------------------------------------------------------------------------
Flow-based real-time traffic analytics software. Cisco certified tool.
Monitor traffic, SLAs, QoS, Medianet, WAAS etc. with NetFlow Analyzer
Customize your own dashboards, set traffic alerts and generate reports.
Network behavioral analysis & security monitoring. All-in-one tool.
http://pubads.g.doubleclick.net/gampad/clk?id=126839071&iu=/4140/ostg.clktrk

_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users