cancel
Showing results for 
Search instead for 
Did you mean: 

Will activity work with pgpool replication?

guai
Champ in-the-making
Champ in-the-making
Hi
pgpool is a middleware to postgresql RDBMS.
It receives connections from clients and itself connect to postgres DB nodes and sends requests to all nodes (in replication mode; it can also just pool connections).
And because of its nature pgpool should be carefully used with requests containing things like random(), CURRENT_TIMESTAMP, sequences etc. They can differ among DB nodes.
Do activiti use these things?
1 REPLY 1

jbarrez
Star Contributor
Star Contributor
No, we use as little as db-specific stuff as possible.
We do use CURRENT_TIMESTAMP, but it seems to be for myself only.

You can find the DDL scripts here: https://github.com/Activiti/Activiti/tree/master/modules/activiti-engine/src/main/resources/org/acti...