Flecther, is not recommended to use UTF8 on the Catalog database, in the
create_postgresql_database script there's a BIG warning about it:
#
# Please note: !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
# We do not recommend that you use ENCODING 'SQL_UTF8'
# It can result in creating filenames in the database that
# cannot be seen or restored.
# !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
#
#
2011/4/15 Fletcher Johnson <fjohn...@rotman-baycrest.on.ca>
> 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 <fjohn...@rotman-baycrest.on.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@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/bacula-users
>
------------------------------------------------------------------------------
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@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
