wso2 identity server with postgres database schema

0
votes

Actually I want to setup wso2is 5.3.0 with the postgres schema for production environment, which I have configured as "jdbc:postgresql://localhost:5432/wso2?currentSchema=wso2pgschema" in the masterdatasources.xml file and able to install wso2is in the postgres schema but when I goes to the browser and tries to login its gives me error

[LOG] [2017-05-14 19:15:59,023] ERROR {org.wso2.carbon.user.core.common.AbstractUserStoreManager} - Error occurred while accessing Java Security Manager Privilege Block [2017-05-14 19:15:59,026] ERROR {org.wso2.carbon.core.services.authentication.AuthenticationAdmin} - System error while Authenticating/Authorizing User : Error when handling event : PRE_AUTHENTICATION

Is there a way we can install it database schema ?or we have to install it in the database public schema/keep installation with the inbuild h2 database for production.

Please Help.

Thanks Pankaj

1
wso2wso2is

1 Answers

0
votes

Yes, you can use a schema other than the public schema. Please refer the post here for the steps.

For the second part of the question, the default H2 database is not recommended for production systems.