Configure PostgreSQL Pentaho RepositoryDatabase

This legacy page is kept for existing links. The current content is in Use PostgreSQL as Your Repository Database (Archive installation).

Now that you have initialized your repository database, you will need to configure Quartz, Hibernate, Jackrabbit, and Pentaho Operations Mart for a PostgreSQL database.

Note: PostgreSQL is configured by default; if you kept the default passwords and port, you will not need to set up Quartz, Hibernate, Jackrabbit or the Pentaho Operations Mart. You can skip ahead to the Tomcat-specific connection tasks.

By default, the examples in this section are for a PostgreSQL database that runs on port 5432. The default password is also in these examples.

CAUTION:

If you have a different port or different password, make sure that you change the password and port number in these examples to match the ones in your configuration.