Postgres as default database in Processmaker

Question

By default Processmaker 3.0.1.8 uses MYSQL database. We don't want to increase our work of maintaining two databases. we cannot let go Postgres but to use Processmaker we need to also use Mysql. Is there anyone who has used ProcessMaker 3.0.1.8 with postgres 9.2+.

I read from their forum that to use postgresql, there will be a huge rewrite of the PHP code. Therefore, their code was tuned for mysql database from the beginning and not through sql abstraction. The solution is you can still use postgresql by means of scripts and variables and save them to external database. — AER 4AF, Mar 15 '18 at 07:32

score 2 · Accepted Answer · answered Sep 06 '16 at 18:16

ProcessMaker does not currently work with Postgres as the core application database.

This is something that is being considered for the next version, 4.0, however no official decision has yet to be made.

So, for now, if you want to use ProcessMaker, it has to be on a MySQL database.

score 1 · Answer 2 · edited Feb 18 '20 at 18:47

1

ProcessMaker 4 now works with Postgres, MySQL, and MS SQL, so we recommend you migrate to it if you are interested in using Postgres. You can get the source on github: ProcessMaker Open Source

edited Feb 18 '20 at 18:47

João Colaço

1,202
1
14
38

answered Feb 18 '20 at 16:40

breale

21
1

Postgres as default database in Processmaker

2 Answers2