What is the exception in the log file? You may need to restart tomcat after switching Datasource to let Hibernate to update your database schema.

Hello Owen,

thanks for your reply.

I restarted tomcat...

I directly modified the app_datasource-xxx.properties files as described in the Running Joget with PostgreSQL in V4.

the app_datasource-postgresql.properties :

#

#Tue Nov 03 17:38:06 CET 2015

workflowDriver=org.postgresql.Driver

workflowUrl=jdbc\:postgresql\://localhost/jwdb

workflowUser=postgres

workflowPassword=postgres

the joget.log :

INFO  04 nov. 2015 16:11:39 org.joget.commons.util.SetupManager  - Using base directory: ./wflow/
INFO  04 nov. 2015 16:11:43 org.joget.commons.util.DynamicDataSource  - datasourceName=workflow, url=jdbc:postgresql://localhost/jwdb, user=postgres
INFO  04 nov. 2015 16:11:49 org.joget.commons.util.SetupManager  - Initializing setup cache
INFO  04 nov. 2015 16:11:49 org.joget.plugin.base.PluginManager  - PluginManager initialized
INFO  04 nov. 2015 16:11:59 org.joget.workflow.model.service.WorkflowManagerImpl  - Datasource bound to jwdb
INFO  04 nov. 2015 16:12:00 org.displaytag.filter.ResponseOverrideFilter  - Filter initialized. Response buffering is enabled
INFO  04 nov. 2015 16:12:17 org.joget.commons.util.DynamicDataSource  - datasourceName=workflow, url=jdbc:postgresql://localhost/jwdb, user=postgres
INFO  04 nov. 2015 16:12:18 org.joget.commons.util.SetupManager  - Initializing setup cache
INFO  04 nov. 2015 16:12:18 org.joget.plugin.base.PluginManager  - PluginManager initialized
INFO  04 nov. 2015 16:12:20 org.joget.workflow.model.service.WorkflowManagerImpl  - Datasource bound to jwdb
ERROR 04 nov. 2015 16:12:31 org.hibernate.engine.jdbc.spi.SqlExceptionHelper  - ERREUR: la colonne resourcebu0_.messagekey n'existe pas
  Position : 35
ERROR 04 nov. 2015 16:12:31 org.hibernate.engine.jdbc.spi.SqlExceptionHelper  - ERREUR: la colonne resourcebu0_.messagekey n'existe pas
  Position : 35
ERROR 04 nov. 2015 16:12:31 org.hibernate.engine.jdbc.spi.SqlExceptionHelper  - ERREUR: la colonne resourcebu0_.messagekey n'existe pas
  Position : 35
ERROR 04 nov. 2015 16:12:31 org.hibernate.engine.jdbc.spi.SqlExceptionHelper  - ERREUR: la colonne resourcebu0_.messagekey n'existe pas
  Position : 35
ERROR 04 nov. 2015 16:12:31 org.hibernate.engine.jdbc.spi.SqlExceptionHelper  - ERREUR: la colonne resourcebu0_.messagekey n'existe pas
  Position : 35

We can see the name of the table has changed "resourcebu0_" instead of "wf_resource_bundle_message" in the mysql database and the postgreSQL database too.

Hi, i just following exactly same steps in this Running Joget Workflow with PostgreSQL, it seem to work without issue. I am running PostgreSQL 9.4.5 with Joget enterprise RC3. Since i can't replicate ur issue, i have no idea how to help u. Sorry. May be u can redo all the steps to following the steps in the above article again?

Hi,

yes it works !

Thanks a lot.

So data tables are empty.

After having imported my apps in the new portal, I'm trying to insert data from mysql to postgresql data tables. 

...still an error message when importing apps :Validation Error - Error storing data: could not extract ResultSet (Version5)

!!!!!!

Thx.. we finally found the root cause and fixed it..The fix will be available in next release.. I will let u know. :)

Ok, i love mysql but my job prefers postgresql :)

Hi Owen Ong / De Villers, if you share the short summary with steps followed, its will help for forum members, as I too Plan to upgrade joget from V4 to V5 and thinking for opt Postgres as DB.

Hi Janak, as the bug is fixed, you may just follow exactly same steps in this http://dev.joget.org/community/display/KBv4/Running+Joget+Workflow+with+PostgreSQL (Running Joget Workflow with PostgreSQL). And then you'll can migrate your apps.

Hi,

Try 

workflowDriver=org.postgresql.Driver
#workflowUrl=jdbc\:postgresql\://localhost/jwdb
workflowUrl=jdbc:postgresql://localhost:5432/jwdb

JOGER running with postgresql 9.5

Regards

new link : http://dev.joget.org/community/display/KBv5/Running+Joget+Workflow+with+PostgreSQL

Same solution worked for me, Is there any version dependency ??i tried with Postgres 9.4