[keycloak-user] Keycloak appliance not working with either Postgres 9.2 or 9.3

I've attempted to change the datasource within the alpha-1 appliance to point to my own Postgresql, as encouraged by section 3.3.1 version of the documentation. However, when I do so and startup the JBoss 7, the application fails to deploy, with Postgres related errors. Caused by: org.postgresql.util.PSQLException: ERROR: operator does not exist: integer = character varying Hint: No operator matches the given name and argument type(s). You might need to add explicit type casts. Position: 78 at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2102) at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1835) at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257) at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:500) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:388) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:334) at org.jboss.jca.adapters.jdbc.WrappedPreparedStatement.executeUpdate(WrappedPreparedStatement.java:493) at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetReturnImpl.java:187) ... 39 more When I look at the database, there are 27 tables in the database i created, so I assume the problem is not with the datasource configuration? Could it be because I didn't finish the 2 additional steps of *Setting up SSL/HTTPS* and *Enforcing HTTPS connections* before attempting to deploy, is there a problem with the JPA integration with Postgres? Find attached the server.log file generated when i first attempted it with postgres 9.3 and then with 9.2. Hoping there's a resolution to this soon, cos I'm really looking forward to using this instead of JASIG's CAS in 2 upcoming projects. --- This email is free from viruses and malware because avast! Antivirus protection is active. http://www.avast.com