Unable to use the database init scripts for PostgreSQL

The pg_hba.conf file contains host-based authentication information. If you cannot run the SQL scripts that generate the Jackrabbit and Quartz databases, it is probably because the default user accounts for each database do not have the right permissions.

To change these permissions, 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. An easier resolution might be to just change the authentication method to something less restrictive. Consult your IT manager to assess if this approach is possible.