On Sat, Aug 30, 2008 at 8:32 AM, Dan Langille <dan AT langille DOT org> wrote:
> Jose Ildefonso Camargo Tolosa wrote:
>>
>> On Fri, Aug 29, 2008 at 10:32 PM, Dan Langille <dan AT langille DOT org> 
>> wrote:
>>>
>>> Michael Galloway wrote:
>>>
>>> side issue: I hope your database is SQL_ASCII, not UTF-8.
>>
>> Ok, you got my attention on this, and I'm falling asleep right now....
>> why? (if this question's answer is obvious, just ignore it, as I told
>> you, I'm falling asleep).
>
> From
> http://www.bacula.org/manuals/en/catalog/catalog/Installi_Configur_PostgreS.html
>
> "This script creates the PostgreSQL bacula database. Before running this
> command, you should carefully think about what encoding sequence you want
> for the text fields (paths, files, ...). Ideally, the encoding should be set
> to UTF8. However, many Unix systems have filenames that are not encoded in
> UTF8, either because you have not set UTF8 as your default character set or
> because you have imported files from elsewhere (e.g. MacOS X). For this
> reason, Bacula uses SQL_ASCII as the default encoding. If you want to change
> this, please modify the script before running it, but be forewarned that
> Bacula backups will fail if PostgreSQL finds any non-UTF8 sequences."
>

Ok. Thanks!  Mine is correctly set, I just was curious. :) .

>>
>>> e.g.
>>>
>>> $ psql -l | grep bacula
>>>  bacula                | bacula     | SQL_ASCII
>>>
>>> Otherwise, you may encounter other problems later.
>>>
>>
>> Ildefonso
>
>
> --
> Dan Langille
>
> BSDCan - The Technical BSD Conference : http://www.bsdcan.org/
> PGCon  - The PostgreSQL Conference:     http://www.pgcon.org/
>

Ildefonso.

-------------------------------------------------------------------------
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users