I am currently using an older version of bacula, (director version 2.0.3) as 
shipped in the EPEL 5.0 repositories for CentOS 5. I am also using PostgreSQL 
8.4.
The database creation script in this package has not been updated to fix the
problem noted here:

http://markmail.org/search/?q=SQL_ASCII+list:net.sourceforge.lists.bacula-users#query:SQL_ASCII%20list%3Anet.sourceforge.lists.bacula-users+page:1+mid:vmpq3povm7utgzfs+state:results

But thats ok, I went ahead and just added the TEMPLATE=template0; modification.
What I am wondering now is if it is ok for the Collation and Ctype to be set as 
en_US.UTF8 instead of C/POSIX.

This is what my database looks like.

                                 List of databases
   Name    |  Owner   | Encoding  |  Collation  |    Ctype    |   Access 
privileges   
-----------+----------+-----------+-------------+-------------+-----------------------
 bacula    | postgres | SQL_ASCII | en_US.UTF-8 | en_US.UTF-8 | 


-- 
Fletcher Johnson <fjohnson AT rotman-baycrest.on DOT ca>

------------------------------------------------------------------------------
Benefiting from Server Virtualization: Beyond Initial Workload 
Consolidation -- Increasing the use of server virtualization is a top
priority.Virtualization can reduce costs, simplify management, and improve 
application availability and disaster protection. Learn more about boosting 
the value of server virtualization. http://p.sf.net/sfu/vmware-sfdev2dev
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users