Sorry, here was the command I was trying to execute:
createdb -U dspace -E UNICODE dspace
and here is the error I'm getting:
createdb: database creation failed: ERROR: encoding UTF8 does not match
server's locale en_US.ISO8859-15
DETAIL: The server's LC_CTYPE setting requires encoding LATIN9.
Sue
________________________________
From: Thornton, Susan M. (LARC-B702)[RAYTHEON TECHNICAL SERVICES COMPANY]
Sent: Tuesday, August 25, 2009 1:57 PM
To: [email protected]
Cc: 'Kimbrough, Glenn W. (LARC-B704)[NCI INFORMATION SYSTEMS]'; Smail, James W.
(LARC-B702)[RAYTHEON TECHNICAL SERVICES COMPANY]
Subject: Problem creating dspace database in 1.5.1
Hi,
I am trying to install dspace 1.5.1 on a Windows machine with Solaris 10
x86. I'm getting an error when I try to create the dspace database:
STATEMENT: createuser -U postgres -d -A -P dspace;
ERROR: encoding UTF8 does not match server's locale en_US.ISO8859-15
DETAIL: The server's LC_CTYPE setting requires encoding LATIN9.
STATEMENT: CREATE DATABASE dspace ENCODING 'UNICODE';
We are running postgreSQL 8.3.
Here are our locale settings from postgresql.conf:
# - Locale and Formatting -
datestyle = 'iso, mdy'
#timezone = unknown # actually, defaults to TZ environment
# setting
#timezone_abbreviations = 'Default' # Select the set of available time zone
# abbreviations. Currently, there are
# Default
# Australia
# India
# You can create your own file in
# share/timezonesets/.
#extra_float_digits = 0 # min -15, max 2
#client_encoding = sql_ascii # actually, defaults to database
# encoding
# These settings are initialized by initdb, but they can be changed.
lc_messages = 'C' # locale for system error message
# strings
lc_monetary = 'en_US.ISO8859-15' # locale for monetary
formatting
lc_numeric = 'en_US.ISO8859-15' # locale for number formatting
lc_time = 'en_US.ISO8859-15' # locale for time
formatting
# default configuration for text search
default_text_search_config = 'pg_catalog.english'
Can anyone help? I'm not exactly sure what to do about this. We have another
instance running on a Sun Solaris 10 sparc machine and the only difference I
see in the postgresql.conf files is that lc_time='C' in sparc.
Thanks in advance,
Sue
Sue Walker-Thornton
ConITS Contract
NASA Langley Research Center
Integrated Library Systems Application & Database Administrator
130 Research Drive
Hampton, VA 23666
Office: (757) 224-4074
Fax: (757) 224-4001
Pager: (757) 988-2547
Email: [email protected]<mailto:[email protected]>
------------------------------------------------------------------------------
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day
trial. Simplify your report design, integration and deployment - and focus on
what you do best, core application coding. Discover what's new with
Crystal Reports now. http://p.sf.net/sfu/bobj-july
_______________________________________________
DSpace-tech mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/dspace-tech
