Hi Hector, I'm not the most technical person in our team, but after googling I found following topic that might be of help.
here's the link: http://www.forosdelweb.com/f99/postgresql-8-3-0-no-deja-crear-bd-con-encoding-latin1-559822/ Here's what you do (according to the discussion): *1) Te "logeas" como root. 2) Deten el postgres según tu distribución (si está activo). rcpostgresql stop /etc/init.d/postgresql stop 3) Elimina el directorio data (puedes crear otro cluster en lugar de eliminar este directorio, en mi caso se trataba de portar una BD antigua a la version 8.3 del postgres, por eso quise eliminar este directorio). rm -rf /var/lib/pgsql/data 4) Actúa como usuario postgres su - postgres 5) Crea un nuevo cluster indicandole el locale que necesites (en mi caso, es_CO.LATIN1) pero puedes usar el de tu país, es_ES.LATIN1, es_AR.ut8, etc. Nota: La codificacion (opcion -E) no es necesaria puesto que se deriva de locale. initdb --locale=es_CO.LATIN1 -D /var/lib/pgsql/data 6) Listo, ahora seguramente querrás que el postgres te inicie automáticamente en los niveles 3 y 5. exit (para salir de la sesión del usuario postgres y volver a root) chkconfig --level 35 postgresql on 7) Prueba a reiniciar el servicio... si tienes algun problema comentalo aquí. rcpostgresql restart 8) Si todo te sale bien, ya puedes crear tu base de datos. createdb -U postgres -E LATIN1 nombrebd * I hope this helps Bram @mire - http://www.atmire.com Technologielaan 9 - 3001 Heverlee - Belgium 533 2nd Street - Encinitas, CA 92024 - USA http://www.togather.eu - Before getting together, get t...@ther 2009/9/10 Héctor Garcia Peris <[email protected]> > The problem is when I try to create the database using UNICODE I get > this error: > > dsp...@dspace:~$ /usr/lib/postgresql/8.3/bin/createdb -U dspace -E > UNICODE dspace2 > createdb: falló la creación de la base de datos: > ERROR: la codificación UTF8 no coincide con la configuración regional > del servidor es_ES > DETAIL: La configuración regional LC_CTYPE del servidor requiere la > codificación LATIN1. > > Sorry, but the message is in Spanish. I try to translate it: > > createdb: failed in the database creation > ERROR: UTF8 codification doesn't coincide with the regional > configutation of the server es_ES > DETAIL: Regional codification LC_CTYPE of the server requires LATIN1 > codification. > > This is the reason because my database is created with LATIN1. Any help > to create it with UNICODE is welcome. > > Thanks. > > Hilton Gibson escribió: > > On Wednesday 09 September 2009 15:00:33 Héctor Garcia Peris wrote: > > > >> I think the problem is related with the codification. If I create an > >> item with special characters like "Título 1", when I run this: > >> > >> dsp...@dspace:~$ /home/dspace/dspace/bin/index-update > >> Creating browse index > >> Exception in thread "main" org.dspace.browse.BrowseException: > >> org.postgresql.util.PSQLException: ERROR: carácter 0xcc81 de > >> codificación «UTF8» no tiene equivalente en «LATIN1» > >> <lines suppressed> > >> > >> without special characters I have no problem. > >> > >> The problem is that I couldn't create the database if I don't use LATIN1 > >> codification. How can I create the database with the UNICODE > codification? > >> > > See: > > > http://services.lib.sun.ac.za/wiki/index.php/Install_Dspace_Server_Setup#Enable_Tomcat_with_UTF-8_multi- > > byte_encoding > > > > > http://services.lib.sun.ac.za/wiki/index.php/Install_Dspace_Server_Setup#Create_the_PostgreSQL_.27dspace.27_database > > > > Cheers > > > > hg. > > > > > >> Thanks. > >> > >> Claudia Jürgen escribió: > >> > >>> Hola Héctor, > >>> > >>> did you ran > >>> [dspace]/bin/index-init after the fresh installation? > >>> > >>> Saludos > >>> > >>> Claudia Jürgen > >>> > >>> Héctor Garcia Peris schrieb: > >>> > >>>> Hello, > >>>> > >>>> I have installed dspace 1.5.2 in a debian linux stable version. > >>>> > >>>> The installation uses postgres as database and is a new installation. > >>>> I have created a testing community and a testing collection without > >>>> problems. But when I have created a new item, although it was created > >>>> without problems I can't see it in the collection > >>>> (http://dspace:8080/jspui/handle/123456789/2) or when I try to find > >>>> it using the search engine > >>>> (http://dspace:8080/jspui/simple-search?query=&submit=Ir+). > >>>> Nevertheless I can access to the item data using the URI associated > >>>> to it (http://dspace:8080/jspui/handle/123456789/3). > >>>> > >>>> It seems that there is something missing between the collection and > >>>> the item. Can anybody help me? > >>>> > >>>> Thanks. > >>>> > > > > _______________________________________________ > > Dspace-general mailing list > > [email protected] > > http://mailman.mit.edu/mailman/listinfo/dspace-general > > > > -- > > --------------------------------------------------------------------- > Héctor Garcia Peris > Dpto. Informática > Instituto Valenciano de Investigaciones Económicas S.A. (Ivie) > C/ Guardia Civil, 22 esc-2 1º 46020 - Valencia (Spain) > Tfno.: +34 - 963190050 / +34 - 963930816 > Fax.: +34 - 963190055 / +34 - 963930856 > e-mail: [email protected] > Web: http://www.ivie.es > ---------------------------------------------------------------------- > > _______________________________________________ > Dspace-general mailing list > [email protected] > http://mailman.mit.edu/mailman/listinfo/dspace-general >
_______________________________________________ Dspace-general mailing list [email protected] http://mailman.mit.edu/mailman/listinfo/dspace-general
