Re: [Bacula-users] Postgresql encoding problem after migration to Bacula 2.0.3

2008-01-05 Thread Stephen Winnall
As a footnote: I have fixed the problem by converting all the non-UTF8 filenames to UTF8. I discovered a neat little Linux program called "convmv" which does this automatically. Steve On 5 Jan 2008, at 21:29, Dan Langille wrote: > Stephen Winnall wrote: >> On 5 Jan 2008, at 16:03, Dan Langil

Re: [Bacula-users] Postgresql encoding problem after migration to Bacula 2.0.3

2008-01-05 Thread Dan Langille
Stephen Winnall wrote: > On 5 Jan 2008, at 16:03, Dan Langille wrote: >> I have confirmed a bug: the job silently fails without reporting the >> following error, which is logged in /var/log/messages: >> >> ERROR: invalid byte sequence for encoding "UTF8": 0x9f >> HINT: This error can also happe

Re: [Bacula-users] Postgresql encoding problem after migration to Bacula 2.0.3

2008-01-05 Thread Stephen Winnall
On 5 Jan 2008, at 16:03, Dan Langille wrote: > > I have confirmed a bug: the job silently fails without reporting the > following error, which is logged in /var/log/messages: > > ERROR: invalid byte sequence for encoding "UTF8": 0x9f > HINT: This error can also happen if the byte sequence does

Re: [Bacula-users] Postgresql encoding problem after migration to Bacula 2.0.3

2008-01-05 Thread Dan Langille
Stephen Winnall wrote: > On 5 Jan 2008, at 04:39, Dan Langille wrote: > >> Dan Langille wrote: >>> Stephen Winnall wrote: I have been using Bacula for over two years quite happily on an old Red Hat 9 server. The last version of Bacula that I used was a hand- compiled 2.0.0 wit

Re: [Bacula-users] Postgresql encoding problem after migration to Bacula 2.0.3

2008-01-05 Thread Stephen Winnall
Hi Dan Files created with the following Perl script reproduce the problem for me. I think it may give a more accurate test basis than the TGZ file I sent: #! /usr/bin/perl -w touch( "2004-04-29\ Z\237rich\ 0001.jpeg" ); touch( "2004-04-29\ Z\237rich\ 0002.jpeg" ); touch( "2004-05-05\ Erg\212

Re: [Bacula-users] Postgresql encoding problem after migration to Bacula 2.0.3

2008-01-05 Thread Stephen Winnall
Hi Eric Thanks for the tip. The files that are causing me grief are old files which Bacula/PostgreSQL used to handle OK. My client is UTF8 these days, but these files are remnants which were originally created as MacRoman. I must confess I can't remember definitively what encoding I was us

Re: [Bacula-users] Postgresql encoding problem after migration to Bacula 2.0.3

2008-01-05 Thread Eric Bollengier
Hi, If your are using PostgreSQL with UTF8, Postgres will check all input to see if they are valid UTF8. If your client is in ISO885X, you will not be able to store filename with accent in your catalog. To be able to store anything, you have to use SQL_ASCII (the name could be confusing) Before

Re: [Bacula-users] Postgresql encoding problem after migration to Bacula 2.0.3

2008-01-04 Thread Dan Langille
Dan Langille wrote: > Stephen Winnall wrote: >> I have been using Bacula for over two years quite happily on an old >> Red Hat 9 server. The last version of Bacula that I used was a hand- >> compiled 2.0.0 with PostgreSQL 7.3.9. >> >> This server is the data storage for my Mac OS X and Windows c

Re: [Bacula-users] Postgresql encoding problem after migration to Bacula 2.0.3

2008-01-04 Thread Dan Langille
Stephen Winnall wrote: > I have been using Bacula for over two years quite happily on an old > Red Hat 9 server. The last version of Bacula that I used was a hand- > compiled 2.0.0 with PostgreSQL 7.3.9. > > This server is the data storage for my Mac OS X and Windows clients , > which it serv

[Bacula-users] Postgresql encoding problem after migration to Bacula 2.0.3

2008-01-04 Thread Stephen Winnall
I have been using Bacula for over two years quite happily on an old Red Hat 9 server. The last version of Bacula that I used was a hand- compiled 2.0.0 with PostgreSQL 7.3.9. This server is the data storage for my Mac OS X and Windows clients , which it serves with Netatalk and Samba. So any