Step 1: Change default passwords

For your production server, follow best practices to change the default passwords in the following SQL script files to make the databases more secure.

Note: If you are evaluating Pentaho, you might want to skip this step.

1. Browse to the <*your pentaho directory*>/pentaho-server/data/postgresql folder.

2. Use any text editor to modify these create scripts as needed according to your existing setup for the user, password, database, and other required information:

   • create_jcr_postgresql.sql

   • create_quartz_postgresql.sql

   • create_repository_postgresql.sql

   • pentaho_mart_postgresql.sql

3. Save and close the files.