topic Re: Postgres create db script in Alfresco Archive

Postgres create db script

fchatzia — Mon, 10 Dec 2012 07:59:10 GMT

Hi,I want to set activiti explorer running with postgres so i change the configuration of the activiti-5.10\setup\build.db.properties file to see my postgres db and i also change the activiti-5.10\apps\apache-tomcat-6.0.32\webapps\activiti-explorer\WEB-INF\classes\db.properties file but when i run

Re: Postgres create db script

trademak — Mon, 10 Dec 2012 08:02:45 GMT

Hi,

So you have a database created in PostgreSQL with the name "activiti" ?
To run the Activiti Explorer with PostgreSQL you only have to change the db.properties in the WEB-INF classes.

Best regards,

Re: Postgres create db script

vvpds_ram — Thu, 06 Nov 2014 07:20:26 GMT

Hi,

db.properites entries should be..

db=pgsql
jdbc.driver=org.postgresql.Driver
jdbc.url=jdbcostgresql://localhost:5432/Activiti (it will be different for others)
jdbc.username=postgres (Username)
jdbc.password=**** (password)

make sure the java driver for postgressql postgresql-9.3-1102.jdbc4.jar (it might vary for versions) in the activiti "lib" directory.

Re: Postgres create db script

blvnt — Thu, 18 Jun 2015 09:41:33 GMT

I had tried this, but still can't access activiti explorer on web browser. any ideas?

Re: Postgres create db script

stephane1 — Thu, 06 Aug 2015 12:49:34 GMT

To make it work, I've changed the following parameters:
db=postgres
jdbc.url=jdbcostgresql://localhost/activiti

Also I have used a dedicated connection role rather than the prebuilt postgres account.