Vanilla PostgreSQL

8 posts / 0 new
Last post
Offline
Last seen: 4 years 11 months ago
Joined: 08/23/2013 - 16:08
Vanilla PostgreSQL
English

Vanilla can be run with both MySQL and PostgreSQL database.

Our server is pre-configured for MySQL. In order to use it with a PostgreSQL server, follow those steps : 

  • Download and extract vanilla-tomcat-mysql-server : download server.
  • Download, extract and restore PostgreSQL backups : download PostgreSQL backup.
  • Rename propertie files in vanilla-conf/ in order to use the one for PostgreSQL

For any other questions, please refer to the prerequisites documentation.

Offline
Last seen: 5 years 7 months ago
Joined: 02/04/2014 - 15:15

In vanilla-tomcat-mysql-4.4.2_GA.zip, the file vanilla-conf/repositoryone.postgres.properties is configured for the database vanilla44 :

bpm.vanilla.repository.database.jdbcUrl=jdbc:postgresql://localhost:5432/vanilla44

But the Postgresql scripts create a database called repository44.

It should be :

bpm.vanilla.repository.database.jdbcUrl=jdbc:postgresql://localhost:5432/repository44

Offline
Last seen: 4 years 11 months ago
Joined: 08/23/2013 - 16:08

Thank you for your update. This will be corrected in next Version of Vanilla.

Offline
Last seen: 5 years 5 months ago
Joined: 10/02/2013 - 03:51

I configured with Postgres as said in the Documentation and got the error

java.sql.SQLException: No suitable driver

 

Anyone knows what is the reason?

 

Thanks

--

Carlos Villasana
Cel. 58.412.4766393
skype: carlos.villasana
Pentaho BI Consultant
www.pentaho.com

Offline
Last seen: 5 years 5 months ago
Joined: 04/13/2014 - 23:13

copy the jdbc driver file from ´resources\jdbc' to 'lib'.

 

Offline
Last seen: 4 years 11 months ago
Joined: 08/23/2013 - 16:08

Hi villasanacarlos,

Do you still have issues connecting to Vanilla using PostgreSQL database ? If not, could you provide more details : when / where the error occur, what is youf configuration file...

Normally it should work without any move of postgreSQL driver.

Regards

Offline
Last seen: 4 years 10 months ago
Joined: 09/23/2014 - 10:41

Has someone been able to install Vanilla 4.4.2 on Windows with Postgresql 9.3?

Thank you

Offline
Last seen: 3 years 3 months ago
Joined: 04/30/2016 - 20:29

I have downloaded vanilla 5.2 and I am trying to use postgresql. I cannot find sql script to prepare database.

Can you help me?

 

Thanks,

Mario