Skip to main content
Pentaho Documentation

Unable to Use the Database Init Scripts for PostgreSQL

The pg_hba.conf file contains host-based authentication information. If you can't run the SQL scripts that generate the Jackrabbit and Quartz databases, it's probably because the default user accounts for each database don't have the right permissions. To change this, edit the file to ensure that connections from local users created by the Pentaho sql scripts (such as pentaho_user) will be able to connect. The default on Debian-based systems is for local connections you use ident authentication, which means that database users must have local user accounts. In other words, to continue using ident, you would have to create a local pentaho_user account. It's easier to just change the authentication method to something less restrictive, if your IT manager allows that approach.