Configuring WSO2CARBON_DB in WSAS to use PostgreSQL

I am using WSAS version 3.1.2 however I'm not able to configure it to use PostgreSQL 8.4. I've attached my registry.xml and user-mgt.xml Any guidance would be very much appreciated. Error: [2009-12-17 21:53:21,234] INFO - Initializing system... {org.wso2.carbon.server.Main} [2009-12-17 21:53:23,980] ERROR - Database Error - ERROR: relation "um_dialect" does not exist Position: 35 {org.wso2.carbon.user.core.util.DatabaseUtil} org.postgresql.util.PSQLException: ERROR: relation "um_dialect" does not exist Position: 35 at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2062) at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1795) at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257) at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:479) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:367) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:271) at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:93) at org.wso2.carbon.user.core.claim.ClaimDAO.getDialectCount(ClaimDAO.java:144) at org.wso2.carbon.user.core.internal.Activator.exposeDefaultRealmAsService(Activator.java:327) at org.wso2.carbon.user.core.internal.Activator.start(Activator.java:187) at org.eclipse.osgi.framework.internal.core.BundleContextImpl$1.run(BundleContextImpl.java:782) at java.security.AccessController.doPrivileged(Native Method) at org.eclipse.osgi.framework.internal.core.BundleContextImpl.startActivator(BundleContextImpl.java:773) at org.eclipse.osgi.framework.internal.core.BundleContextImpl.start(BundleContextImpl.java:754) at org.eclipse.osgi.framework.internal.core.BundleHost.startWorker(BundleHost.java:352) at org.eclipse.osgi.framework.internal.core.AbstractBundle.resume(AbstractBundle.java:370) at org.eclipse.osgi.framework.internal.core.Framework.resumeBundle(Framework.java:1068) at org.eclipse.osgi.framework.internal.core.StartLevelManager.resumeBundles(StartLevelManager.java:557) at org.eclipse.osgi.framework.internal.core.StartLevelManager.incFWSL(StartLevelManager.java:464) at org.eclipse.osgi.framework.internal.core.StartLevelManager.doSetStartLevel(StartLevelManager.java:248) at org.eclipse.osgi.framework.internal.core.StartLevelManager.dispatchEvent(StartLevelManager.java:445) at org.eclipse.osgi.framework.eventmgr.EventManager.dispatchEvent(EventManager.java:220) at org.eclipse.osgi.framework.eventmgr.EventManager$EventThread.run(EventManager.java:330) [2009-12-17 21:53:23,996] FATAL - Cannot start User Manager Core bundle {org.wso2.carbon.user.core.internal.Activator} org.wso2.carbon.user.core.UserStoreException: Database Error - ERROR: relation "um_dialect" does not exist Position: 35 at org.wso2.carbon.user.core.claim.ClaimDAO.getDialectCount(ClaimDAO.java:150) at org.wso2.carbon.user.core.internal.Activator.exposeDefaultRealmAsService(Activator.java:327) at org.wso2.carbon.user.core.internal.Activator.start(Activator.java:187) at org.eclipse.osgi.framework.internal.core.BundleContextImpl$1.run(BundleContextImpl.java:782) at java.security.AccessController.doPrivileged(Native Method) at org.eclipse.osgi.framework.internal.core.BundleContextImpl.startActivator(BundleContextImpl.java:773) at org.eclipse.osgi.framework.internal.core.BundleContextImpl.start(BundleContextImpl.java:754) at org.eclipse.osgi.framework.internal.core.BundleHost.startWorker(BundleHost.java:352) at org.eclipse.osgi.framework.internal.core.AbstractBundle.resume(AbstractBundle.java:370) at org.eclipse.osgi.framework.internal.core.Framework.resumeBundle(Framework.java:1068) at org.eclipse.osgi.framework.internal.core.StartLevelManager.resumeBundles(StartLevelManager.java:557) at org.eclipse.osgi.framework.internal.core.StartLevelManager.incFWSL(StartLevelManager.java:464) at org.eclipse.osgi.framework.internal.core.StartLevelManager.doSetStartLevel(StartLevelManager.java:248) at org.eclipse.osgi.framework.internal.core.StartLevelManager.dispatchEvent(StartLevelManager.java:445) at org.eclipse.osgi.framework.eventmgr.EventManager.dispatchEvent(EventManager.java:220) at org.eclipse.osgi.framework.eventmgr.EventManager$EventThread.run(EventManager.java:330) Caused by: org.postgresql.util.PSQLException: ERROR: relation "um_dialect" does not exist Position: 35 at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2062) at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1795) at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257) at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:479) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:367) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:271) at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:93) at org.wso2.carbon.user.core.claim.ClaimDAO.getDialectCount(ClaimDAO.java:144) ... 15 more [2009-12-17 21:53:24,027] INFO - Starting WSO2 Carbon... {org.wso2.carbon.core.internal.CarbonCoreActivator} [2009-12-17 21:53:24,027] INFO - Operating System : Windows 7 6.1, x86 {org.wso2.carbon.core.internal.CarbonCoreActivator} [2009-12-17 21:53:24,027] INFO - Java Home : C:\Program Files\Java\jdk1.6.0_17\jre {org.wso2.carbon.core.internal.CarbonCoreActivator} [2009-12-17 21:53:24,042] INFO - Java Version : 1.6.0_17 {org.wso2.carbon.core.internal.CarbonCoreActivator} [2009-12-17 21:53:24,042] INFO - Java VM : Java HotSpot(TM) Client VM 14.3-b01,Sun Microsystems Inc. {org.wso2.carbon.core.internal.CarbonCoreActivator} [2009-12-17 21:53:24,042] INFO - Carbon Home : C:\OPENSO~1\APPLIC~1\WSO2WS~1.2\bin\.. {org.wso2.carbon.core.internal.CarbonCoreActivator} [2009-12-17 21:53:24,042] INFO - Java Temp Dir : C:\OPENSO~1\APPLIC~1\WSO2WS~1.2\bin\..\tmp {org.wso2.carbon.core.internal.CarbonCoreActivator} [2009-12-17 21:53:24,042] INFO - User : user, en-US, America/New_York {org.wso2.carbon.core.internal.CarbonCoreActivator} Thanks, J

Attachment	Size
user-mgt.xml	1.83 KB
registry.xml	3.5 KB