Hi Hilaria,

The labkey.xml file looks fine. The postgres database we're looking at is fine as well, but LabKey would have generated a new database called "labkey" since that's what you called it in the labkey.xml file as:

url="jdbc:postgresql://localhost:5432/labkey"

However, the root cause of the error appears to be:

Caused by: java.io.IOException: Illegal UTF-8 sequence: initial byte is 10xxxxxx: 171
    at org.postgresql.core.UTF8Encoding.decode(UTF8Encoding.java:98)
    at org.postgresql.core.PGStream.ReceiveString(PGStream.java:329)
    at org.postgresql.core.v3.ConnectionFactoryImpl.readStartupMessages(ConnectionFactoryImpl.java:686)
    at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:207)
    ... 27 more

Although your database is using UTF-8 encoding, The LC_COLLATE and the LC_CTYPE appear to be using 'Spanish_Argentina.1252' for a locale rather than just 'C', which doesn't tie itself to any locale.

Can you manually create a database in pgAdmin III for us via the UI and tell us what options you get under the Definition tab for the LC_COLLATE and LC_CTYPE? If you have "C" as an option, I would like for you to create a new database and call it "labkey" and set the LC_COLLATE and LC_CTYPE to "C", then restart Tomcat afterwards and let us know whether LabKey starts up without errors or not.

Regards,

Jon

Hi Jon!

It worked effectively!

I made a Base called Labkey in pgAdminIII, and I had to select template=0 then It alowed me too add in the SQL eyelash, LC_COLLATE=`C` LC_CTYPE=`C`.
I restarted Tomcat and IT WORKED!
Thank you very much!

Hilaria

Fantastic! Glad to hear things are working now!

Regards,

Jon