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
[email protected]
https://lists.sourceforge.net/lists/listinfo/dspace-tech
List Etiquette: https://wiki.duraspace.org/display/DSPACE/Mailing+List+Etiquette
