Hello,
2014-02-24 13:16 GMT+01:00 Márcio Merlone <marcio.merl...@a1.ind.br>:
>
> Em 24-02-2014 07:29, Radosław Korzeniewski escreveu:
>
> 2014-02-18 13:00 GMT+01:00 Márcio Merlone <marcio.merl...@a1.ind.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
rados...@korzeniewski.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@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
