Repository Configuration

Octopus stores all the information such as, connection definitions, task instances, run plans, etc.. in a relational database. It ships with an embedded H2 Database. You replace the default database with any of the supported databases. To change the database type you will need two things;

• Put an appropriate JDBC driver to the libs folder
• Change the repository connection parameters on the application.properties file.

For example if you want to use PostgreSQL for repository;

1. Set octopus.datasource.url parameter with the JDBC URL of the your Postgre database. (eg. jdbc:postgresql://host:port/database)
2. Set octopus.datasource.username and octopus.datasource.password parameters.
3. Set the hibernate dialect octopus.jpa.properties.hibernate.dialect wit h org.hibernate.dialect.PostgreSQLDialect
4. Download the JDBC driver for PostgreSQL
5. Place the driver file under OCTOPUS_HOME/libs folder. That is all you have to do. You can now use PostgreSQL as your repository.

Technically you can use any database that Hibernate supports. Plese refer to the hibernate docs on the internet for supported databases and dialects.