I'm brand new to DSpace and have experienced difficulty installing -- the show-stopper has been creating the dspace data base, where the createdb utility kicked out a fatal error:
createdb -U dspace -E UNICODE dspace createdb: database creation failed: ERROR: encoding "UTF8" does not match locale "en_US" DETAIL: The chosen LC_CTYPE setting requires encoding "LATIN1". and it was a little bit of a struggle to figure out why (even with the kind assistance of helix84). Turns out that my distribution, Slackware 64-bit 14.0 stable, defaults to: # en_US is the Slackware default locale: export LANG=en_US I have four systems, all Slackware 14.0, all with that default locale and PostgreSQL was compiled, installed and initialized with that locale and I've been using PostgreSQL for years with no difficulties with that locale. And I've got two big, honking servers on way that will be DSpace servers so time is getting tight. Oops: PostgreSQL does care about the locale when it's initialized. Setting # There is also support for UTF-8 locales, but be aware that # some programs are not yet able to handle UTF-8 and will fail to # run properly. In those cases, you can set LANG=C before # starting them. Still, I'd avoid UTF unless you actually need it. export LANG=en_US.UTF-8 before initializing PostgreSQL takes care of the problem with createdb (even manually setting LC* options with createdb didn't do it, at least for me -- had to be system-wide before initialization). en_US is the default because some programs don't work quite properly with en_US.UTF-8 (and I do know what they are but I can live with that), and, of course, anyone not in the US would want to initialize PostgreSQL with their local language (and with the UTF-8 option!). Now, there may be some other method for re-initializing PostgreSQL, but I didn't find it (and I didn't lose any existing data bases in the process). I hope this may helps somebody sometime. -- A riddle, wrapped in a mystery, inside an enigma but that's my story and I'm stickin' to it. ------------------------------------------------------------------------------ See everything from the browser to the database with AppDynamics Get end-to-end visibility with application monitoring from AppDynamics Isolate bottlenecks and diagnose root cause in seconds. Start your free trial of AppDynamics Pro today! http://pubads.g.doubleclick.net/gampad/clk?id=48808831&iu=/4140/ostg.clktrk _______________________________________________ DSpace-tech mailing list DSpace-tech@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspace-tech List Etiquette: https://wiki.duraspace.org/display/DSPACE/Mailing+List+Etiquette