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-bac...@yahoo.com.ar (contenidos2000-bac...@yahoo.com.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@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/bacula-users -- Rory Campbell-Lange r...@campbell-lange.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@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
