Re: [Bacula-users] SQL_ASCII, Collation and Ctype, PostgreSQL 8.4

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 <fjohnson AT rotman-baycrest.on DOT 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 <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

------------------------------------------------------------------------------
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