Re: [Bacula-users] Catastrophic changes to PostgreSQL 8.4

From: Stephen Frost <sfrost(at)snowman(dot)net>
To: Craig Ringer <craig(at)postnewspapers(dot)com(dot)au>
Cc: Jerome Alet <jerome(dot)alet(at)univ-nc(dot)nc>, Kern Sibbald <kern(at)sibbald(dot)com>, bacula-devel <bacula-devel(at)lists(dot)sourceforge(dot)net>, pgsql-general(at)postgresql(dot)org, bacula-users <bacula-users(at)lists(dot)sourceforge(dot)net>
Subject: Re: [Bacula-users] Catastrophic changes to PostgreSQL 8.4
Date: 2009-12-03 03:44:29
Message-ID: 20091203034429.GX17756@tamriel.snowman.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers

* Craig Ringer (craig(at)postnewspapers(dot)com(dot)au) wrote:
> ... so it's defaulting to SQL_ASCII, but actually supports utf-8 if your
> systems are all in a utf-8 locale. Assuming there's some way for the
> filed to find out the encoding of the director's database, it probably
> wouldn't be too tricky to convert non-matching file names to the
> director's encoding in the fd (when the director's encoding isn't
> SQL_ASCII, of course).

I'm not sure which piece of bacula connects to PostgreSQL, but whatever
it is, it could just send a 'set client_encoding' to the PG backend and
all the conversion will be done by PG..

> This also makes me wonder how filenames on Mac OS X and Windows are
> handled. I didn't see any use of the unicode-form APIs or any UTF-16 to
> UTF-8 conversion in an admittedly _very_ quick glance at the filed/
> sources. How does bacula handle file names on those platforms? Read them
> with the non-unicode APIs and hope they fit into the current non-unicode
> encoding? Or am I missing something?

Good question.

Stephen

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2009-12-03 05:03:15 Re: Strange. I can logon with an invalid or no password atall
Previous Message Craig Ringer 2009-12-03 03:38:01 Re: [Bacula-users] Catastrophic changes to PostgreSQL 8.4

Browse pgsql-hackers by date

  From Date Subject
Next Message Robert Haas 2009-12-03 03:49:48 Re: Re: [COMMITTERS] pgsql: Rewrite GEQO's gimme_tree function so that it always finds a
Previous Message Craig Ringer 2009-12-03 03:38:01 Re: [Bacula-users] Catastrophic changes to PostgreSQL 8.4