Re: [Bacula-users] Catastrophic changes to PostgreSQL 8.4 - Mailing list pgsql-general

From Avi Rozen
Subject Re: [Bacula-users] Catastrophic changes to PostgreSQL 8.4
Date
Msg-id 4B179471.4040504@gmail.com
Whole thread Raw
In response to Re: Catastrophic changes to PostgreSQL 8.4  (Craig Ringer <craig@postnewspapers.com.au>)
Responses Re: [Bacula-users] Catastrophic changes to PostgreSQL 8.4  ("Kern Sibbald" <kern@sibbald.com>)
Re: [Bacula-users] Catastrophic changes to PostgreSQL 8.4  (Eitan Talmi <eitant@gmail.com>)
List pgsql-general
Craig Ringer wrote:
> Kern Sibbald wrote:
>
>> Hello,
>>
>> Thanks for all the answers; I am a bit overwhelmed by the number, so I am
>> going to try to answer everyone in one email.
>>
>> The first thing to understand is that it is *impossible* to know what the
>> encoding is on the client machine (FD -- or File daemon).  On say a
>> Unix/Linux system, the user could create filenames with non-UTF-8 then switch
>> to UTF-8, or restore files that were tarred on Windows or on Mac, or simply
>> copy a Mac directory.  Finally, using system calls to create a file, you can
>> put *any* character into a filename.
>>
>
> While true in theory, in practice it's pretty unusual to have filenames
> encoded with an encoding other than the system LC_CTYPE on a modern
> UNIX/Linux/BSD machine.
>

In my case garbage filenames are all too common. It's a the sad
*reality*, when you're mixing languages (Hebrew and English in my case)
and operating systems. Garbage filenames are everywhere: directories and
files shared between different operating systems and file systems, mail
attachments, mp3 file names based on garbage id3 tags, files in zip
archives (which seem to not handle filename encoding at all), etc.

When I first tried Bacula (version 1.38), I expected to have trouble
with filenames, since this is what I'm used to. I was rather pleased to
find out that it could both backup and restore files, regardless of
origin and destination filename encoding.

I like Bacula because, among other things, it can take the punishment
and chug along, without me even noticing that there was supposed to be a
problem (a recent example: backup/restore files with a negative mtime ...)

My 2c
Avi

pgsql-general by date:

Previous
From: Dave Page
Date:
Subject: PostgreSQL@FOSDEM 2010 - Call for talks
Next
From: "Daniel Verite"
Date:
Subject: Re: Catastrophic changes to PostgreSQL 8.4