The postgresql client and server encodings you are using are different.
You can set the client encoding to SQL_ASCII and it should work.

See 
http://www.network-theory.co.uk/docs/postgresql/vol3/AutomaticCharacterSetConversionBetweenServerandClient.html

You can also make a bacula database with a default encoding which is not
UTF-8.

Rory

On 04/04/11, contenidos2000-bacula AT yahoo.com DOT ar (contenidos2000-bacula 
AT yahoo.com DOT ar) wrote:
> Hello
> I'm postgresql newbie and I would like to use it instead mysql.
> I have compilde bacula from sources and installed it.
> Postgresql is installed and working in the default way in Centos 5.5?
> I'm using?postgresql-8.4.7-1PGDG from the official postgresql repositories.
> When I create the database I have this error:
> -------------------------------------------------------------------------------------------------------------------------
> [admin@vd1 bin]$ ./create_postgresql_database?psql:<stdin>:2: ERROR: 
> ?encoding SQL_ASCII does not match locale en_US.UTF-8DETAIL: ?The chosen 
> LC_CTYPE setting requires encoding 
> UTF8.?!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! Creation of 
> bacula database failed. 
> !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!?Database encoding bad. 
> Do not use this database
> ---------------------------------------------------------------------------------------------------------------------------
> Seems a postgres issue.
> Any help ?
> Thanks in advance.
> roberto

> ------------------------------------------------------------------------------
> Create and publish websites with WebMatrix
> Use the most popular FREE web apps or write code yourself; 
> WebMatrix provides all the features you need to develop and 
> publish your website. http://p.sf.net/sfu/ms-webmatrix-sf

> _______________________________________________
> Bacula-users mailing list
> Bacula-users AT lists.sourceforge DOT net
> https://lists.sourceforge.net/lists/listinfo/bacula-users


-- 
Rory Campbell-Lange
rory AT campbell-lange DOT net

Campbell-Lange Workshop
www.campbell-lange.net
0207 6311 555
3 Tottenham Street London W1T 2AF
Registered in England No. 04551928

------------------------------------------------------------------------------
Create and publish websites with WebMatrix
Use the most popular FREE web apps or write code yourself; 
WebMatrix provides all the features you need to develop and 
publish your website. http://p.sf.net/sfu/ms-webmatrix-sf
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users