Vanilla PostgreSQL

8 posts / 0 new
Last post
Last seen: 6 years 10 months ago
Joined: 08/23/2013 - 16:08
Vanilla PostgreSQL

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.

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

In, the file vanilla-conf/ is configured for the database vanilla44 :


But the Postgresql scripts create a database called repository44.

It should be :


Last seen: 6 years 10 months ago
Joined: 08/23/2013 - 16:08

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

Last seen: 7 years 4 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?




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

Last seen: 7 years 3 months ago
Joined: 04/13/2014 - 23:13

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


Last seen: 6 years 10 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.


Last seen: 6 years 9 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

Last seen: 5 years 1 month 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?