Use knowage with Postgresql database

Question

Hello

I tried to downald knowage with knowage installer but I noticed that it's supporting just mysql database.Can I change some conf file in order to swap mode of database to postgresql or is there any other solution to solve my issue?

thanks

Answer 1

Hi,

    there's a good solution by lawi related to question "Installing to non-MySQL database".

Francesco

Comments

Yes .Firstly Ithank you very much for your answer. I've already seen these solutions. But I need after that to package knowage into docker so the two solutions posted didn't work for me.I need something simpler than that like just changing conf files.
Yours faithfully

---

can I use the solution that consist in dumping into  myql and restore it to  psql

Answer 2

Dear Akli,

You can simply change the configuration following these steps:

1) create DBMS schema and execute the DDL

2) chenge the file webapps\knowage\WEB-INF\classes\hibernate.cfg.xml: you have to change the dialect

<property name="hibernate.dialect">org.hibernate.dialect.MySQLDialect</property>

Remember : you have to make this changes on every hibernate.cfg.xm

3) change webapps\knowage\WEB-INF\classes\quartz.xml

#-------------- job store delegate class -----------------------------------
# Hsqldb delegate class
#org.quartz.jobStore.driverDelegateClass=org.quartz.impl.jdbcjobstore.HSQLDBDelegate

# Mysql/Ingres delegate class
org.quartz.jobStore.driverDelegateClass=org.quartz.impl.jdbcjobstore.StdJDBCDelegate

# Postgres delegate class
#org.quartz.jobStore.driverDelegateClass=org.quartz.impl.jdbcjobstore.PostgreSQLDelegate

# Oracle delegate class
#org.quartz.jobStore.driverDelegateClass=org.quartz.impl.jdbcjobstore.oracle.OracleDelegate

# Oracle in WEBLOGIC delegate class
# org.quartz.jobStore.driverDelegateClass=org.quartz.impl.jdbcjobstore.oracle.weblogic.WebLogicOracleDelegate

# SQLServer delegate class
#org.quartz.jobStore.driverDelegateClass=org.quartz.impl.jdbcjobstore.MSSQLDelegate

#---------------------------------------------------------------------------

Comments

Thank you very much.I will try it